I can't normalize these tables
Posted by: Farhan Qazi
Date: August 31, 2011 10:55AM

I am in the process of normalization of my database which deals with clients information. I have made one table for clients information in which `client id` is Primary Key.
The problem is that the clients can have either A type of company or B type of company and depending on the TYPE of company, the details needed will be changed like if A type of company then only name should be stored, and if B type of company then name, registration date, accounts info should be stored.
I thought that i should use the PRIMARY KEY of CLIENTS table 'client id' as the PRIMARY key for the A type table and B type table, hence using the same PRIMARY KEY in three tables to relate the data to the same client.
Please advise me what is the best way to achieve best normalization.

Options: ReplyQuote


Subject
Written By
Posted
I can't normalize these tables
August 31, 2011 10:55AM
September 02, 2011 09:48AM


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.