Question: Firstly, I have a client table with multivalued attributes: After turning the conceptual design to logical design, I have another table called Contacts for the

Firstly, I have a client table with multivalued attributes:

Firstly, I have a client table with multivalued attributes: After turning the

After turning the conceptual design to logical design, I have another table called Contacts for the multi-valued attribute:

conceptual design to logical design, I have another table called Contacts for

The question now is I have to do normalization on Contacts table but I have no idea how to do it. Based on my understanding, 1nf and 2nf have passed. But I am required to do at least one step of normalization. So how can I do 3nf for Contacts table?

Client Client_ID {PK} Client_name Client_address Client_phonenumber Client_interest Contacts [1..*] Record No Date Type Content Date_First_Purchase Latest_Purchase_Date Invoice_number {FK} Client Client_ID {PK} Contacts has 1...* 1... * generate Client_name 1...1 Client_address Client_phonenumber Client_interest Date_First Purchase Contacts_Record No {PK} Contacts_Date Contacts_Type Contacts Content Client_ID {FK} Latest_Purchase_Date Invoice_number {FK} Client Client_ID {PK} Client_name Client_address Client_phonenumber Client_interest Contacts [1..*] Record No Date Type Content Date_First_Purchase Latest_Purchase_Date Invoice_number {FK} Client Client_ID {PK} Contacts has 1...* 1... * generate Client_name 1...1 Client_address Client_phonenumber Client_interest Date_First Purchase Contacts_Record No {PK} Contacts_Date Contacts_Type Contacts Content Client_ID {FK} Latest_Purchase_Date Invoice_number {FK}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!