ERD design

Tổng quat

Bàn thắng

Design a database and draw an ERD for a certain scenario

Mục tiêu học tập

- 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

Bối cảnh

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