During this stage of the design, we want to look at the tables that were created in the last project and analyze the tables through the data normalization process.

Break your tables down and explain the rationale for doing so

$($

or not doing so

$)$

$.$

Also, based on what reports you listed in the Week

$2$

$$Project$,$ determine what fields would be needed to generate those reports. You can create a table to determine which items will be manually typed

$($

report design

$)$

$$and what fields we want to pull from our tables.

$($

This information will be useful for Unit

$5$

$$as we create SQL queries on these tables

$)$

$.$

Assignment requirement:

The assignment will need to be in an APA format

Assignment length should be

$1$

$-$

$2$

$$pages long, not including the cover and reference page

$($

s

$)$

Assignment should have table designs

$($

new content

$)$

This content should be added to the paper that was created in Weeks

$1$

$,$

$2$

$,$

$$and

$3$

$$as we will continue to create a

$$

running

$$

$$document for the course design document. The picture is my ERD and the all the attributes are included with the relationships. Here is all the information you will need: Entities:

Student: Stores information about students

$($

e

$.$

g

$.$

$,$

$$StudentID$,$ Name, DOB, Major

$)$

$.$

Course: Represents courses offered

$($

e

$.$

g

$.$

$,$

$$CourseID$,$ Title, Credits

$)$

$.$

Department: Contains details about academic departments

$($

e

$.$

g

$.$

$,$

$$DepartmentID$,$ Name, Location, Chair

$)$

$.$

Enrollment: Connects students to courses, indicating their enrollment status and grades

$($

e

$.$

g

$.$

$,$

$$EnrollmentID$,$ StudentID

$($

FK

$)$

$,$

$$CourseID

$($

FK

$)$

$,$

$$Grade$,$ Semester

$)$

$.$

Instructor: Holds information about instructors

$($

e

$.$

g

$.$

$,$

$$InstructorID$,$ Name, DepartmentID

$($

FK

$)$

$)$

$.$

Relationships:

Student

$-$

Enrollment: One

$-$

to

$-$

Many relationship. Each student can be enrolled in multiple courses, but each enrollment is linked to one student.

Course

$-$

Enrollment: One

$-$

to

$-$

Many relationship. Each course can have multiple enrollments, but each enrollment is linked to one course.

Instructor

$-$

Department: Many

$-$

to

$-$

One relationship. Many instructors can belong to one department.

Instructor

$-$

Course: One

$-$

to

$-$

Many relationship. An instructor can teach multiple courses, but each course has one instructor.

Existence Dependence:

In the Student

$-$

Enrollment and Course

$-$

Enrollment relationships, the existence of an enrollment record depends on the existence of both a student and a course.

Examples of Reports:

Student Transcript Report: Displays a student's enrolled courses along with grades.

Course Enrollment Report: Lists all students enrolled in a specific course.