中南大学大型数据库报告中南大学大型数据库报告.doc

中南大学 大型数据库报告 学生姓名 学 院 信息科学与工程学院 专业班级 计科120x 《大型数据库技术》实验一 1．创建一个本地位图管理表空间CAP_ts，表空间对应一个数据文件CAP_ts.dbf，该数据文件初始大小为20M，可以自动扩展。 CREATE TABLESPACE CAP_ts datafile CAP_ts.dbf size 20M reuse extent management local autoallocate; ALTER DATABASE DEFAULT TABLESPACE CAP_ts; 2．在表空间CAP_ts中创建表Customers、Products和Agents，其中列cid、pid、aid分别为这3张表的主键。向表中添加如下数据(可首先将表中数据放入EXCEL表，然后在SQL Developer中导入数据库)。 Customers cid cname city discnt C001 TipTop Duluth 10.00 C002 Basics Dallas 12.00 C003 Allied Dallas 8.00 C004 ACME Duluth 8.00 C005 Oriental Kyoto 6.00 C006 ACME Kyoto 0.00 Products pid pname city quantity price P01 comb Dallas 111400 0.50 P02 brush Newark 203000 0.50 P03 razor Duluth 150600 1.00 P04 Pen Duluth 125300 1.00 P05 pencil Dallas 221400 1.00 P06 folder Dallas 123100 2.00 P07 case Newark 100500 1.00 Agents aid aname city percent A01 smith New York 6 A02 Jones Newark 6 A03 Brown Tokyo 7 A04 Gray New York 6 A05 Otasi Duluth 5 A06 Smith Dallas 5 CREATE TABLE Customers(cid VARCHAR(5) PRIMARY KEY NOT NULL,cnaem VARCHAR(10),city VARCHAR(10),discount REAL); CREATE TABLE Products(pid VARCHAR(5) PRIMARY KEY NOT NULL,pnaem VARCHAR(10),ity VARCHAR(10),quantity NUMBER(10),price REAL); CREATE TABLE Agents(aid VARCHAR(5) PRIMARY KEY NOT NULL,anaem VARCHAR(10),city VARCHAR(10),percent NUMBER(3)); insert into Customers values(C001,TipTop,Duluth,10.00); insert into Customers values(C002,Basics,Dallas,12.00); insert into Customers values(C003,Allied,Dallas,8.00); insert into Customers values(C004,ACME,Duluth,8.00); insert into Customers values(C005,Oriental,Kyoto,6.00); insert into Customers values(C006,ACME,Kyoto,0.00); insert into Products values(P01,comb,Dallas,111400,0.50); insert into Products values(P02,brush,Newark,203000,0.50); insert into Products values(P03,razor,Duluth,150600,1.00); insert into Products values(P04,Pen,Duluth,125300,1.00); insert int