


Music
Playlist at
MixPod.com
CREATE TABLE Agent
(AgentID CHAR(10) NOT NULL,
AgentName VARCHAR(30) NOT NULL,
AgentAdd VARCHAR(40),
AgentTele VARCHAR(20),
CONSTRAINT PKAgent PRIMARY KEY (AgentID));
CREATE TABLE Category
(Pro_type CHAR(2) PRIMARY KEY NOT NULL,
Pro_typename VARCHAR(40)UNIQUE);
CREATE TABLE Product
(Prodno CHAR(4),
ProName VARCHAR(50) CONSTRAINT ProdNameRequired NOT NULL,
Pro_amount Int,
Pro_price Int,
Pro_type CHAR(8),
CONSTRAINT PKProduct PRIMARY KEY (Prodno),
CONSTRAINT pro_typeFK1 FOREIGN KEY (Pro_type) REFERENCES Category(Pro_type));
CREATE TABLE Purchase
(PurchNo CHAR(8) ,
PurchDate Date NOT NULL,
AgentID CHAR(10),
AgentTele VARCHAR(20),
NetTotal Int,
CONSTRAINT PKPurchase PRIMARY KEY (PurchNo),
CONSTRAINT AgentFK2 FOREIGN KEY (AgentID) REFERENCES Agent(AgentID));
CREATE TABLE PurchaseDetail
(PurchNo CHAR(8),
Prodno CHAR(4),
PurchQty INT NOT NULL,
PurchUnitCost Int,
NetTotal Int,
CONSTRAINT PKPurchaseD PRIMARY KEY (PurchNo,Prodno),
CONSTRAINT PurchDFK FOREIGN KEY (PurchNo) REFERENCES Purchase(PurchNo),
CONSTRAINT ProductFK FOREIGN KEY (Prodno) REFERENCES Product(Prodno));
0838053218
เปนอารายมั๊ยมีตังค์ป่าว
ยืมหน่อย3500จะปรัยหาแฟน
มั๊ยมีตังค์