首页>计算机>软件水平考试>复习指导>正文
计算机软件水平考试:数据库原理上机题目汇总

www.zige365.com 2008-11-30 13:50:22 点击:发送给好友 和学友门交流一下 收藏到我的会员中心
题目:

  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)

本新闻共4页,当前在第3页  1  2  3  4  

我要投稿 新闻来源: 编辑: 作者:
相关新闻
软考辅导:论软件工程中的分工协作是否真地有效2
计算机软件水平考前辅导:电子商务冲击传统分销
软考辅导:中小企业的CIO—别隔着门谈信息化
软考辅导:ARP欺骗木马程序入侵电脑系统破坏严重
软考辅导:MSN照片病毒通过MSN软件疯狂传毒