Q11 (10 pts) Write SQL to create a table called City in your account. The schema

Question

Q11 (10 pts) Write SQL to create a table called City in your account. The schema of the table is listed below. You must define the data types and not null constraint (if needed) of every column and all the primary key and foreign key constraints for the table. No screenshot needed for this question.

City (Name, Country, Population, Capital).
Name: the name of the city. Text string with maximum 50 characters. Must not be null.

Country: the name of the country where this city belongs to. It is a foreign key referencing the name column of the country table. Could be null.

Population: integer with up to 11 digits. Population of the city. Could be null.
Capital: one character (fixed length). ‘Y’ for capital cities and ‘N’ otherwise. Could be null.

Explanation / Answer

THe Sql query is given below based on your requirement

SQL> CREATE TABLE City(Name varchar(50),

Country varchar(50),

Population int(11) NOT NULL,

Capital char(1),

PRIMARY KEY (Name),

FOREIGN KEY REFERENCES Country(Name));

Hope This Helps, if you have any doubts Please comment i will get back to you, thank you and please thumbs up

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

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