资源描述:
《中南大学大型数据库报告.doc》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
1、中南大学大型数据库报告学生姓名学院信息科学与工程学院专业班级计科120x《大型数据库技术》实验一1.创建一个本地位图管理表空间CAP_ts,表空间对应一个数据文件CAP_ts.dbf,该数据文件初始大小为20M,可以自动扩展。CREATETABLESPACECAP_tsdatafile'CAP_ts.dbf'size20Mreuseextentmanagementlocalautoallocate;ALTERDATABASEDEFAULTTABLESPACECAP_ts;2.在表空间CAP_ts中创建表Customers、Products和Ag
2、ents,其中列cid、pid、aid分别为这3张表的主键。向表中添加如下数据(可首先将表中数据放入EXCEL表,然后在SQLDeveloper中导入数据库)。CustomerscidcnamecitydiscntC001TipTopDuluth10.00C002BasicsDallas12.00C003AlliedDallas8.00C004ACMEDuluth8.00C005OrientalKyoto6.00C006ACMEKyoto0.00ProductspidpnamecityquantitypriceP01combDallas0.50
3、P02brushNewark0.50P03razorDuluth1.00P04PenDuluth1.00P05pencilDallas1.00P06folderDallas2.00P07caseNewark1.00AgentsaidanamecitypercentA01smithNewYork6A02JonesNewark6A03BrownTokyo7A04GrayNewYork6A05OtasiDuluth5A06SmithDallas5CREATETABLECustomers(cidVARCHAR(5)PRIMARYKEYNOTNULL,c
4、naemVARCHAR(10),cityVARCHAR(10),discountREAL);CREATETABLEProducts(pidVARCHAR(5)PRIMARYKEYNOTNULL,pnaemVARCHAR(10),ityVARCHAR(10),quantityNUMBER(10),priceREAL);CREATETABLEAgents(aidVARCHAR(5)PRIMARYKEYNOTNULL,anaemVARCHAR(10),cityVARCHAR(10),percentNUMBER(3));insertintoCustom
5、ersvalues('C001','TipTop','Duluth',10.00);insertintoCustomersvalues('C002','Basics','Dallas',12.00);insertintoCustomersvalues('C003','Allied','Dallas',8.00);insertintoCustomersvalues('C004','ACME','Duluth',8.00);insertintoCustomersvalues('C005','Oriental','Kyoto',6.00);inser
6、tintoCustomersvalues('C006','ACME','Kyoto',0.00);insertintoProductsvalues('P01','comb','Dallas',,0.50);insertintoProductsvalues('P02','brush','Newark',,0.50);insertintoProductsvalues('P03','razor','Duluth',,1.00);insertintoProductsvalues('P04','Pen','Duluth',,1.00);insertint
7、oProductsvalues('P05','pencil','Dallas',,1.00);insertintoProductsvalues('P06','folde','Dallas',,2.00);insertintoProductsvalues('P07','case','Newark',,1.00);insertintoAgentsvalues('A01','smith','NewYork',6);insertintoAgentsvalues('A02','Jones','Newark',6);insertintoAgentsvalu
8、es('A03','Brown','Tokyo',7);insertintoAgentsvalues('A04','Gray','NewYork',6