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
March 09, 2006 01:41AM


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.