SQL MS Access 2010 How to create table with relationship using SQL command HD
1) CREATE TABLE Customer(CustId AUTOINCREMENT(1, 1) NOT NULL CONSTRAINT PK_CustId PRIMARY KEY ,First CHAR(50) NOT NULL,Surname CHAR(50) NOT NULL,Addr1 CHAR(100) NOT NULL,Addr2 CHAR(100) NOT NULL,Addr3 CHAR(100) NOT NULL,Postcode CHAR(50) NOT NULL,Joined DATETIME NOT NULL); 2) CREATE TABLE DVD(DVDId AUTOINCREMENT(1, 1) NOT NULL CONSTRAINT PK_DVDId PRIMARY KEY,Name CHAR(200) NOT NULL,Category CHAR(100) NOT NULL,Released DATETIME NOT NULL,Cost Number NOT NULL,TimeR INTEGER); 3) CREATE TABLE Rental(Reference AUTOINCREMENT(1,1) NOT NULL PRIMARY KEY,CustId INTEGER NOT NULL REFERENCES Customer (CustId),DVDId INTEGER NOT NULL REFERENCES DVD (DVDId),Borrow DATE NOT NULL,Return DATE NOT NULL,Cost Number NOT NULL);
Похожие видео
Показать еще