CREATE DATABASE westlake
GO
USE westlake
GO
CREATE TABLE Patient ( first_name VARCHAR(10) NOT NULL
, last_name VARCHAR(10) NULL
, DOB DATE NOT NULL
, SSN VARCHAR(10) NOT NULL
, gender CHAR(1) NOT NULL
, D_EID INTEGER NULL
, address VARCHAR(50) NOT NULL
, email VARCHAR(30) NULL
, phone VARCHAR(10) NOT NULL
)
GO
ALTER TABLE Patient ADD CONSTRAINT Patient_PK PRIMARY KEY CLUSTERED
(SSN)
GO
CREATE TABLE Prescription ( prescribed_date DATE NOT NULL
, prescription_num INTEGER NOT NULL
, Dr_Note VARCHAR(50) NULL
, Item_number INTEGER NULL
)
GO
ALTER TABLE Prescription ADD CONSTRAINT Prescription_PK PRIMARY KEY
CLUSTERED (prescription_num)
GO
CREATE TABLE Medical_stock (
Item_number INTEGER NOT NULL
, drug_name VARCHAR(25) NOT NULL
, status VARCHAR(20)