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
2020 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]
Question 2
Define first normal form (1NF), second normal form (2NF), and third normal form (3NF).
[6 marks]
Scenario for Questions 3-5
Consider the relation in answering the questions that follow. The relation is for a library 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 library may have multiple copies of a book with each having a
separate book number (Book_No). The library maintains records of only the current loans.
| Member_No | Name | Book_No | ISBN_No | Title | Issued_Date |
| 15 | Silva | 103 | 111111 | Database Systems | 15/08/2009 |
| 101 | 222222 | Linux | 15/06/2010 | ||
| 105 | 333333 | OS | 15/08/2009 | ||
| 106 | 444444 | Hacking Explained | 23/12/2009 | ||
| 102 | 555555 | Mac OS X | 15/08/2009 | ||
| 18 | Perera | 113 | 111111 | Database Systems | 12/12/2009 |
| 118 | 777777 | Database Systems 2 | 10/05/2010 | ||
| 114 | 888888 | Solaris | 15/06/2010 | ||
| 112 | 333333 | OS | 20/04/2010 | ||
| 119 | 999999 | Java SE | 12/12/2009 |
Question 3
What is the current level of normalization in the above relation?
[2 marks]
CSE2DCX – Assessment 2
4
Question 4
Write the functional dependencies for the above table.
[3 marks]
Question 5
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.
[6 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 | 6 |
| 3 | 2 |
| 4 | 3 |
| 5 | 6 |
| Total | 20 |
CSE2DBX – Assessment 2
2020 Edition 5
The post CSE2DCX Database Fundamentals on the Cloud appeared first on My Assignment Online.