create your own 15 queries that would be used by the University Unit management team to help them in their daily activities of using the database..

****use SQL commands to write your 15 queries..

CREATE TABLE Department (Department_id VARCHAR(1.) PRIMARY KEY, Department.name VARCHAR(30)); CREATE TABLE Facility (Facility_id INT PRIMARY KEY TOENTITY, Facility.na name VARCHAR(20) NOT NULL, Status VARCHAR (6) NOT NOI); .name CREATE TABLE Staff (Staff.id VARCHAR (0) PRMARY KAY, Staff-ne VARCHAR (20) NOT NUL, address VARCHAR(x0), phone Number VARCHAR(10), Sex CHAR(I) NOT NOUL Department.id ARCHAROO) FOREIGN KEY REFERENCES Department (Department.id) CREATE TABLE Student (student.id VARCHAR (0) PRIMARY KEY, Student name VARCHAR (0) NOT NULL, address VARCHAR (O), Phone Number VARCHAR(10), Sex CHARO NOT NUH, Department.id VARCHAR (10) POREIGN KEY REFERENCES Department (Oppartment, id); CREATE TABLE Smartcard (Smartcard_id VARCHARCO) PRIMARY KEY, student.id VARCHAR (16) FOREIGN KEY REFERENCES Student (student_id), Staff_id VARCHAR UIO) POPEIAN KEY REFERENCES Staff (staff_id), Fupiny-date DATE); REPE PENCES CREATE TABLE Booking (Booking.id VARCHAR . CIO) PRIMARY KEY, Smartcard.id VARCHAR CIO) POREIGN KEY Smartcard (Smartcard_id), Facility_id VARCHAR(10) FOREIGN KEY REFERENCES Facility (facility-id), Position VARCHAR(10) NOT NOW, Braking - datetime DATETIME); CREATE TABLE Biometric (Biometric.id VARCHAR(IO) PRIMARY MEY, Smartcarel_iel VARCHAR (10) FOREIGN KEY REFERENCES Smart card. (Smartcard.id), Position VARCHAR(10) NOT NU)