Please help!

Please help!


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 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 2 What is the current 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 briefly 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