Question: i) ii) iii) iv) Based on Figure 1, write down the unnormalised form. (5 marks) Identify the repeating group of attributes and transform part
i) ii) iii) iv) Based on Figure 1, write down the unnormalised form. (5 marks) Identify the repeating group of attributes and transform part (i) into tables that are in 1st Normal form. (Explain the rationale for your decision). (10 marks) Identify any partial dependencies in part (ii) and transform into tables that are in 2nd Normal Form. (Explain the rationale for your decision). (10 marks) Identify any transitive dependencies in part (iii) and transform into tables that are in 3rd Normal Form. (Explain the rationale for your decision). (10 marks) (Please clearly state all assumptions and ensure that you have sufficient annotations). Tax Invoice Number: 20220004 Client: Mary Ann Address: Blk 100 Bedok North Singapore 530100 Mobile: (065)-98253838 Pet Name Treatment Princess Respiratory Issue Heart Worm Test Total 9% Tax Total Payable Transaction Date: 22/2/1992 Gender: Credit Limit: Price $200.00 $350.00 $550.00 $49.50 $599.50 Figure 1. Client Tax Invoice Female $2,000
Step by Step Solution
3.48 Rating (164 Votes )
There are 3 Steps involved in it
Lets break down each part of the question and the steps taken to answer it i Unnormalized form Tax Invoice Number Transaction Date Client Name Gender Address Credit Limit Mobile Pet Name Treatment Pri... View full answer
Get step-by-step solutions from verified subject matter experts
