Create Table Construct An SQL relation is defined using the create table command: create table r(A D1,A2 D2,...An Dn (integrity-constraint ) (integrity-constraint)) r is the name of the relation each A;is an attribute name in the schema of relation r D;is the data type of values in the domain of attribute A, Example: create table instructor D char(5). name varchar(20), dept_name varchar(20), salary numeric(8,2)) Database System Concepts-6th Edition 3.6 @Silberschatz,Korth and SudarshanDatabase System Concepts - 6 3.6 ©Silberschatz, Korth and Sudarshan th Edition Create Table Construct An SQL relation is defined using the create table command: create table r (A1 D1 , A2 D2 , ..., An Dn , (integrity-constraint1 ), ..., (integrity-constraintk )) r is the name of the relation each Ai is an attribute name in the schema of relation r Di is the data type of values in the domain of attribute Ai Example: create table instructor ( ID char(5), name varchar(20), dept_name varchar(20), salary numeric(8,2))