Final Project (Part 1)

Final Project (Part 1)

Use OpenOffice software (or MS Access if you have it) to build tables, as well as write, and execute queries. Submit the database and screenshots of all tables and queries. Be sure the database is unzipped.

Create your own data. Ensure the data will test all criteria and prove all sorts worked as required. Be sure that all tables and queries have descriptive names. Query 1 and Step 1 are examples of poor names.

Step 1

Build a Database named DBMS Course Project. 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 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.