EMPLOYEE(

SUPERVISOR:

DNR:

DEPARTMENT(

MGNR:

PROJECT(

DNR:

WORKS_ON(

SSN:

PNR:

Which statement is CORRECT? According to the model, an employee can manage multiple departments. correct According to the model, a supervisor cannot supervise more than one employee. incorrect According to the model, an employee should always work on projects assigned to his/her department. incorrect According to the model, an employee can work in multiple departments. incorrect MC Given the following (normalized) relational model (primary keys underlined; foreign keys in italics):

EMPLOYEE(

SUPERVISOR:

DNR:

DEPARTMENT(

MGNR:

PROJECT(

DNR:

WORKS_ON(

SSN:

PNR:

Which statement is NOT CORRECT? A department has always exactly one manager. incorrect Every project is always assigned to exactly one department. incorrect An employee must work in the same department than he/she manages. correct Every employee must be always supervised by exactly one other employee. incorrect MC Consider the following EER model

Which statement is CORRECT? When mapping the EER relationship type INVOLVE between COURSE and ASSIGNMENT to the relational model, a new relation needs to be introduced. The 1..1 cardinalities of this relationship type cannot be enforced in the relational model. incorrect When mapping the EER relationship type IS_ENROLLED between COURSE and STUDENT to the relational model, a new relation needs to be introduced. The relation is identified by GRADE as its primary key. incorrect When mapping the EER relationship type PARTICIPATE between GROUP ASSIGNMENT and STUDENT to the relational model, a new relation needs to be introduced. The 4 cardinalities of this EER relationship type can be perfectly mapped to the relational model. incorrect The partial inheritance relationship between STUDENT and REPRESENTATIVE can be perfectly mapped to the relational model by the following two relations: STUDENT(StudentID, FirstName, LastName) and REPRESENTATIVE (S-StudentID, Email) whereby S-StudentID refers to StudentID in STUDENT. correct MC Which statement is CORRECT? A foreign key can be NULL. correct Every relation must have a foreign key. incorrect A foreign key of a relation A cannot refer to the primary key of the same relation A. incorrect A relation cannot have more than 1 foreign key. incorrect MC Consider the following EER model

Which statement is CORRECT? When mapping the EER relationship type PARTICIPATE between GROUP ASSIGNMENT and STUDENT to the relational model, a new relation needs to be introduced. The 4 cardinalities of this EER relationship type can be perfectly mapped to the relational model. incorrect When mapping the EER relationship type IS_ENROLLED between COURSE and STUDENT to the relational model, a new relation needs to be introduced. The relation is identified by GRADE as its primary key. incorrect The partial inheritance relationship between STUDENT and REPRESENTATIVE can be perfectly mapped to the relational model by the following two relations: STUDENT(StudentID, FirstName, LastName) and REPRESENTATIVE (S-StudentID, Email) whereby S-StudentID refers to StudentID in STUDENT. correct When mapping the EER relationship type INVOLVE between COURSE and ASSIGNMENT to the relational model, a new relation needs to be introduced. The 1..1 cardinalities of this relationship type cannot be enforced in the relational model. incorrect MC Consider following generalization / specialization.

Suppose we represent this generalization / specialization by the following relational model:

Discipline (

Individual sport (

Teamsport (

Consider the following 4 statements:

1) The relational model does not allow to enforce the completeness constraint; the disjointness constraint can be enforced.

2) The relational model does not allow to enforce both the completeness constraint and the disjointness constraint.

3) By dropping the relation 'Discipline' in the relational model, the completeness constraint can be enforced.

4) The relational model allows the specialization to be partial.

Which of the following options is CORRECT? Statement 1 and 2 are both correct. incorrect Only statement 4 is incorrect, the other statements are correct. incorrect Statement 1 and 4 are both incorrect. incorrect Only statement 1 is incorrect, the other statements are correct. correct MC Given the following relational model (primary keys are underlined, foreign keys are in italics)

BOOK(

AUTHOR(

WRITES(

PUBLISHER(

CITY(

The assumptions are:

- Each book has a unique ISBN number
- Each author has a unique name
- Each publisher has a unique name
- A book can have multiple authors
- An auther can write more than one book
- A publisher can publish more than one book
- A book can have multiple publishers
- A publisher has only one address