Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
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