Modeling a domain using an entity-relational diagram

Objectives

  1. Learn to use the entity-relational model for modeling the domain.

Motivation

This exercise will practice domain modeling using the entity-relational model.

Instructions

Step 1

As a main part of this exercise, create a model of your assignment's domain using the entity-relational diagram.

Task 1.1

By using the tool recommended by instructor to design entity-relational model, create a domain model of your assignment. Keep in mind the conditions from about this subject page.

Comment

These conditions determine "minimum" requirements. I recommend trying to do rather more than less (or minimum). You can add more entities, relationships, define more attributes and so on. Thanks to more advanced model it will be much easier for you later to create more and meaningful queries.

Comment

In a classical way, the analysis is done with a customer who defines what he needs. In this approach the right model of domain is what the customer needs and want. Your approach will be a little bit different as you don't have a customer, therefore you can be your own customer or you can ask your instructor for help defining model. This means that you must specify what you want to store in the specified domain - for example if you have domain for managing student assignments, you need to think if it is required for you to store students entities in database or not. Will you create student entity, will you create assignment entity?

Resources

  1. https://www.draw.io/
  2. https://erdplus.com/#/
  3. Lecture 03: Relational model
  4. Lecture 04: SQL DDL
  5. MiniFB relational model
  6. MiniFB SQL create database script
  7. Excel database showing example data (+ NF violation examples)
  8. Mária Bieliková: Modelovanie údajov, FIIT STUBA

Additional Tasks

Task A.1

During exercise you should try to model the domain of the school dining system where teachers and students can sign in for lunch/breakfast/dinner.