DATA
MODELLING AND MANAGEMENT
· The exam consists of 4 questions. First question is 20 marks, final
question is 30 marks and other questions are 25 marks. You need to answer all
of them to get full marks. Please write all answers in the answer book
provided.
· This is a closed book exam. No material, notes or documentation are
allowed whatsoever.
Question 1 (Concepts)
a) Explain the entity integrity rule and the referential integrity rule within the relational model. Provide and explain brief example(s)
of your choice that show a violation of both rules.
b) Briefly explain what redundant data means in the context of databases. Explain one problem redundant
data causes (please provide an example). Discuss what we can do erase redundancy
and solve this problem?
Question 2 (ER Model)
Consider the following
simple Exams database:
An exam is identified by an
exam ID and has a date and a unit. An exam uses at least 1 or more exercises.
An exercise is identified by an exercise ID and has a description and a
solution. Each exercise must be used in exactly 1 exam. Lecturers are
identified by a lecturer ID and have a name. They devise at least one or more
exams. An exam in turn is devised by exactly 1 lecturer. A lecturer marks at
least one or more exams. An exam is marked by exactly 1 lecturer. Students are
identified by a student ID and have a name. They take at least 1 or more exams.
An exam is taken by at least 1 or more students.
Draw an Entity
Relationship Diagram that precisely reflects above scenario. Make sure you
cover all attributes you can identify in the scenario and also specify the
cardinalities.
The Complete Question is Below
USA 
India
Question Attachments
3 attachments —