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.
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.