题目:
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)