SOLUTION: MIS605 Systems Analysis and Design | My Assignment Tutor

MIS605_Assessment_2_Brief_Design Specification Page 1 of 5Task SummaryBased 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 given case study. Withan in-depth understanding of the functional requirements of the System, you are now required toperform further analysis through process and data modelling. In doing so, you also need to provide apreliminary 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 processes –i.e. the sequence of activities that people do; while data modelling seeks to describe the data flows ASSESSMENT 2 BRIEFSubject Code and TitleMIS605 Systems Analysis and DesignAssessmentDesign specificationIndividual/GroupIndividualLength2000 words +/ 10%Learning OutcomesThe 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.SubmissionDue by 11:55pm AEST Sunday end of Module 4.2.Weighting40%Total Marks100 marks MIS605_Assessment_2_Brief_Design Specification Page 2 of 5through those processes. Data flow diagrams (including context diagrams) and entity relationshipdiagrams are the most common process and data modelling techniques used in industry.Instructions1. Please read case study provided with assessment 1. Please note that every piece ofinformation provided in this case study serves a purpose.2. Please complete the following tasks:Task 1.Create a Context Diagram for the given case study.(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 important processes from Level 0 DFD, decompose each of the processes into amore explicit Level 1 DFD.(24 marks)Task 4.For the given case study, provide an Entity Relationship Diagram (ERD).(20 marks)MIS605_Assessment_2_Brief_Design Specification Page 3 of 5Task 5.For the given case study, identify the data stores including the files that are not part of ERD.(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.Word Count and Layout The total word count for the written assessment should be no more than 2500 words. Please provide all your answers in a MS word document. All diagrams must be drawn using any diagramming tool but the same should be copied toMS Word document. Please note that you are NOT required to copy the task description over to the MS Worddocument. Use the task number to indicate which task your response relates to. The recommended font size is 12 with 1.5 spacing.ReferencingIt is essential that you use appropriate APA style for citing and referencing if needed. Please seemore information on referencing here http://library.laureate.net.au/research_skills/referencingSubmission Instructions Please submit the written assessment via the Assessment link within Assessment 2. TheLearning Facilitator will provide feedback via the Grade Centre in the LMS portal. Feedbackcan be viewed in My Grades.MIS605_Assessment_2_Brief_DesignSpecification Page 4 of 5 Marking CriteriaFPCDHDTask 1: Create a Context Diagram for the givencase study.15%The student has nounderstanding ofwhat a contextdiagram is.The student hasvery limitedunderstanding ofwhat a contextdiagram is.The student hasclear understandingof what a contextdiagram is but therepresentation ismostly incorrectand the solution isnot in sync with thegiven case study.The student hasclear understandingof what a contextdiagram is but therepresentation ismostly incorrect.The solution,however, is in syncwith the given casestudy.The student hasclear understandingof what a contextdiagram is.Representation ismostly correct andthe solution is insync with the givencase study.Task 2: Create and document a Level 0 Data FlowDiagram (DFD). The Level 0 DFD should containall the major high-level processes of the Systemand how these processes are interrelated.20%The student has nounderstanding ofwhat a Level 0 DFDdiagramming is.The student hasvery limitedunderstanding ofwhat a Level 0 DFDis.The student hasclear understandingof what a Level 0DFD is but therepresentation ismostly incorrectand the solution isnot in sync with thegiven case study.The student hasclear understandingof what a Level 0DFD is but therepresentation ismostly incorrect.The solution,however, is in syncwith the given casestudy.The student hasclear understandingof what a Level 0DFD is.Representation ismostly correct andthe solution is insync with the givencase study.Task 3: Select three important processes fromLevel 0 DFD, decompose each of the processesinto a more explicit Level 1 DFD.24%The student has nounderstanding ofhow DFDdecomposition isdone.The student hasvery limitedunderstanding ofhow DFDdecomposition isdone.The student hasclear understandingof how DFDdecomposition isdone. The solution,however, is notfully, in sync, withthe given casestudy and the DFDsare not balanced.The student hasclear understandingof how DFDdecomposition isdone. The solutionis in sync with thegiven case studybut the DFDs arenot balanced.The student hasclear understandingof how DFDdecomposition isdone. The solutionis in sync with thegiven case studyand the DFDs arebalanced. MIS605_Assessment_2_Brief_DesignSpecification Page 5 of 5 Marking CriteriaFPCDHDTask 4: For the given case study, provide an EntityRelationship Diagram (ERD).20%The student has nounderstanding ofwhat an ERD is.The student hasvery limitedunderstanding ofwhat an ERD is.The student hasclear understandingof what an ERD isbut therepresentation ismostly incorrectand the solution isnot in sync with thegiven case study.The student hasclear understandingof what a, ERD isbut therepresentation ismostly incorrect.The solution,however, is in syncwith the given casestudy.The student hasclear understandingof what an ERD is.Representation ismostly correct andthe solution is insync with the givencase study. Thesolution has beengiven using atechnical tool(software).Task 5: For the given case study, identify the datastores including the files that are not part of ERD.5%The student has nounderstanding ofwhat data store/file system is andhow it relates todata stores andERD.The student hasvery limitedunderstanding ofwhat data store/file system is andhow it relates todata stores andERD.The student hasclear understandingof what data store/file system is andhow it relates todata stores andERD. The solution ishowever not in syncwith the given casestudy.The student hasclear understandingof what data store/file system is andhow it relates todata stores andERD. The solution ispartially in syncwith the given casestudy.The student hasclear understandingof what data store/file system is andhow it relates todata stores andERD. The solution iscompletely in syncwith the given casestudy.Task 6: Translate the ERD you developed in Task 4into a physical relational database design.Document database tables and their relationshipin MSWord file. Normalise your database designto the Third Normal Form (3NF).16%The student has nounderstanding ofhow normalisationis done.The solution is in itsfirst normal form.The solution is in itssecond normalform.The solution is in itsthird normal form.The solution is in itsthird normal formand the solutionhas been givenusing a technicaltool.