Create Table Construct An SQL relation is defined using the create table command: create table r(A1 D1,A2 D2,...,An Dn (integrity-constraint ) (integrity-constraintk)) 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 branch (branch name char(15)not null, branch_city char(30), assets integer) Database System Concepts,5th Edition,Oct 5,2006 3.6 @Silberschatz,Korth and SudarshanDatabase System Concepts, 5 3.6 ©Silberschatz, Korth and Sudarshan th Edition, Oct 5, 2006 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 branch (branch_name char(15) not null, branch_city char(30), assets integer)