Using Open Office Step 1 : Build a Database named DBMS Course Project. The datab

Question

Using Open Office

Step 1 : Build a Database named DBMS Course Project. The database should include 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

Class:

Freshman

Sophomore

Junior

Senior

Graduate Student

Third Table - Scholarships

ID

Major course of study

Academic Scholarship (Yes or No)

Athletic Scholarship (Yes or No)

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 ecah 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.

Explanation / Answer

SELECT s.[First Name], s.[Last Name], s.Address, s.City, s.State, s.[Zip Code], s.[Phone Number]
FROM Students s INNER JOIN GPA gpa on s.ID = gpa.ID
WHERE gpa.Class = 4
ORDER BY s.[Last Name], s.[First Name]

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.