Reference no: EM133234667
Build a Database named DBMS Course Project. I am to use Microsoft Access, Open Office, or such to draw the tables. Please provide the drawings for a better understanding of the build. Thank you in advance for your assistance.
The database should include the following tables:
First Table - Students
ID
First Name
Last Name
Address
City
State
Zip Code
Phone Number with area code
Second Table - GPA
ID
Current GPA (two decimal positions)
Class (numeric field, 1 = Freshman, 2 = Sophomore, etc.)
Freshman
Sophomore
Junior
Senior
Graduate Student
Third Table - Scholarships
ID
Major course of study
Academic Scholarship (Use Yes/No data type)
Athletic Scholarship (Use Yes/No data type)
Step 2
Extract 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 3
Extract the First and Last Name, and GPA of each student who qualifies for the Dean's List. Sort by GPA, then Last Name, then First Name (1 sort). A GPA of 3.25 is required to make the Dean's List.