Database Design Question, Normalizing
Date: March 09, 2006 01:41AM
Assuming, I have four tables.
cid(Primary Key) | cname | cremarks
sid (PK) | sname | sremarks
mid (PK) | mac | mremarks
and a table which connects a customer to its servers and MACs.
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.
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.