Objectives
- 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
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.