Step 1Build a Database named DBMS Course Project. The database should include fo

Step 1Build a Database named DBMS Course Project. The database should include following tables.First Table StudentsIDFirst NameLast NameAddressCityStateZip CodePhone Number with area codeSecond Table GPAIDCurrent GPAClassFreshmanSophomoreJuniorSeniorGraduate StudentThird Table ScholarshipsIDMajor course of studyAcademic Scholarship (Yes or No)Athletic Scholarship (Yes or No)Step 2Extract the First and Last Name Address City State Zip Code and Phone Number of each senior on the database. Sort by Last Name then First Name (1 sort).Step 3Extract the First and Last Name and GPA of each student who qualifies for the Deans List. Sort by GPA then Last Name then First Name (1 sort). A GPA of 3.25 is required to make the Deans List.Final Project Part 2You are required to useOpenOfficesoftware to write and execute queries with tables you created in Project Part 1.