您现在的位置:学赛首页 > 自考学院 > 数据库原理 > 正文
数据库原理上机题目汇总[3]
http://www.educity.cn 作者:不详 来源:自考365 2007年3月6日 发表评论 进入社区

  题目:

  1 按要求完成该四个表的创建,请使用原英文表名和属性名(满足上述表的每个约束要求)。

  2 完成每个表中的数据的插入
  Agent (01,'Smith',10000);
  (02,'Jones',7000);
  (03, 'Brown',5000);
  (04, 'Gray',7200);
  (05,'Otasi',4800);
  (06, 'Jack',5500);
  insert into Agent9527 values('01','Smith',10000)
  insert into Agent9527 values('02','Jones',7000)
  insert into Agent9527 values('03', 'Brown',5000)
  insert into Agent9527 values('04', 'Gray',7200)
  insert into Agent9527 values('05','Otasi',4800)
  insert into Agent9527 values ('06', 'Jack',5500)
  Customer (001,'TipTop');
  (002,'Basics');
  (003,'Allied');
  (004, 'ACME');
  (005, 'ACME');
  insert into Customer9527 values ('001','TipTop')
  insert into Customer9527 values('002','Basics')
  insert into Customer9527 values('003','Allied')
  insert into Customer9527 values('004', 'ACME')
  insert into Customer9527 values('005', 'ACME')
  Product (01,'comb',0.5)
  (02,'brush',0.5);
  (03,'razor',1)
  (04,'pen',1)
  (05, 'pencil',1)
  insert into Product9527 values('01','comb',0.5)
  insert into Product9527 values('02','brush',0.5)
  insert into Product9527 values('03','razor',1)
  insert into Product9527 values('04','pen',1)
  insert into Product9527 values ('05', 'pencil',1)
  Orders (1011, '2002-4-8',001, 01, 01, 1000, 450)
  (1012,'2001-4-1',001, 02, 02, 400, 180)
  (1013,'2002-1-1',002, 03, 03, 1000, 880)
  (1014,'2001-5-1',002, 05, 03, 800, 704)
  (1015,'2002-1-1',003, 03, 05, 1200, 1104)
  (1016,'2001-8-1',004, 06, 01, 1000, 460)
  (1017,'2002-9-1',005, 01, 04, 1000, 500)
  (1018,'2001-3-6',005, 01, 01, 800, 400)
  insert into Orders9527 values ('1011', '2002-4-8','001', '01', '01', 1000, 450)
  insert into Orders9527 values ('1012','2001-4-1','001', '02', '02', 400, 180)
  insert into Orders9527 values ('1013','2002-1-1','002', '03', '03', 1000, 880)
  insert into Orders9527 values ('1014','2001-5-1','002', '05', '03', 800, 704)
  insert into Orders9527 values ('1015','2002-1-1','003', '03', '05', 1200, 1104)
  insert into Orders9527 values ('1016','2001-8-1','004', '06', '01', 1000, 460)
  insert into Orders9527 values ('1017','2002-9-1','005', '01', '04', 1000, 500)
  insert into Orders9527 values ('1018','2001-3-6','005', '01', '01', 800, 400)

[1]  [2]  [3]  [4]