Table name: STUDENT

$($first four fields$)$

Table name: ENROLL

Table name: CLASS

$($first three fields$)$

Based upon the design criteria from the first two sections, and supporting diagrams, begin to layout the design of the tables of your database. In each table, determine the field names, field types, character length of each field and establish the primary key for each table. Once the tables are created, create a relationship diagram $($as shown$)$ to show how the table$($s$)$ primary key will be used to link the tables. See example.

Make sure to provide written explanations$/$justifications for your design and selection of the primary key for each table. 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 Week $1$ and $2$ as we will continue to create a $$running$$ document for the course design document. Here is my design: $+-------------------++------------------++------------------+$

$|$ Student $||$ Course $||$ Department $|$

$+-------------------++------------------++------------------+$

$|$ StudentID $($PK$)||$ CourseID $($PK$)||$ DepartmentID $($PK$)|$

$|$ Name $||$ Title $||$ Name $|$

$|$ DOB $||$ Credits $||$ Location $|$

$|$ Major $|+------------------+|$ Chair $|$

$+-------------------+|+------------------+$

$||$

$||$

$||$

$+-------------------++------------------+$

$|$ Enrollment $||$ Instructor $|$

$+-------------------++------------------+$

$|$ EnrollmentID $($PK$)||$ InstructorID $($PK$)|$

$|$ StudentID $($FK$)|--------|$ Name $|$

$|$ CourseID $($FK$)||$ DepartmentID $($FK$)|$

$|$ Grade $|+------------------+$

$|$ Semester $|$

$+-------------------+$

If you could please help me with my tables and design and what I need to do for this dassignment