Assessment 2NormalisationCSE2DCX Database Fundamentals on the CloudCSE2DCX – Assessment 22Before you begin ObjectivesThis is an individual assignment. Students are not permitted to work in a group when writing thisassignment.Copying and PlagiarismThis is an individual assignment. Students are not permitted to work in a group when writing thisassignment. Plagiarism is the submission of another person’s work in a manner that gives theimpression 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/academicintegrity/explanation/plagiarismSubmission GuidelinesYour 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 daycapped at 5 days. No assignment will be accepted after 5 days. If you have encountered difficultiesthat lead to late submission or no submission, you should apply for special consideration. CSE2DBX – Assessment 22019 Edition 3BackgroundFor this assignment you need to write a short report in Microsoft Word with answers to the followingquestions.QuestionsQuestion 1List three benefits of normalizing a relation.[3 marks]Question 2Define first normal form (1NF), second normal form (2NF), and third normal form (3NF).[6 marks]Scenario for Questions 3-5Consider the relation in answering the questions that follow. The relation is for a library whichmaintains the below relation to store details of books that have been issued to members. Each bookhas a unique ISBN number while the library may have multiple copies of a book with each having aseparate book number (Book_No). The library maintains records of only the current loans. Member_NoNameBook_NoISBN_NoTitleIssued_Date15Silva103111111Database Systems15/08/2009101222222Linux15/06/2010105333333OS15/08/2009106444444Hacking Explained23/12/2009102555555Mac OS X15/08/200918Perera113111111Database Systems12/12/2009118777777Database Systems 210/05/2010114888888Solaris15/06/2010112333333OS20/04/2010119999999Java SE12/12/2009 Question 3What is the current level of normalization in the above relation?[2 marks]CSE2DCX – Assessment 24Question 4Write the functional dependencies for the above table.[3 marks]Question 5Normalize 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]SubmissionWhen you have completed your answers, submit the assessment on the Learning Portal. You shouldsubmit the following:• Submit your answers in a Microsoft Word called xxx_cse2dcx_assessment2.docx (wherexxx is your student number).Assessment Marking Criteria QuestionMarks1326324356Total20 CSE2DBX – Assessment 22019 Edition 5
- Assignment status: Already Solved By Our Experts
- (USA, AUS, UK & CA PhD. Writers)
- CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS, GET A NON PLAGIARIZED PAPER FROM OUR EXPERTS
