Assignment 2 INFORMATION SHEET
School: IT and Business
Name of Unit:
ICT105 Data Modelling and Database Systems
Unit Code:
ICT105
Assessment Type
Assignment 2
Due Date
(Including Time):
2 December 2020
23:59hrs
No. of Pages in Exam:
(including cover page)
2
NOT INCLUDING INFORMATION
SHEET
Name of Academic: Yancong (Ray) XIE (RX)
Assessor: Dr Aaron Bere Moderator: Yancong (Ray) XIE (RX)
STATIONERY and AIDS
Number of answer
ooks per student:
Textbooks and notes:
(please mark x)
Yes x No
Textbooks only:
(please mark x)
Yes No
Materials allowed:
(graph paper, mathematical and
statistical tables, graphics
calculator)
None
Special requirements:
(special instructions, list of
formulae, show video, listen to
audio tapes, printer required,
access to particular software,
access to other IT requirements
etc.)
This is an open book assignment. Students may refer to their textbooks.
Other:
None
1
Assignment 2
UNIT CODE: ICT105
UNIT NAME: Data Modelling & Database Systems
UNIT LECTURER’S NAME: Yancong (Ray) XIE (RX)
UNIT COORDINATOR’S NAME: Dr Aaron Bere
Due Date: XXXXXXXXXXDecember 2020 at 23:59hrs
MARKS ALLOCATION: XXXXXXXXXXMarks
RESOURCES: None
INSTRUCTIONS:
1. Each question must be clearly labelled
2. Due Date and time : 2 December 2020 at 23:59hrs
3. The assessment must be typed Arial 12 font, 1.5 spaced
4. Marks will be deducted for late submission; 10% of the total marks will be deducted for
each day after due date
5. Use this Turnitin link to submit “ Assignment 2- ICT 105 Submission Link” by the due
date
6. All assignment submissions must be accompanied by a completed SISTC student
assignment Cover Page
7. You can resubmit your assignment several time to check your plagiarism percentage
8. It is recommended to plan time appropriately and start the assessment early; this will give
you time to research and do well
SUBMISSION DETAILS:
1. Please name your file as follows: studentIDFirstnameLastname before uploading it into
Turnitin (e.g. 2222222SandeepSandoo)
2
Question XXXXXXXXXXMarks)
The EmpProjData table below is in first normal form. Study the table and answer the following questions.
Table: EmpProjData
Apply the principles of normalization and convert the EmpProjData to third normal form. Your tables in
third normal form should include all the appropriate data from the EmpProjData.
Question XXXXXXXXXXMarks)
(i) Identify and explain three major types of database concu
ency problems that may affect the
consistency of an enterprise database management systems XXXXXXXXXX)
(ii) Paul is a database administrator for Topics. Topics is a modern clothing online store. Paul is
esponsible for maintaining data concu
ency for Topics database. Explain to sales staff using non-
jargon terminology how Topics shopping carts support data concu
ency and consistency.
(4)
[End of Paper]