Question: 1. Create a database for a school registration system. The registration system should be able to hold information for the following entities: a. Students b.

1. Create a database for a school registration system. The registration system should be able to hold information for the following entities:

a. Students

b. Courses

c. Teachers

d. Grades

At the minimum, the following queries should be answered: - how many students are enrolled in a class?

- How many courses are available on a Wednesday (or any given day)?

- Who are the teachers teaching a particular course?

- What is the average GPA for a course this semester?

2. Create an ERD (entity-relationship diagram) that shows the relationships of all your tables.

3. Normalize your tables.

4. Create a one-page summary/documentation on how you were able to construct your database. What are the (possible) pain points that still exist and how do you plan to address them in the future?

5. Submit your queries, database definitions, and diagram in either a Word file or (for the queries and results) a screenshot of your SQL developer commands and results. Zip them all up into one zip file and upload to Blackboard.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

The Course Registration System The Problem Statement As the head of information systems for Wylie College you are tasked with developing a new student registration system. The college would like a...

Solve this problem below The problem 2 : Learning Management System An LMS is a software application that facilitates the management, delivery, and tracking of educational content and resources. Here...

Dominiques Driving School is a small local company that offers car, pickup truck and motorcycle driving classes to students. The company plans to expand and offer classes for large trucks next year....

A course registration system is a computer system used by the university's administration to plan courses, for students to register for courses, and for faculty to grade them. Students and faculty...

Question 1. Consider an ER diagram given below for Bank database. Which is the correct statement regarding the above diagram (a) Bank-Branch is the weak entity (b) Branch No of the Bank-Branch entity...

You've been hired by Stevens Institute of Technology to create a data repository of courses, students, and instructors. The system will be used to help students track their required courses, the...

Problem: You have been tasked with designing a database for a university registration system. The system allows students to enroll in courses offered by the university. Each course consists of...

Write the code for this program: It s registration time at UCR for Summer classes. Students want to register for two of the best courses available, BUS 1 7 4 and BUS 1 7 5 . Both of these courses...

Assignment Requirements 1) Create a Context DFD illustrating the overall system, its external entities, and major data flows. 2) Create a level O DFD illustrating the major processes of the system,...

In diagram A a loop of wire in the shape of a triangle equilateral is just entering, at time tA = 0, into a region of a uniform and constant magnetic field in the weather. In diagrams B, C, and D, at...

Financial analysts forecast Best Buy Company (BBY) growth for the future to be 17.00 percent. Their recent dividend was $2.29. What is the value of their stock when the required rate of return is...

Sudden unexplained onset of bilateral weakness or numbness in the lower eatremities might suggest and warrant immediate referral to a physician and be diagnosed as Guilain - Bare myasthenla gravis...

Heat transfer rate per unit area is called Thermal conductivity Heat flux Heat transfer co - efficient Thermal diffusivity

What would be the shared Data Elements between Position Control and Salary Grade Tables in providing cost input to Budgets for vacant positions?

What is the purpose of the Salary Structure Table?

What is the scope and use of a Job Family Table?