Skip navigation links

MySQL Forums :: Database Design & Data Modelling :: Database Design Question, Normalizing


Advanced Search

Database Design Question, Normalizing
Posted by: ph0b0s ()
Date: March 09, 2006 01:41AM

Hi.

Assuming, I have four tables.

customer:
cid(Primary Key) | cname | cremarks

servers:
sid (PK) | sname | sremarks

MAC-addresses:
mid (PK) | mac | mremarks

and a table which connects a customer to its servers and MACs.
csm:
csmid| cid | sid | mid
1 | 2 | 3 | 4
2 | 2 | 3 | 5
3 | 2 | 4 | 7
4 | 3 | 5 | 8

One Customer can have many Servers, but every Server belongs to ONE customer. Every Server has multiple MACs, but each MAC has only one server.

My question is, violates csm the third normal form, or not? Would be nice, if someone can help me out. Thanks.

Bye.

Options: ReplyQuote


Subject Written By Posted
Database Design Question, Normalizing ph0b0s 03/09/2006 01:41AM
Re: Database Design Question, Normalizing Jay Pipes 03/09/2006 09:45AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.