Juan Rodriguez
Starting Member
1 Post |
Posted - 2009-08-11 : 13:49:09
|
Please help, I am totally new to SQL. Thanks CREATE TABLE SOFTWAREOBJECTS( PublicationTitle VARCHAR(40) NOTNULL, ISBN VARCHAR(10) NOT NULL, TrackingNumber INT NOT NULL, Price INT NOT NULL, Rating INT NULL, Website VARCHAR(40) NOT NULL UNIQUE, CONSTRAINT SOFTWAREOBJECTS_PK PRIMARY KEY PublicationTitle), CONSTRAINT AUTHOR_FK FOREIGN KEY(AuthorID) REFERENCES AUTHOR(AuthorId) ON UPDATE CASCADE );CREATE TABLE EMPLOYEE( EmployeeID VARCHAR(10) NOT NULL, LastName CHAR(20) NOT NULL, FirstName CHAR(20) NOT NULL, Address VARCHAR(40) NULL, CONSTRAINT EMPLOYEE_PK PRIMARY KEY(EmployeeID) );CREATE TABLE AUTHOR( AuthorID VARCHAR(10) NOT NULL, LastName CHAR(20) NOT NULL, FirstName CHAR(20) NOT NULL, Address VARCHAR(40) NOT NULL, RoyaltyPayments INT NOT NULL, NumberBooksSold INT NOT NULL, CONSTRAINT AUTHOR_PK PRIMARY KEY(AuthorID) );CREATE TABLE CUSTOMER( CustomerID VARCHAR(10) NOT NULL, LastName CHAR(20) NOT NULL, FirstName CHAR(20) NOT NULL, Address VARCHAR(40) NOT NULL, PhoneNumber CHAR(12) NOT NULL, Email VARCHAR(40) NOT NULL,UNIQUE, CONSTRAINT CUSTOMER_PK PRIMARY KEY(CustomerID) );CREATE TABLE SALESORDER( SalesTrackingNO VARCHAR(10) NOT NULL, Date DATETIME NOT NULL, Quantity INT NOT NULL, BillToAddress VARCHAR(40) NOT NULL, CreditCard CHAR(20) NOT NULL, ExpDate DATETIME NOT NULL, Tax INT NOT NULL, PromoCode VARCHAR(10) NULL, SubTotal INT NOT NULL, Total INT NOT NULL, CONSTRAINT SALESORDER_PK PRIMARYKEY SalesTrackingNO), CONSTRAINT EMPLOYEE_FK FOREIGN KEY(EmployeeID), CONSTRAINT CUSTOMER_FK FOREIGN KEY(CustomerID), CONSTRAINT SOFTWAREOBJECTS_FK PRIMARY KEY(PublicationTitle), REFERENCES SOFTWAREOBJECTS(PublicationTitle) ON UPDATE CASCADE );Juan Rodriguez |
|