• Keine Ergebnisse gefunden

q Relational Databases 1 Exercise Sheet 2: Data Modelling I (until Thursday, 03.11.2016)

N/A
N/A
Protected

Academic year: 2021

Aktie "q Relational Databases 1 Exercise Sheet 2: Data Modelling I (until Thursday, 03.11.2016)"

Copied!
3
0
0

Wird geladen.... (Jetzt Volltext ansehen)

Volltext

(1)

q Relational Databases 1

Exercise Sheet 2: Data Modelling I (until Thursday, 03.11.2016)

Please note: you need 50% of all exercise points to receive the Studienleistung for this lecture. In order to pass the RDB I Module, you need both the Studienleistung and you need to pass the exam.

Exercises have to be turned in until Thursday before the lecture either in the lecture hall or into our mailbox (Informatikzentrum 2nd floor). Please do not forget your Matrikelnummer and your tutorial group number on your solutions. Your solutions may be in German or English. Unless otherwise specified: Always use your own words!

Exercise 2.1 – Database Design (5 Points)

a) In databases, the data’s specific semantics are very important. Explain, what data specific seman- tics mean and why it is needed. (2 points)

b) Explain the concepts of physical and logical data independence. (2 points) c) Explain the concept of universe of discourse (1 point)

Exercise 2.2 – ER Modelling (10 Points)

a) Explain the differences between an entity and an entity type with an example (2 Points) b) Explain what a derived attribute is and provide an example? (2 Points)

c) How does a derived attribute affect redundancy? (2 Points)

(2)

d) Why do we need key attributes? (1 Point) e) Explain the following: (3 Points)

Relationship type

Relationship set

Relationship

Exercise 2.3 (3 Points)

Draw a Chen ER-Diagram for the following entity type:

Employee = (id, first_name, last_name, (address (street, no, zip, city)), {telephone (handy, home, of- fice)})

Exercise 2.4 (4 Points)

Give an example ER diagram of a weak entity and its corresponding strong entity. The weak entity should have an own key attribute. Also provide a textual representation of all entity types in the ER diagram. Note: the example must be different to the ones presented in the lecture.

Exercise 2.5 (4 Points)

Given the following ER-Diagram:

Is the relationship set r described in the following figure a valid instance of the relationship type R? If not, list all conflicts that violate the constraints described in the ER-Diagram above and provide an adaptation of r that would make r a valid instance of R.

A B

C

R (2,4)

(1,*) (1,1)

(3)

Exercise 2.6 (6 Points)

Create an ER diagram (Chen) for the following scenario:

You are organizing an exhibition. There are a number of halls identified by a unique number. Addition- ally each hall has a name. In each hall there are several stands described by a number which is only unique within the hall. Stands are rent by Companies. Companies are identified by the company's name.

Besides the stands there are special rooms for presentations identified by a number. Companies may register a presentation in a fixed time slot. Time slots do not change during the exhibition and are identified by a start time and an end time.

Referenzen

ÄHNLICHE DOKUMENTE

If you forget to write your Matrike- lnummer and/or your tutorial group number, you get automatically 0 points.. Your solutions may be in German

actor(person → Person, movie → Movie, role) director(person → Person, movie → Movie) reviewer(person → Person, movie → Movie, stars) hasGenre(movie → Movie, genre

Consider the following schema of a network of authors of scientific research papers Author (id, name, numberOfPublications).. Collaborator (id1 → Author, id2 → Author) Cites (id1

If you forget to write your Matrike- lnummer and/or your tutorial group number, you get automatically 0 points.. Your solutions may be in German

Exercises have to be turned in until Thursday before the lecture either in the lecture hall or into our mailbox at the IFIS floor (Mühlenpfordtstraße 23, 2 nd floor)..

If you forget to write your Matrike- lnummer and/or your tutorial group number, you get automatically 0 points!. Your solutions may be in German

(2 Points).. The figure below the ER diagram shows two entity sets contain- ing instances of A and B and a relation set containing instances of R. However, this figure contains

A home might even be an evil lair or a secret base (or both, if a hero and a villain rent an apartment in the same building). An evil lair does always contain a weapon of