erdplus-diagram-3
picture 1.1

 

In Above are the diagram that we create for the database design and I am responsible on Schedule Database and with this picture I will explain the relation between entity in a schedule :

  • In Student_Schedule the atribute are consist of :
    • Date
    • Day
    • Time
    • Lecture
    • Course
  • In Lecture_Schedule the  atribute  are consist of:
    • Date
    • Day
    • Time
    • Location
    • Course
  • In Courses Entity the atribute  are consist of:
    • Id-Course (primary Key)
    • Course_Name

Note:

  • for the primary key the entity are not owned it by each entity but we can access from the foreign key in Course entity.
  • And relation between the entity are showed in the picture above.
Advertisements