ER图 建立数据库

ER图 建立数据库

CREATE TABLE pharmaceutical_company(
company_name char NOT NULL,
phone_no int,
address char,
PRIMARY KEY (company_name)) ;

CREATE TABLE pharmacy(
pharmacy_name char NOT NULL,
p_address char,
p_phone_no int,
PRIMARY KEY (pharmacy_name));

CREATE TABLE sells(
price int,
trade_name char,
pharmacy_name char,
FOREIGN KEY (trade_name) REFERENCES drug(trade_name),
FOREIGN KEY (pharmacy_name) REFERENCES pharmacy (pharmacy_name)) ;

CREATE TABLE contract(
contrat# char NOT NULL,
start_date date,
end_date date,
text_of_contract char,
pharmacy_name char,
company_name char,
PRIMARY KEY (contrat#),
FOREIGN KEY (company_name) REFERENCES CELL (company_name),
FOREIGN KEY (pharmacy_name) REFERENCES pharmacy (pharmacy_name)) ;

CREATE TABLE doctor (
d_number int NOT NULL,
d_name char,
specialty char,
years_of_experience int,
PRIMARY KEY (d_number)) ;

CREATE TABLE patient(
sin int NOT NULL,
name char,
age int,
patient_address char,
d_number int,
PRIMARY KEY (sin),
FOREIGN KEY (d_number) REFERENCES doctor (d_number)) ;

CREATE TABLE drug (
trade_name char NOT NULL,
formula char,
company_name char,
PRIMARY KEY (trade_name),
FOREIGN KEY (company_name) REFERENCES CELL (company_name),
FOREIGN KEY (CELLID) REFERENCES CELL (CELLID)) ;

CREATE TABLE prescription (
prescription_id int NOT NULL
sin int,
d_number int,
date date,
quantity char,
trade_name char,
PRIMARY KEY (prescription_id),
FOREIGN KEY (sin) REFERENCES patient (sin),
FOREIGN KEY (d_number) REFERENCES doctor (d_number),
FOREIGN KEY (trade_name) REFERENCES drug (trade_name)) ;

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息