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
Step: 1
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...See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started