Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
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