1、根据.上述语义画出ER图。
2、将ER模型转换成数据表,并指出每个数据表的主键。
3、根据建立的数据表,在SQL Server 2008中建表
0F7DYUMHJ5TM1Y6YCY0Y42N.jpg
use ldz2017270397
create table cashier
(
id int not null primary key,
name varchar(20)not null,
password varchar(30) not null,
tel varchar(40),
);
create table storekeeper
(
number varchar(50),
id int not null primary key,
name varchar(20)not null,
password varchar(30) not null,
tel varchar(40),
);
create table provider
(
id int not null primary key,
name varchar(20)not null,
wheee varchar(50) not null,
people varchar(20),
tel varchar(40),
);
create table goods
(
id int not null primary key,
name varchar(20)not null,
price varchar(30) not null,
);
insert into storekeeper
values(2001,'郭靖','123','15888888888'),
(2002,'张无忌','123','15988888888'),
(2003,'令狐冲','123','15588888888'),
(2004,'老张','123','15388888888');
select*from storekeeper;
insert into cashier
values(2001,'郭靖','123','15888888888'),
(2002,'张无忌','123','15988888888'),
(2003,'令狐冲','123','15588888888'),
(2004,'老张','123','15388888888');
select*from cashier ;
insert into goods
values(2001,'猪宝贝','123'),
(2002,'亲嘴烧','123'),
(2003,'辣条','123'),
(2004,'老干妈','123');
select*from goods ;
insert into provider
values(2001,'辣条','重庆','周三','18711111111'),
(2002,'猪宝贝','上海','李四','18722222222'),
(2003,'亲嘴烧','北京','王麻子','18733333333'),
(2004,'老干妈','湖北','张全蛋','18744444444');
select*from provider ;```