Assessment 2
Normalisation
CSE2DCX Database Fundamentals on the Cloud
CSE2DCX – Assessment 2
2
Before you begin
Objectives
This is an individual assignment. Students are not permitted to work in a group when writing this
assignment.
Copying and Plagiarism
This is an individual assignment. Students are not permitted to work in a group when writing this
assignment. Plagiarism is the submission of another person’s work in a manner that gives the
impression that the work is their own. La Trobe University treats plagiarism seriously. When detected,
penalties are strictly imposed.
Further information can be found on http:
www.latrobe.edu.au/students/academic-
integrity/explanation/plagiarism
Submission Guidelines
Your assignment submission should be typed, not written/drawn by hand.
Submit the electronic copy of your assignment through the subject LMS.
Submission after the deadline will incur a penalty of 5% of the available assignment mark per day
capped at 5 days. No assignment will be accepted after 5 days. If you have encountered difficulties
that lead to late submission or no submission, you should apply for special consideration.
CSE2DBX – Assessment 2
2022 Edition 3
Background
For this assignment you need to write a short report in Microsoft Word with answers to the following
questions.
Questions
Question 1
List three benefits of normalizing a relation.
[3 marks]
Scenario for Questions 2-4
Consider the relation in answering the questions that follow. The relation is for a li
ary which
maintains the below relation to store details of books that have been issued to members. Each book
has a unique ISBN number while the li
ary may have multiple copies of a book with each having a
separate book number (Book_No). The li
ary maintains records of only the cu
ent loans.
Member_No Name Book_No ISBN_No Title Issued_Date
15 Silva XXXXXXXXXXDatabase Systems 15/08/2009
XXXXXXXXXXLinux 15/06/2010
XXXXXXXXXXOS 15/08/2009
XXXXXXXXXXHacking Explained 23/12/2009
XXXXXXXXXXMac OS X 15/08/2009
18 Perera XXXXXXXXXXDatabase Systems 12/12/2009
XXXXXXXXXXDatabase Systems 2 10/05/2010
XXXXXXXXXXSolaris 15/06/2010
XXXXXXXXXXOS 20/04/2010
XXXXXXXXXXJava SE 12/12/2009
Question 2
What is the cu
ent level of normalization in the above relation? Why?
[2 marks]
Question 3
Write the functional dependencies for the above table.
[3 marks]
CSE2DCX – Assessment 2
4
Question 4
Normalize the above database table up to third normal form (3NF) and show the relations.
Intermediate steps are required for 1NF and 2NF. Use underline for primary key attributes. At each
step define the normal form and
iefly state what is to be done to achieve that normal form.
[7 marks]
Submission
When you have completed your answers, submit the assessment on the Learning Portal. You should
submit the following:
• Submit your answers in a Microsoft Word called xxx_cse2dcx_assessment2.docx (where
xxx is your student number).
Assessment Marking Criteria
Question Marks
1 3
2 2
3 3
4 7
Total 15
CSE2DBX – Assessment 2
2022 Edition 5