The following database will be used in this question:GENERAL SALES ...

The SQL statement CREATE TABLE forms the basis for all SQL table construction. CREATE TABLE is used to name tables and specify their structure, including column names and their associated data types. In addition, CREATE TABLE can be used to define primary keys, foreign keys, and to specify constraints on tables, columns and column values. There are five SQL keywords that specify these constraints: PRIMARY KEY, FOREIGN KEY, NULL/NOT NULL, UNIQUE, and CHECK. PRIMARY KEY and FOREIGN KEY are used to specify keys. NULL and NOT NULL specify whether nulls are allowed as values in a column. UNIQUE specifies whether the column values must be unique. The SQL keyword CONSTRAINT may be used to specify some of the table constraints. For example, to create the SALESREP table for the General Sales database, the following SQL statement may be used:

CREATE TABLE SALESREP (

​

SalesRepNo

Integer

Not Null,

​

RepName

Char(25)

Not Null,

​

HireDate

Date

Not Null,

​	CONSTRAINT SalesRepPK PRIMARY KEY (SalesRepNo)

);
Note to the instructor: The data type of HireDate is shown as Date, which is the ORACLE data type shown in the text. Students may also use Datetime, which is the SQL Server data type, which is also shown in the text.

Appreciate the effort, thank you!