Database

ERD Deliverables 1) ERD (with key attributes) Below are format examples.

OR Student (StudentID, StudentLastName, AdvisorID) Advisor (AdvisorID, AdvisorLastName)

OR

Student

PK StudentID

StudentLastName FK1 AdvisorID

Advisor

PK AdvisorID

AdvisorLastName

Student Advisor

Student Advisor M 1

M

StudentID

StudentLastName AdvisorLastName

1

AdvisorID

2) Table Relation A screenshot of SQL Server database diagram, something like below:

3) Table Designs Screenshots of SQL Server Table designs, something like below:

If you have 3 tables, make 3 screenshots that show each table design.