Create the Hotel table using the integrity enhancement features of SQL.

What will be an ideal response?


CREATE DOMAIN HotelNumber AS CHAR(4);
CREATE TABLE Hotel(
hotelNo HotelNumber NOT NULL,
hotelName VARCHAR(20) NOT NULL,
city VARCHAR(50) NOT NULL,
PRIMARY KEY (hotelNo));

Computer Science & Information Technology

You might also like to view...

Where is the Page Header located?

A) Top of each page B) Top of form/report C) At the end of each group D) Bottom of each page

Computer Science & Information Technology

When criminals use computers to help them steal confidential organizational data, a computer-assisted crime has occurred

Indicate whether the statement is true or false.

Computer Science & Information Technology

Which free Web server was originally created for the UNIX/Linux platforms, but now runs on multiple operating systems (including Windows)?

A. Internet Information Services (IIS) B. Apache HTTP Server C. Google Chrome D. IMAP4

Computer Science & Information Technology

A single-purpose system, such a point-of-sale machine (cash register), is an example of what type of computer?

A. Thick client B. Thin client C. Workstation D. Server

Computer Science & Information Technology