Reference no: EM132394547
MIS605 Systems Analysis and Design Assignment - Laureate International Universities, Australia
Complete the following tasks:
Task 1 - Create and document a Context Diagram for the System.
Task 2 - Create and document a Level 0 Data Flow Diagram (DFD). The Level 0 DFD should contain all the major high-level processes of the System and how these processes are interrelated.
Task 3 - Select three major and non-trivial processes from Level 0 DFD, decompose each of the processes into a more explicit Level 1 DFD.
Task 4 - Using your own experience with similar online student enrolment systems and the information 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 of entities in the System. You are expected to use your own experience with information systems in general and online student enrolment systems in particular to develop this ERD. For example, would Subject Name be an attribute for a Subject? Would Date of Birth be an attribute for Students?
Task 5 - Should data be stored in files in a file system or in a database for the System? Justify your answer.
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 database design to the Third Normal Form (3NF).
4. 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 Lucidchart and copied into the MSWord document.
- Please note that you are NOT required to copy the task description over to the MS Word document. Use the task number to indicate which task your response relates to.
- The recommended font size is 12 with 1.5 spacing.
Referencing - It is essential that you use appropriate APA style for citing and referencing research.