Question

Submit: a properly normalized ERD in class standard ERD format for the Property Spreadsheet: Given the following spreadsheet: PID COUNTY 1234 Cobb 1235 Cherokee 1236 Fulton 1237 Clark 1238 Cowetta 1239 Cobb 1240 Cobb 1241) Cobb 1242 Cherokee 1243 Doughery 1244 Fulton 1245 Fulton LOT AREA PRICE TAX 100 A $ 456k| .05 200 B S 496 .05 300 C S 376 .07 400 D S 145k| .06 500 E S 115 .06 100 A S 456k .05 100 B S 496k| .05 200 B S 496k .05 200 B S 496k| .05 600 F $ 98k| .06 100 A S 456k 07 300 C S 376 .07 We have learned that: 1) PID = Property ID and the lot number has to do with the PID 2) the price of the property actually depends upon the area that it is in 3) the tax is based upon the county that the property is in. Thoughts: Examine the data in the spreadsheet carefully. How many tables do you see in the database? What fields belong in each table? What are the Pks and the FKs? Submit: A class standard ERD showing a normalized database.

Answer 1

Answer is as follows :

Normalized ERD for given Scenario is as follows :

PROPERTY PK PID County Lot BELONGS TO FK FK Area Code PID PK AREA Area Code Price Tax

There are Three Tables in Genereated ERD :

• Property
• Area
• Belongs To

These Entities contains Following Attributes :

• Property - PID , County, LOT
• Area - Area Code, Price, Tax
• Belongs To - PID , Area Code

PK Defines Primary Key

FK defines Foreign key.

Relationship for these entities are :

• One Property belongs to only one area
• One area can contain multiple properties.

if there is any query please ask in comments..