$21$; $22$; $232022$

$$ The Independent Institute of Education $($Pty$)$ Ltd $2022$

Page $1$ of $7$

MODULE NAME: MODULE CODE:

DATABASES DBAS$6211$

DATABASES DBAS$6211$d

ASSESSMENT TYPE: EXAMINATION $($PAPER ONLY$)$

TOTAL MARK ALLOCATION: $120$ MARKS

TOTAL HOURS: $2$ HOURS $(+10$ minutes reading time$)$

INSTRUCTIONS:

$1.$ Please adhere to all instructions in the assessment booklet.

$2.$ Independent work is required.

$3.$ Five minutes per hour of the assessment to a maximum of $15$ minutes is dedicated to

reading time before the start of the assessment. You may make notes on your question

paper, but not in your answer sheet. Calculators may not be used during reading time.

$4.$ You may not leave the assessment venue during reading time, or during the first hour or

during the last $15$ minutes of the assessment.

$5.$ Ensure that your name is on all pieces of paper or books that you will be submitting. Submit

all the pages of this assessment$$s question paper as well as your answer script.

$6.$ Answer all the questions on the answer sheets or in answer booklets provided. The phrase

$$END OF PAPER$$ will appear after the final set question of this assessment.

$7.$ Remember to work at a steady pace so that you are able to complete the assessment within

the allocated time. Use the mark allocation as a guideline as to how much time to spend on

each section.

Additional instructions:

$1.$ This is an OPEN BOOK assessment.

$2.$ For open book assessments the students may have open access to all resources inclusive of

notes, books $($hardcopy and e$-$books$)$ and the internet. These resources may be accessed as

hard copies or as electronic files on electronic devices. All electronic devices batteries must

be fully charged before the assessment as no charging of devices will be permitted during

the sitting of the assessment. The IIE and associated brands accept no liability for the loss or

damage incurred to electronic devices used during open book assessments.

$3.$ Answer All Questions.

$4.$ Instructions for assessments including practical computer work:

$$ Use of good programming practice and comments in code is compulsory.

$$ Save your application in the location indicated by the administrator $($e$.$g$.,$ the Z:$\backslash$ drive

or your local drive$).$

$$ Create a folder as follows: use the module code and your own student number and

create a folder with a folder name as per the format shown here:

$$ StudentNumber$\_$ModuleCode$\_$Exam. Save all files $($including any source code files,

template files, design files, image files, text files, database files, etc.$)$ within this

folder.

$21$; $22$; $232022$

$$ The Independent Institute of Education $($Pty$)$ Ltd $2022$

Page $2$ of $7$

$$ E$.$g$.,$ if your student number is $12345,$ and you are writing an examination for the

module PROG$121,$ create a folder named $12345\_$Prog$121\_$Exam and use this

throughout the session to save all of your files.

$$ Important: Upon completion of your assessment, you must save and close all your

open files and double click the ExamLog application on your desktop. You must follow

the instructions carefully to ensure that the information about the files that you have

submitted for this assessment has been logged on the network. Specify the location of

your source code on your question paper.

$21$; $22$; $232022$

$$ The Independent Institute of Education $($Pty$)$ Ltd $2022$

Page $3$ of $7$

Question $1$ Entity Relationship Diagram $($Marks: $20)$

Answer this question in your answer booklet.

Draw an Entity Relationship Diagram $($ERD$)$ using Unified Modelling Language $($UML$)$ notation

according to the below business rules. Your design should be at the logical level $$ include primary

and foreign key fields and remember to remove any many$-$to$-$many relationships.

Tip: Pay attention to the mark allocation shown below.

Business rules for a restaurant chain with several restaurants around the country:

$1.$ All entities should have surrogate primary keys.

$2.$ Each dish has a dish type, and there can be lots of dishes with the same dish type.

$3.$ The description for each dish type must be stored in the database.

$4.$ The name and description for each dish must be stored in the database.

$5.$ Each restaurant has exactly one owner, but an owner may own multiple restaurants in the

chain.

$6.$ The name and surname of each owner must be stored in the database.

$7.$ The name of each restaurant must be stored in the database.

$8.$ Each restaurant may select several dishes to put on their menu, and a dish can be served at

many different restaurants.

$9.$ Since dish selections can change over time, the start date and end date of each dish

selection must also be stored in the database.

Marks will be awarded as follows:

Entities $5$ marks

Relationships $4$ marks

Multiplicities $4$ marks

Primary keys $2$ marks

Foreign keys $2$ marks

Other attributes $2$ marks

Correct UML Notation $1$ mark

Total $20$ marks

$21$; $22$; $232022$

$$ The Independent Institute of Education $($Pty$)$ Ltd $2022$

Page $4$ of $7$

Question $2$ Normalisation $($Mark