Build a database named dbms course project

Assignment Help Database Management System

Reference no: EM13758004

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

Final Project Part 2

You are required to use OpenOffice software to write and execute queries with tables you created in Project Part 1.

Extract the First and Last Name, Student ID, Course Major and GPA of any students on athletic scholarship. Sort by Student ID.

Produce a report with the data from Step #1 and Use good headings.

Reference no: EM13758004

Questions Cloud

Identify a feature-length film that fits genre : Identify a feature-length film that fits this genre and provide a basic summary of the movie. As you develop this summary, remember the differences between a film's story and a film's plot.

Describe the product or service the company produces : Describe the product or service the company produces or services. Include trademark, color, shape, packaging, labeling, and any characteristics that you deem relevant.

Distinguish local area networks and wide area network : Identify hardware and software needed to secure your choice of networks against all electronic threats. Distinguish between local area networks (LANs), wide area networks (WANs), and wireless technologies.

Do you have a poem where characters develop : Do you have a poem where characters develop? Is the beginning is a feature to notice? Is the poem painting a picture?

Build a database named dbms course project : Build a Database named DBMS Course Project. The database should include following tables.

Write a reference-based implementation of a queue : Write a reference-based implementation of a queue that uses a linear linked list to represent the items in the queue. You will need both a head reference and a tail reference.

Create a view on the student database connecting student : Create a view on the student database connecting student and enrollment with a where statement so no criteria then try to us it to do

Describe the hardware you will purchase : Describe the hardware you will purchase or build (inclusive of computers, memory, storage, video cards, printers, routers and cabling). Justify your hardware selection

Describe your chosen architecture pattern : Describe your chosen architecture pattern. Explain how your chosen pattern could be applied to this case study

User Account

All Pages