WEEK 3: CONCEPTUAL DATA MODELS: ENTITY-RELATIONSHIP MODELLING
Section outline
-
-
Teaching and Learning Methods to be Employed
i. Illustrated lecture with step-by-step ER diagram construction
ii. Hands-on ER diagram drawing exercise (paper or draw.io)
iii. Case study: Modelling a Nigerian hospital information system
iv. Collection of Assignment 1
Learning Outcomes / Objectives
By the end of this week, students should be able to:
1. Explain the purpose of conceptual data modelling.
2. Define entities, attributes, and relationships in the ER model.
3. Classify attributes by type (simple, composite, multi-valued, derived).
4. Identify and specify cardinality ratios and participation constraints.
5. Draw a complete Entity-Relationship (ER) diagram for a given scenario.
-
Assignment 2Opens: Thursday, 18 June 2026, 12:00 AMDue: Thursday, 2 July 2026, 12:00 AM
-
Due: Thursday, 18 June 2026, 6:52 PM
-