Course Solutions Uncategorized (Solved) : Create Table Staff Staffid Varchar 10 Primary Key Staffname Varchar 20 Staffrole Varchar 2 Q32397145 . . . .

(Solved) : Create Table Staff Staffid Varchar 10 Primary Key Staffname Varchar 20 Staffrole Varchar 2 Q32397145 . . . .

 

Customer Staff Staffld Staff name role Therapist CustomerlD(pk) F name L name Type 1.11..1 Therapistld (Pk) F name L name 1..1 1 1..1 1 Treatments Treatmentld(pk) Treatmentname Treatmenttvpe Fees Booking Bookingld(Pk) Date Time

CREATE TABLE Staff (
StaffId VARCHAR(10) PRIMARY KEY,
StaffName VARCHAR(20),
StaffRole VARCHAR(20)
);

CREATE TABLE Therapists (
TherapitId VARCHAR(10) PRIMARY KEY,
F_Name VARCHAR(20),
L_Name VARCHAR(20),
StaffId VARCHAR(10) FOREIGN KEY REFERENCES Staff
);

CREATE TABLE Customer (
CustomerId VARCHAR(10) PRIMARY KEY,
CustomerName VARCHAR(20),
);

CREATE TABLE Booking (
BookingId VARCHAR(10) PRIMARY KEY,
Booking_Date DATE,
Booking_Time time(7),
CustomerId VARCHAR(10) FOREIGN KEY REFERENCES Customer,
TherapistId VARCHAR(10) FOREIGN KEY REFERENCES Therapists
);

CREATE TABLE Treatments (
TreatmentId VARCHAR(10) PRIMARY KEY,
Treatment_Name VARCHAR(20),
Treatment_Type VARCHAR(20),
fees MONEY,
TherapistId VARCHAR(10) FOREIGN KEY REFERENCES Therapists
);

INSERT INTO Staff VALUES

OR

PayPal Gateway not configured

OR

PayPal Gateway not configured

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Post