Question: Below is the table structure of property purchasing record activity of Jebat Property Development Sdn Bhd. Staff of the company are responsible in handling

Below is the table structure of property purchasing record activity of Jebat 

Below is the table structure of property purchasing record activity of Jebat Property Development Sdn Bhd. Staff of the company are responsible in handling the loan agreement of the purchase for each buyer and property. Code Property Property Buyer Buyer Staff Address Code Name Code Staff Price Agreement Name (RM) Date Monthly Loan Installment Duration (RM) (years) SA125 12, Taman Sejati T204 Ahmad Zuk Abu OC011 260,000 12.2.2018 1,500 30 Bakar Utama Nazatul T205 OC011 Balqis Abu Bakar 100,000 20.2.2018 600 30 14, Taman Nazatul SA126 T205 OC012 Meru Jaya Balqis Mohd Saad 128,000 2.3.2018 750 38, Taman Alman Abu SU128 Sejati T206 OC011 Haziq Bakar 450,000 25.3.2018 2,800 Perdana 25 25 225 Raja Abu T208 OC011 50,000 4.4.2018 500 9 Hayati Bakar Notes: There might be more than one buyer for the same property a) State the stage of normalization for the above relational schema. Give TWO (2) reasons for your answer. b) List TWO (2) primary keys. c) List the partial and transitive dependencies. (3 marks) (2 marks) (3 marks) d) Normalize the table into 3NF. Show all works for each normalization stage. (7 marks) e) Draw the ERD to show the relationships among all the normalized tables. (5 marks)

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 Programming Questions!