Lab 3
- Computer Science Department
 Objective
Given the following business rules, create an ERD to express the following scenario.
A Student can have only one Advisor.
An Advisor can advise multiple Students.
A Student can take multiple Courses.
A Course can have multiple Students.
For this lab, you will need to create an ERD diagram with some attributes appropriate for each table/entity. Just to let you know, you will need to create additional tables to resolve the relationships.
Use Lucid Charts (or Miro, Visio) to complete your ERD and upload a screenshot of your resulting diagram.
It is your choice to determine some attributes that would likely be found in the tables. Be sure to use good naming conventions on your tables and attributes.
Â
 Requirements
Requirement | Notes |
|---|---|
Entities/attributes defined. | Consider using a good naming convention. |
Relationships are defined and resolved. | Diagram indicates primary and foreign keys appropriately |
Design | The diagram is well-designed and understandable |
Â
Â