Create three or more SQL Data Control Language (DCL) Statements using the Homework Database: for the Little League Lacro

[answerhappygod]

Create three or more SQL Data Control Language (DCL)Statements using the Homework Database: for the Little LeagueLacrosse Team Database
HERE IS THE DATABASE:
DROP DATABASE IF EXISTS Lacrosse_DB;
CREATE DATABASE IF NOT EXISTS Lacrosse_DB;
USE Lacrosse_DB;
DROP TABLE IF EXISTS Student;
CREATE TABLE IF NOT EXISTS Student
(
student_Num VARCHAR(6),
student_Name VARCHAR(50),
dob DATE,
email VARCHAR(50),
date_Joined DATE,
CONSTRAINT Student_PK PRIMARY KEY(student_Num)
);
DROP TABLE IF EXISTS Team;
CREATE TABLE IF NOT EXISTS Team
(
school VARCHAR (50),
team_Name VARCHAR(50),
field_Location VARCHAR(50),
CONSTRAINT Team_PK PRIMARY KEY(school)
);
DROP TABLE IF EXISTS PlaysFor;
CREATE TABLE IF NOT EXISTS PlaysFor
(
surragate_key INT AUTO_INCREMENT,
StudentNum_FK VARCHAR(6),
school_FK VARCHAR(50),
CONSTRAINT PlaysFor_PK PRIMARY KEY(surragate_key),
CONSTRAINT PlaysFor_FK1 FOREIGN KEY (StudentNum_FK )
REFERENCES Student(Student_Num),
CONSTRAINT PlaysFor_FK2 FOREIGN KEY (School_FK )
REFERENCES Team(School)
);
DROP TABLE IF EXISTS Equipment;
CREATE TABLE IF NOT EXISTS Equipment
(
equip_Num VARCHAR (6),
equip_type VARCHAR(25),
equip_Name VARCHAR(50),
price DOUBLE,
CONSTRAINT Equipment_PK PRIMARY KEY(equip_Num)
);
DROP TABLE IF EXISTS Equip_Loan_Record;
CREATE TABLE IF NOT EXISTS Equip_Loan_Record
(
loanDate DATE,
Student_Num_FK VARCHAR(6),
record_Num INTAUTO_INCREMENT,
CONSTRAINT Equip_Loan_Record_PK PRIMARY KEY(record_Num),
CONSTRAINT Equip_Loan_Record_FK1 FOREIGN KEY (Student_Num_FK)
REFERENCES Student(Student_Num)
);
DROP TABLE IF EXISTS Loan_Detail_Item;
CREATE TABLE IF NOT EXISTS Loan_Detail_Item
(
detailNum INT AUTO_INCREMENT,
record_Num_FK INT,
equip_Num_FK VARCHAR(6),
CONSTRAINT Loan_Detail_Item_PK PRIMARY KEY(detailNum),
CONSTRAINT Loan_Detail_Item_FK1 FOREIGN KEY (record_Num_FK)
REFERENCES Equip_Loan_Record(Record_Num),
CONSTRAINT Loan_Detail_Item_FK2 FOREIGN KEY (equip_Num_FK)
REFERENCES Equipment(equip_Num)
);
DROP TABLE IF EXISTS Game;
CREATE TABLE IF NOT EXISTS Game
(
gameID VARCHAR(5),
gameDate DATE,
gameTime TIME,
CONSTRAINT Game_PK PRIMARY KEY(gameID)
);
DROP TABLE IF EXISTS ScheduledGame;
CREATE TABLE IF NOT EXISTS ScheduledGame
(
gameID_FK VARCHAR(5),
homeTeam_FK VARCHAR(50),
visitingTeam_FK VARCHAR(50),
CONSTRAINT ScheduledGame_PK PRIMARY KEY(gameID),
CONSTRAINT ScheduledGame_FK1 FOREIGN KEY (homeTeam_FK )
REFERENCES Team(school),
CONSTRAINT ScheduledGame_FK2 FOREIGN KEY (VisitingTeam_FK )
REFERENCES Team(school),
CONSTRAINT ScheduledGame_FK3 FOREIGN KEY (gameID_FK )
REFERENCES game(gameID)
);