Re: Regarding Database Design

From: Geoff Muldoon <geoff.muldoon_at_trap.gmail.com>
Date: Mon, 11 May 2009 16:10:34 +1000
Message-ID: <MPG.24726c645b5794c5989753_at_news.x-privat.org>



DeB says...

> I've with me a proposed database design which is not normalized
> fully.

Why?

> For ex:- We have a table called user_groups which links the users
> and the groups table. But now we are thinking to eliminate this table
> and have a group_ids column storing comma separated values of groups
> ids from the groups table instead.

Again, WHY??

> The records will look like -
>
> groups
> ------
>
> group_id group_name
> 1 Admin
> 2 Operator
> 3 Power User
>
>
> users
> ------
>
> user_id user_name group_ids
> 1 User1 1,3
> 2 User2 2,3
>
>
> The targeted database will be a typical OLTP system. Please suggest
> if this approach to database design has any fundamental flaws.

How do you intend to enforce referential integrity?

GM Received on Mon May 11 2009 - 01:10:34 CDT

Original text of this message