Question 3 Normalisation [20 marks) Table 1 shows data about properties rented to clients in Auckland. It also shows det

[answerhappygod]

Question 3 Normalisation 20 Marks Table 1 Shows Data About Properties Rented To Clients In Auckland It Also Shows Det 1 (82.38 KiB) Viewed 113 times

Question 3 Normalisation [20 marks) Table 1 shows data about properties rented to clients in Auckland. It also shows details of the owners who own the property. clientie property:No sName PAddress rent Start rentFinish rent owner No Name CR76 PG4 John Key 1-Jul-13 31-Aug-14 350 C040 Tina Murphy PG16 CR76 1-Sep-14 1-Sep-15 450 C093 Tony Brunt PG4 CR56 6 Lawrence St, Auckland 5 Novar Dr. Auckland 6 Lawrence St. Auckland 2 Manor Rd, Auckland 5 Novar Dr, Auckland 1-Sep-12 10-Jun-13 350 C040 Tina Murphy John Key Alice Stewart Alice Stewart Alice Stewart PG36 C093 CR56 10-Oct-13 1-Dec-14 375 Tony Brunt PG16 C093 CR56 1-Nov-15 10-Aug-16 450 Tony Brunt Table 1: A sample report - "List of properties by clients and owners” a. In what level of normalisation is the above relation? Justify your answer. (3 marks) b. Derive a set of relations in third normal form (3NF), using the data shown in Table 1. Clearly show each step of normalisation - UNF, INF, 2NF, and 3NF. Remember to show all primary keys in each relation with a solid underline and foreign keys with a dashed underline. (12 marks) c. Draw an ER diagram from the derived 3NF relations and include all attributes, primary keys, foreign keys, cardinality and participation. (5 marks)