Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Reporting Financial Statement Analysis And Valuation A Strategic Perspective

Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw

9th Edition

1337614689, 1337614688, 9781337668262, 978-1337614689

More Books

Students also viewed these Programming questions