每日总结44

今天学习了有关数据库的操作并进行上机实验

方括号内的属性为主键
S([SNO</u>]{主键},SNAME,STATUS,CITY);
P([PNO]{主键},PNAME,COLOR,WEIGHT);
J([JNO]{主键},JNAME,CITY);
SPJ([SNO，PNO，JNO]{主键}，QTY);
SNO为外键参照S(SNO),PNO为外键参照P(PNO),JNO为外键参照J(JNO);

表的创建

Use Master; 
CREATE Database CAP;
Use CAP; 
CREATE TABLE CUSTOMERS(    Cid char(8)  PRIMARY KEY NOT NULL,    Cname varchar(8) NOT NULL,    City varchar(8),    Discnt numeric(10,2));

CREATE TABLE AGENTS(    Aid char(8)  PRIMARY KEY NOT NULL,    Aname varchar(8) NOT NULL,    City varchar(8),    AgentsPercent int);

CREATE TABLE PRODUCTS(    Pid char(8) PRIMARY KEY NOT NULL,    Pname varchar(8) NOT NULL,    City varchar(8),     Quantity int,    Price numeric(10,2));

CREATE TABLE ORDERS(    Ordno char(8)  PRIMARY KEY NOT NULL,    OrdersMonth varchar(8),    cid varchar(8) NOT NULL,    aid varchar(8) NOT NULL,    pid varchar(8) NOT NULL,    Qty int,    Dollars numeric(10, 2));

增加实例

Use master; Use CAP;
 INSERT INTO CUSTOMERS VALUES('C001',' TipTip','Duluth', 10.00);
INSERT INTO AGENTS VALUES('A01',' smith','New York', 6);
INSERT INTO PRODUCTS VALUES('P01',' comb','Dallas', 111400, 0.50);
INSERT INTO ORDERS VALUES('1011','jan','C001', 'A01', 'P01', 1000, 450.00);