Based on your responses to Assessment 1 – Written assessment, perform process and data modellingand develop and document a number of design diagrams using UML (including Context Diagram, Level0 and...

Based on your responses to Assessment 1 – Written assessment, perform process and data modellingand develop and document a number of design diagrams using UML (including Context Diagram, Level0 and Level 1 Data Flow Diagram, Entity Relationship Diagram).ContextIn Assessment 1, you performed a comprehensive requirement analysis for the online studentenrolment system at the ABC University. With an in-depth understanding of the functionalrequirements of the System, you are now required to perform further analysis through process anddata modelling. In doing so, you also need to provide a preliminary data storage design for the System.Both process modelling and data modelling can be used to provide deeper understanding of a newSystem. Thus, they are an integral part of System Analysis. Process modelling describe businessprocesses – i.e. the sequence of activities that people do; while data modelling seeks to describe theASSESSMENT 2 BRIEFSubject Code and Title MIS605 Systems Analysis and DesignAssessment Design specificationIndividual/Group IndividualLength 2500 wordsLearning Outcomes The Subject Learning Outcomes demonstrated by successfulcompletion of the task below include:a) Identify, critically evaluate and recommend informationsystems solutions for inefficiencies in business processes,procedures and work practices using data and processmodelling techniques.b) Formulate, validate and document business requirementsfor a medium-scale information system developmentproject and effectively communicate these requirements tothe stakeholders.c) Demonstrate the ability to effectively analyse, design anddevelop information systems using Unified ModellingLanguage (UML) models.Submission Due by 11:55pm AEST Sunday end of Module 4.2.Weighting 40%Total Marks 100 marksMIS605_Assessment_2_Brief_Design Specification Page 2 of 8data flows through those processes. Data flow diagrams (including context diagrams) and entityrelationship diagrams are the most common process and data modelling techniques used inindustry.Instructions1. Please read MIS605_Assessment 1_Case Study. Please note that every piece of informationprovided in this case study serves a purpose.2. Once you have completed reading the case study, please read the attachedMIS605_Assessment 2_Additional case information document.3. Please complete the following tasks:Task 1.Create and document a Context Diagram for the System.(15 marks)Task 2.Create and document a Level 0 Data Flow Diagram (DFD). The Level 0 DFD should contain allthe major high-level processes of the System and how these processes are interrelated.(20 marks)Task 3.Select three major and non-trivial processes from Level 0 DFD, decompose each of theprocesses into a more explicit Level 1 DFD.(24 marks)Task 4.Using your own experience with similar online student enrolment systems and theinformation provided in the case study:(i) Identify all the entities and their relationships in the System(ii) Create and document an Entity Relationship Diagram (ERD) for the System.Note: the case study has not and does not intend to provide a comprehensive description ofentities in the System. You are expected to use your own experience with information systemsin general and online student enrolment systems in particular to develop this ERD. ForMIS605_Assessment_2_Brief_Design Specification Page 3 of 8example, would Subject Name be an attribute for a Subject? Would Date of Birth be anattribute for Students?(20 marks)Task 5.Should data be stored in files in a file system or in a database for the System? Justify youranswer.(5 marks)Task 6.Translate the ERD you developed in Task 4 into a physical relational database design.Document database tables and their relationship in MSWord file. Normalise your databasedesign to the Third Normal Form (3NF).(16 marks)Please note that your responses to the tasks above must relate to the case study provided.