Database Management Systems Final Project Part 1you Are

CREATE TABLE Students ( ID int, FirstName VARCHAR(255),LastName VARCHAR(255),Address VARCHAR(500),City VARCHAR(20),State VARCHAR(20),ZipCode VARCHAR(10),Phone VARCHAR(15),PRIMARY KEY(ID));CREATE TABLE GPA (ID int,CurrentGPA decimal(5,2),Class VARCHAR(20),FOREIGN KEY (ID) REFERENCES Stude);CREATE TABLE Scholarships (ID int,MajorCourse VARCHAR(20),AcademicScholarship VARCHAR(3),AthleticsScholarship VARCHAR(3),FOREIGN KEY (ID) REFERENCES Stude);INSERT INTO Students (ID, FirstName, LastName, Address, City, State, ZipCode, Phone) values (1001,'Julia','Green','1827 Morningside Lane','Boston','MA','12345','2548663465');INSERT INTO Students (ID, FirstName, LastName, Address, City, State, ZipCode, Phone) values(1002,'Lacy','White','549 Maltese Road','Dalton','GA','23456','7705945629');INSERT INTO Students (ID, FirstName, LastName, Address, City, State, ZipCode, Phone) values (1003,'John','Brown','18 Red Leaf Street','Seatle','WA','34567','9588256322');INSERT INTO Students (ID, FirstName, LastName, Address, City, State, ZipCode, Phone) values (1004,'Lily','Small','42873 Kitty Circle','Concord','CA','45678','8836547913');INSERT INTO Students (ID, FirstName, LastName, Address, City, State, ZipCode, Phone) values (1005,'Marilyn','Bull','254 Kenton Place','Anderson','SC','56789','1325973399');INSERT INTO Students (ID, FirstName, LastName, Address, City, State, ZipCode, Phone) values (1006,'Kenton','Barkley','56 Awnings Street','Albany','NY','67891','3514816184');INSERT INTO Students (ID, FirstName, LastName, Address, City, State, ZipCode, Phone) values (1007,'Ralph','Wonders','99492 Babblin Brook Road','Davie','FL','78912','3211845862');insert into gpa (ID,CurrentGPA,Class) values (1001,2.25,'Freshman');insert into gpa (ID,CurrentGPA,Class) values (1002,3.96,'Sophomore');insert into gpa (ID,CurrentGPA,Class) values (1003,3.25,'Junior');insert into gpa (ID,CurrentGPA,Class) values (1004,2.96,'Senior');insert into gpa (ID,CurrentGPA,Class) values (1005,3.88,'Graduate Student');insert into gpa (ID,CurrentGPA,Class) values (1006,2.67,'Junior');insert into gpa (ID,CurrentGPA,Class) values (1007,1.94,'Senior');insert into Scholarships (ID, MajorCourse,AcademicScholarship,AthleticsScholarship) values