11.6. Assignments DB.1
Prev Chapter 11. Semantic Data Modelling, The Entity Relationship Model Next

11.6. Assignments DB.1

Submission
You must submit assignments using git
Create Repo
  • Create an empty repo on bitbucket.org, gitlab.com, or github.com,
  • git push your local repo to the above remote repo.
  • For node assignments the line node_modules/must be in your .gitignore file.
Submit
By email to with:
  • The word 'submission <subjectname>' in the subject line
  • The url(s) of your repo(s) in the body

11.6.1. Assignment B.0

A college requests an it system to facilitate handling classes of students. One thing they need is class lists showing names, addresses, email-addresses, etc. The admin office and the students are also keen on knowing what teacher teaches which subject in a class.

Design an ER model that contains the data necessary to do just that. Discuss briefly your deliberations. Hand in a text document with an ER diagram.

11.6.2. Assignment B.1

A company has departments, employees, and sites. An employee works at a single site for a department. A department is at a single site. A site has, possibly, several departments. Create a few illustrative attributes for the entities. The model must reflect who works at what department.

Design an ER model that contains the data necessary to do just that. Discuss briefly your deliberations. Hand in a text document with an ER diagram.

11.6.3. Assignment B.2

Consider a case, where a branch of a company has several cars, but a car is associated with a single branch only. The car is used by a single employee and an employee can use only a single car. Some employees are not issued a car. The model must reflect who works at what branch.

Design an ER model that contains the data necessary to do just that. Discuss briefly your deliberations. Hand in a text document with an ER diagram.

11.6.4. Assignment B.3

The local office of the bureau of the census, in Danish: folkeregister, has a database holding all inhabitants. It wants to know who married whom in a given year. The display must contain the names of the newlyweds, their cpr-numbers, and the wedding date.

Design an ER model that contains the data necessary to do just that. Discuss briefly your deliberations. Hand in a text document with an ER diagram.

11.6.5. Assignment B.4

Having solved the previous assignment you must extend the model so that

  1. the poor people who were incompatible may divorce. We need to know when the divorce is effective.
  2. the lucky people who have children may have their parenthood reflected in the database.
  3. people may die, and have the date of their death recorded in the database preferably in such a way that the design principle of no nulls is maintained.

Design an ER model that contains the data necessary to do just that. Discuss briefly your deliberations. Hand in a text document with an ER diagram.

Prev Up Next
11.5. Demo of Dia Home Chapter 12. Relational Model, SQL Schema