Title: Week 4
Course: Introduction to Database Management Systems

Entity-Relationship Modelling

The topic will expose you to Entity-Relational Modelling. You will get exposed to the techniques for determining entities, their attributes, and relationships. Afterwards, they will be able to build Entity Relationship Diagrams in real world case scenarios.

Learning Outcomes

At the end of the week, you will be able to:
1. Identify entities, their attributes and relationships from the case study.
2. Build an Entity Relationship Diagram by combining all the entities and the relationships

Over to you
Week 4 focused on a mini case and a running case was also introduced. Guess What!! You got it. This week uses the same mini and running case that was introduced. We build on the cases to ensure that you understand this week's topic.

Pre-Topic
A review of the database development process was done during the previous week. Based on the readings from week 3, attempt the exercises after chapter 13. The review of the questions will be done during face-to-face activity.

Due date Tuesday 23:59
Estimated study time: 1 hour

FACE-TO-FACE

- Review of the pre-topic activity
- A review of the recorded presentations from e-tivity 3.2 (if any)
- A highlight of new concepts related to Entity-Relationship Modelling will be reviewed.
- Finally, a group discussion on a Mini Case study with a focus on Entity-Relationship Modelling will be performed in groups.
Task
Identify the entities, their attributes, and relationships. Further, build an ERD for the case.
E-TIVITIES

E-tivity 4.1 (Mandatory)
During this week we have done a review of Entity-Relational Modelling. To further understand the weeks’ topic, we will perform the tasks listed. Ensure to do a review of the tasks from e-tivity 3.3 as it builds up to this week. You will be required to come up with the following:

Tasks
  1. Read chapter 8 of the Database Design core textbook covering the entity-relationship data model. While reading, capture short notes while updating the concepts you picked from the face-to-face session.
  2. Watch the video on entity-relationship diagrams and update on the concepts you picked from the previous task.
  3. After a thorough review of the readings and the video perform the following tasks based on the Running Case:
      - Identify the entities, attributes, and relationships of the database.
      - Come up (Draw) with an entity-relationship diagram (ERD) for Tender stores

You will work individually for this e-tivity and will submit your model for evaluation as an assignment.
Due date Sunday 23:59
Estimated study time: 4 hours

Keep a copy of your work in your e-portfolio folder.
ASSESSMENT