Stanley Petley
INFO 1103 ASSIGNMENT 4
CREATE TABLE MassageTherapist(
therapistID int identity,
 name varchar(30),
DOB int,
roomID int,
CONSTRAINT roomID_fk FOREIGN KEY(roomID) REFERENCES room(roomID)
CONSTRAINT therID_pk PRIMARY KEY(therapistID))
CREATE TABLE THERAPISTPHONE(
TPhoneID int identity,
PhoneNumber varchar(11),
CONSTRAINT TPhoneID_pk PRIMARY KEY(TPhoneID))
CREATE TABLE CLIENTPHONE(
CPhoneID int identity,
PhoneNumber varchar(11),
CONSTRAINT CPhoneID_pk PRIMARY KEY(CPhoneID))
CREATE TABLE Client(
ClientID int identity,
TherapistID int,
Name varchar(30),
phoneNum varchar(11),
CONSTRAINT clientID_fk PRIMARY KEY(clientID),
CONSTRAINT therID_fk FOREIGN KEY(therapistID) REFERENCES MessageTherapist(therapistID))
CREATE TABLE Books(
Actualprice money,
ClientID int identity,
ApptID int identity,
CONSTRAINT apptclient_pk PRIMARY KEY(clientID,apptID))
CREATE TABLE Appointment(
ApptID int identity,
Price money,
Length int,
Date date,
clientID int ,
therapistID int,
roomID int,
CONSTRAINT apptID_pk PRIMARY KEY(ApptID),
CONSTRAINT clientID_fk FOREIGN KEY(clientID) REFERENCES Client(clientID),
CONSTRAINT therID_fk FOREIGN KEY(therapistID) REFERENCES MassageTherapist(therapistID),
CONSTRAINT roomID_fk FOREIGN KEY(roomID) REFERENCES Room(roomID))
CREATE TABLE TherapistAvailability(
EmploymentTypeID int identity,
TherapistID int,
CONSTRAINT therapistID_fk FOREIGN KEY(TherapistID) REFERENCES MassageTherapist(TherapistID)
CONSTRAINT therapistavail_pk PRIMARY KEY(EmploymentTypeID, TherapistID))
 CREATE TABLE Room(
RoomID int identity,
CONSTRAINT roomID_pk PRIMARY KEY(RoomID))