This site works best with JavaScript enabled. Please enable JavaScript to get the best experience from this site.
Thanks in advance for any help given. =)
CREATE TABLE School7 (
schoolNo numeric,
schoolAddress varchar (20),
schoolType varchar (50),
phoneNo numeric,
email varchar (50),
PRIMARY KEY (schoolNo)
);
CREATE TABLE Staff7 (
staffId varchar (50),
firstName varchar (50),
lastName varchar (50),
category varchar (50),
DOB varchar (10),
schoolNo numeric,
PRIMARY KEY (staffId),
FOREIGN KEY (schoolNo) REFERENCES School7
);
CREATE TABLE StaffContact7 (
staffId varchar (50),
phoneNo numeric,
mobileNo numeric,
email varchar (50),
PRIMARY KEY (staffId),
FOREIGN KEY (staffId) REFERENCES Staff7 (staffId)
);
CREATE TABLE Administers7 (
staffId varchar (50),
requestNo numeric,
schoolNo numeric,
PRIMARY KEY (staffId),
FOREIGN KEY (staffId) REFERENCES Staff7(staffId),
FOREIGN KEY (schoolNo) REFERENCES School7(schoolNo)
);
CREATE TABLE Applicants7 (
applicantId varchar (50),
firstName varchar (50),
lastName varchar (50),
category varchar (50),
DOB varchar (10),
staffId varchar (50),
PRIMARY KEY (applicantId),
FOREIGN KEY (staffId) REFERENCES Administers7(staffId)
);
CREATE TABLE ApplicantContact7 (
applicantId varchar (50),
phoneNo numeric,
mobileNo numeric,
email varchar (50),
PRIMARY KEY (applicantId),
FOREIGN KEY (applicantId) REFERENCES Applicants7(applicantId)
);
CREATE TABLE Subjects7 (
subjectNo varchar (50),
courseName varchar (50),
courseType varchar (50),
duration varchar (50),
applicantId varchar (50),
PRIMARY KEY (subjectNo),
FOREIGN KEY (applicantId) REFERENCES Applicants7(applicantId)
);
CREATE TABLE Payment7 (
accountNo numeric,
hourlyRate numeric,
bankName varchar (50),
taxNo numeric,
applicantId varchar (50),
PRIMARY KEY (accountNo),
FOREIGN KEY (applicantId) REFERENCES Applicants7(applicantId)
);
CREATE TABLE Qualifications7 (
certificateName varchar (50),
yearObtained varchar (50),
yearsofExperience numeric,
selfRating numeric,
institute varchar (50),
applicantId varchar (50),
FOREIGN KEY (applicantId) REFERENCES Applicants7(applicantId)
);
CREATE TABLE Address7 (
strNo numeric,
citysuburb varchar (50),
postcode numeric,
applicantId varchar (50),
FOREIGN KEY (applicantId) REFERENCES Applicants7(applicantId)
);
CREATE TABLE Availability7 (
whatDate varchar (100),
timeslot varchar (50),
amountHours numeric,
applicantId varchar (50),
FOREIGN KEY (applicantId) REFERENCES Applicants7(applicantId)
);
CREATE TABLE Phone7 (
phoneNo numeric,
mobileNo numeric,
firstName varchar (50),
lastName varchar (50),
applicantId varchar (50),
FOREIGN KEY (applicantId) REFERENCES Applicants7(applicantId)
);