Assessment | Database Modelling (KC7013)

Assessment # 1 Submission Template
Database Modelling (KC7013)
Programmes: MSc Computer Science / MSc Information Science (Data Analytics)
Module Code: KC7013
Module Title: Database Modelling
Distributed on: Friday 14th February 2020
Submission
Time and Date: Wednesday 18th March 2020 by 23.59 GMT
Weighting This coursework accounts for 50% of the total marks for this module
Student ID/
Username
W19026287
Student Name Sharissa Lightbourne
ASSIGNMENT #1
Page 1 of 18

Assessment # 1 Submission Template
Database Modelling (KC7013)
Assignment Questions
Part 1 (50 marks)
This part is based on the ‘AiS’ scenario as described in the Appendix.
(A) Using a database design approach of your choice, produce a logical design for
the database to support the information system, which is needed at the
University of Gharnata.
(30 marks)
Your answer must consist of ONE of the following: An entity-relationship (ER) diagram (20 marks) and its mapping into a set of
relations (10 marks). The ER diagram should show all relevant entity types,
relationship types, attributes, primary keys, and structural constraints. Note
that not all keys are identified/mentioned in the scenario, so you are required
to identify/devise appropriate primary keys for all the entity types. Your ER
diagram must not show/include any foreign keys or any such attributes that
represent foreign keys as these are logical and not conceptual concepts. As
part of the mapping process, for each relation, you should identify appropriate
primary keys as well as foreign keys (if applicable). Furthermore, you need to
make sure your relations obtained from mapping your ER diagram are in the
3rd normal form.
 A set of normalised relations (10 marks) obtained through normalisation
process (20 marks) instead of ER modelling. You should make clear how the
normalisation process has been carried out, and the reasoning employed, in
particular quoting/providing evidence (series of steps) to support the decisions
made and how your relations have been derived. Each relation in your answer
should be in the 3rd normal form.
Page 2 of 18

Assessment # 1 Submission Template
Database Modelling (KC7013)
Answer Part 1 A:
ER Diagram (20 marks) and ER Diagram to Relations Mapping to
obtained normalised relations (10 marks)
OR
Steps of your Normalisation process (20 marks) and set of Normalised
Relations (10 marks)
Page 3 of 18

Assessment # 1 Submission Template
Database Modelling (KC7013)
Page 4 of 18