--1)编写SQL语句,根据范例,建立销售数据库Sales的以上三个表。
--要求要满足基本的实体完整性。
--2)编写SQL语句将示范数据插入到数据 库中。
--建立客户表Customer
create table Customer(
CusNo varchar2(10) primary key,
CusName varchar2(20) not null,
Address varchar2(50),
Tel varchar2(20) unique
)
--建立产品表Product
create table Product(
ProNo varchar2(10) primary key,
ProName varchar2(20),
price number(10,2),
Stocks int
)
--建立销售表ProOut
create table ProOut(
SalaDate date,
CusNo varchar2(10),
ProNo varchar2(10),
Quantity int,
foreign key (cusno) references Customer(cusno),
foreign key (prono) references Product(prono)
)
--在Customer中插入数据
insert into Customer values('C001','杨婷','北京','010-5328953');
insert into Customer values('C002','李和平','上海','021-6235965');
insert into Customer values('C003','叶新','成都','024-3222781');
insert into Customer values('C004','冯辰诚','上海','021-8726596');
insert into Customer values('C005','张展','郑州','0371-890765
--要求要满足基本的实体完整性。
--2)编写SQL语句将示范数据插入到数据 库中。
--建立客户表Customer
create table Customer(
CusNo varchar2(10) primary key,
CusName varchar2(20) not null,
Address varchar2(50),
Tel varchar2(20) unique
)
--建立产品表Product
create table Product(
ProNo varchar2(10) primary key,
ProName varchar2(20),
price number(10,2),
Stocks int
)
--建立销售表ProOut
create table ProOut(
SalaDate date,
CusNo varchar2(10),
ProNo varchar2(10),
Quantity int,
foreign key (cusno) references Customer(cusno),
foreign key (prono) references Product(prono)
)
--在Customer中插入数据
insert into Customer values('C001','杨婷','北京','010-5328953');
insert into Customer values('C002','李和平','上海','021-6235965');
insert into Customer values('C003','叶新','成都','024-3222781');
insert into Customer values('C004','冯辰诚','上海','021-8726596');
insert into Customer values('C005','张展','郑州','0371-890765