Databases

To give you practice using the Entity Relationship model of database and application design

Overview of lab

Congratulations! You and your group have been selected to design and implement a student registration system for the college! Currently, they use a giant spreadsheet that they keep track of everything in. Because your group is a consulting firm you are not given much information and are expected to complete the task in 1 week. The Excel document that the college uses is attached to the lab.

What you need to do

I expect you to design and implement the system into an instance of the database schema based off of the Excel document that has the data in it. The database must be in 3NF. I expect you to design, create, insert data, and run basic reports off of the data in the database. You must also design the interface for the Application.

YOU CANNOT EDIT THE DATA. You may move the data around, but you cannot edit it

You also need to create the following “reports” for the queries

· What is a given student’s schedule for a given semester and a given year?

· This means that you provide the year in the query and the database compiles the report

· What is a given faculty member’s schedule for a given semester and a given year?

· What is a given student’s Grade report in a given semester and a given year?

· One for a given semester and year

· What are all of the student’s grades?

Deliverables

· Documentation of your system (however you want to do this)

· Entity relationship Diagram

· Database Schema

· Application Design

· This can be on paper. What would the application l look like and what would the behavior of the application be when buttons are pressed?

· Tell me which of your group member’s azure instance your database is on and I will look at it

· Your Script in three .txt documents

· Structure.txt

· Should contain the structure. All CREATE Table scripts should be in here

· Data

· Should contain the INSERT INTO statements

· Queries

· Should be the queries for the system

· A document FROM EACH GROUP MEMBER outlining what they did for the project and how the project works