Question: PART III Using the form below and a sample un-normalized table containing all related attributes and sample data, develop a set of database tables that

 PART III Using the form below and a sample un-normalized table

PART III 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). DreamHome Lease DreamHome Lease Dream Home Lease DreamHome Lease Property Number PG4 Client Number CR76 (Enter if known) Property Address 6 Lawrence St. Glasgow Full Name (Please print) John Kay Monthly Rent 350 Owner Number 0040 (Enter if known) Rent Start 0107103 Tina Murphy Full Name (Please print) Rent Finish 31/08/04 clientNo Name property No pAddress rentStart rentFinish rent ownerNo Name CR76 John PG4 31-Aug-04 350 C040 Tina Murphy Kay 6 Lawrence St, 1-Jul-03 Glasgow 5 Novar Dr, 1-Sep-04 Glasgow PG16 1-Sep-05 450 C093 Tony Shaw CR56 PG4 Aline Stewart 350 C040 Tina Murphy PG36 375 C093 Tony Shaw 6 Lawrence St, 1-Sep-02 10-June-03 Glasgow 2 Manor Rd, 10-Oct-031-Dec-04 Glasgow 5 Novar Dr, 1-Nov-05 10-Aug-06 Glasgow PG16 450 C093 Tony Shaw

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