Consider the database schema below for cities in countries. A country have many cities, and the same city name can be found in different countries. Country (ID: integer, Name: String (unique)) City...



Consider the database schema below for cities in countries. A country have many cities, and the same city name can be found in different countries.



Country (ID: integer, Name: String (unique))


City (serialNo: integer (unique, not null), CountryID: Integer, CityName: String, Population: integer)



A city can have unknown CityName?

































No, violates domain constraints.






Yes.






No, violates entity Integrity constraint





No, violates key constraint.





No, violates referential integrity constraint.






Jun 02, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here