ERD design

Overview

Goals

Design a database and draw an ERD for a certain scenario

Learning Objectives

- 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

Context

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