Murdoch University

ICT 581

Contents Executive Summary...............................................................................................................................3 Question 1:............................................................................................................................................3 Normalisation........................................................................................................................................3 Question 1 a).....................................................................................................................................4 Question 1 b).....................................................................................................................................4 Question 1 c)......................................................................................................................................4 Question 1 d).....................................................................................................................................6 Question 2.............................................................................................................................................7 Conceptual Design.................................................................................................................................7 ER diagram for Western Highlands Zoo Database..............................................................................7 Assumptions made in the creation of the data model.......................................................................8 References.............................................................................................................................................8 2 This study source was downloaded by 100000885082914 from CourseHero.com on 05-25-2024 15:24:11 GMT -05:00 https://www.coursehero.com/file/91822117/ict581-solutiondoc/ Executive Summary This assignment focuses on the questions related to relational database designing principles to model a database for the given case study. This assignment offers an insight towards the implementation of normalisation concept till 3NF for the given GRAND SLAM relation and the report also explores on the conceptual design to model an entity relationship diagram for the western highlands Zoo database. Question 1: Normalisation The list of information related to Grand Slam tennis tournaments and the winners for the last few years is represented in the underling Grand Slam relation. When the relation is considered, there are issues with the present design of the database; hence it is required to modify the design of the database in or