create database Shop

create table Department
(
	D_id int not null primary key identity(1,1),
	D_name varchar(50) not null,
	D_remark varchar(500)
)
create table Employee
(
	E_id int not null primary key identity(1,1),
	D_id int not null references Department(D_id),
	E_name varchar(10) not null,
	E_sex bit,
	E_age int,
	E_tel varchar(20),
	E_address varchar(20)
)
create table Product
(
	P_id int not null primary key identity(1,1),
	P_name varchar(50) not null,
	P_price money,
	P_remark varchar(100)
)