Please decompose these three tables for better design. All three tables have zip

Question

Please decompose these three tables for better design. All three tables have zipcodes of LA.

Currently, Population table: Zipcode is unique

Business table: ID is unique, there may be mulitple businesses in one zipcode

Crimes table: ID is unique, there are mutiple crimes in one zipcode.

Name: Business Schema: Column ID StartDate CouncilDistrictINTI11) Zipoode BusinessType VARCHAR255) cclick to edits Datatypo INT(10) VARCHAR255) NUL NUL NUL NUL VARCHARI255) Name: Crimes Schema: PK NN Q BIN UN ZF AI G De Column ID CrmDes Status Zipcode click to edit Datatype INTI11) VARCHAR255) VARCHAR255) INT 11) NUI NUI NUI Name: Population Schema Datatype Column Zpcode TotalPopulation INTI11 MedianAge eclick to ed NL NL VARCHAR(255)

Explanation / Answer

Remove "councildistrict" in Business table and createnew table called District with zipcode as primary key and councildistrict as second column.

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.