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 $13$ 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

$)$

$|$