Question: Which columns are included in the CityZipCode table, primary key, and foreign key? Table Primary key Foreign key CityID CityArea ZipCode CityName CityID 1 -
Which columns are included in the CityZipCode table, primary key, and foreign key?
Table
Primary key
Foreign key
CityID
CityArea
ZipCode
CityName
CityID
CityArea M
ZipCode MM
City
CityName M
Each city may have multiple zip codes, so ZipCode is a plural attribute. Implement ZipCode in the CityZipCode table, separate from the City table.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
