Question

Each semester, each student must be assigned an adviser who counsels students about degree requirements and helps students register for classes. Each student must register for classes with the help of an adviser, but if the student’s assigned adviser is not available, the student may register with any adviser. We must keep track of students, the assigned adviser for each, and the name of the adviser with whom the student registered for the current term.
Q1. Represent this situation of students and advisers with an E-R diagram. Also, draw a data model for this situation using the tool you have been told to use in your course.

Answer 1

Ans: There will be many tables which can be named as:

• Course:

  • Course_id

  • course_title

  • course_duration

• Advisor:

  • adv_fst name

  • adv_lst name

  • adv_dept

• Student:

  • Std_id

  • Std_first name

  • Std_last name

• Registration:

  • reg_sem

  • rg_year

  • reg_type

The ER diagrams for the following data is attached to this answer.