Using the form below and a sample un-normalized table containing all related attributes and sample data, develop a set of database tables that are normalized to 3NF.  Then create a corresponding ER diagram (the ER diagram needs to show cardinality/optionality).

 

clientNo cName property No pAddress CR76 CR56 John PG4 Kay Aline Stewart PG16 PG4 PG36 PG16 6 Lawrence St, 1-Jul-03 Glasgow rentStart rentFinish rent ownerNo oName 2 Manor Rd, Glasgow 31-Aug-04 350 5 Novar Dr, 1-Sep-04 1-Sep-05 450 CO93 Glasgow 5 Novar Dr, Glasgow CO40 6 Lawrence St, 1-Sep-02 10-June-03 350 CO40 Glasgow 10-Oct-03 1-Dec-04 375 CO93 1-Nov-05 10-Aug-06 450 CO93 Tina Murphy Tony Shaw Tina Murphy Tony Shaw Tony Shaw