Reka bentuk ERD

Gambaran keseluruhan

Matlamat

Reka pangkalan data dan lukis ERD untuk senario tertentu

Objektif Pembelajaran

- Understand and be able to identify Entity, attributes and relationship between entities - Be able to use correct notations for each item in ERD - Be able draw an ERD using tools or pen and papers - Be able to draw an full ERD for a proposed system

Konteks

A school wants to keep track of its educational information including: The personal information of their students Courses that one student have learnt and his marks for each course Courses and classes details Student accounts on the school website Business rules: One student belongs to one class and can register for many courses. A class can have one or many student, at least one. A course can associate with many students or no student at all