this is a follow up on assesment 1 which i submitted here some weeks back, i have attached the case study from assesment 1 incase the writer cant find it.... please there might be a need to refer to the solutions for assesment 1.... please forward any questions to me
MIS605_Assessment 1_Case Study Page 1 of 1 Online Student Enrolment System at ABC University ABC University (ABCU) is seeking to develop an online student enrolment system (the System) whereby the students would be able to enrol themselves into eligible subjects at the beginning of each trimester and pay their tuition fees online. You have been hired as the Business Analyst for this project. Founded in Sydney in 2013, ABCU has experienced a remarkable growth in student numbers in recent years and has opened new campuses in three other Australian cities including Melbourne, Brisbane and Adelaide. ABCU currently has 50,000 students across their four campuses with an estimated 5000 student in-take in each trimester. This phenomenal growth in their student numbers has necessitated the need for an online student enrolment system. Once developed, this system will replace the manual enrolment process that is currently in place. The current manual enrolment process is labour- intensive, error-prone, and rather inefficient as it requires the Student Enrolment Officers to manually enrol each student into the subjects upon the receipt of a study plan from the students. The Pro Vice Chancellor (Learning and Teaching) envisage an online student enrolment system which would allow students to complete their enrolments and tuition fee payments before the Census date. The System should not only enable Student Enrolment Officers of each School to create, edit and remove Courses offered by their School but also to create, edit and remove core subjects and electives offered in each course. The students should be able to access the system through a device of their choice (e.g. desktop web browser, mobile phone or tablet app). Most subjects would have pre-requisites that must be satisfied before the students are eligible to enrol in the subject. It would be the responsibility of the Program Directors to provide and update the relevant course and subject information including the descriptor, availability (i.e. whether a subject or a course is offered in a certain trimester) and the prerequisites. The Timetabling Officers may also create, edit and remove timetables for each available Subject through the new System. Each campus will hold multiple classes for the same subject. A Subject is offered in the form of classes. Each campus may offer multiple classes for the same Subject. Once logged into the System, students should be able to view all the available subjects, enrol in and drop subjects. The System will detect timetable clashes and prevent students from enrolling into subjects that clash. The System should not let students to enrol in too many or few subjects unless they have an increased or reduced study load approved by the Student Enrolment Officer. Once the enrolment has been completed the system will generate a timetable customised to each individual student outlining the class times and locations. The System will then prompt the students to pay their tuition fees through a secure payment process. The System should be able to send email reminders to students who have not completed the enrolment process by a designated deadline. It should also allow the Student Enrolment Officers and Program Directors to generate customized reports (e.g. a report showing a total number of students enrolled in a particular subject or a course). MIS605_Assessment 2_Additional Case Information Page 1 of 1 Additional Case Information In a Joint Application Development (JAD) session, the representatives of the Student Enrolment Officers and the Program Directors provided the following business rules: A Course can contain one or more Subjects A Subject may belong to one or more Courses There are one or more classes running for each Subject One Class is delivered on one campus One campus may run one or more Classes. A Program Director may be responsible for one or more Courses One Course is under the responsibility of one and only one Program Director. A student must undertake a minimum of one Subject per Trimester. A student must undertake no more than five (5) Subjects per Trimester A Class contains multiple students ABCU IT Support also provided: The System needs be synchronised with Blackboard. i.e. enrolled students will be automatically added to correct Subject in Blackboard. Student and staff login credentials are stored in a central database external to the System. MIS605_Assessment_2_Brief_Design Specification Page 1 of 8 Task Summary Based on your responses to Assessment 1 – Written assessment, perform process and data modelling and develop and document a number of design diagrams using UML (including Context Diagram, Level 0 and Level 1 Data Flow Diagram, Entity Relationship Diagram). Context In Assessment 1, you performed a comprehensive requirement analysis for the online student enrolment system at the ABC University. With an in-depth understanding of the functional requirements of the System, you are now required to perform further analysis through process and data 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 new System. Thus, they are an integral part of System Analysis. Process modelling describe business processes – i.e. the sequence of activities that people do; while data modelling seeks to describe the ASSESSMENT 2 BRIEF Subject Code and Title MIS605 Systems Analysis and Design Assessment Design specification Individual/Group Individual Length 2500 words Learning Outcomes The Subject Learning Outcomes demonstrated by successful completion of the task below include: a) Identify, critically evaluate and recommend information systems solutions for inefficiencies in business processes, procedures and work practices using data and process modelling techniques. b) Formulate, validate and document business requirements for a medium-scale information system development project and effectively communicate these requirements to the stakeholders. c) Demonstrate the ability to effectively analyse, design and develop information systems using Unified Modelling Language (UML) models. Submission Due by 11:55pm AEST Sunday end of Module 4.2. Weighting 40% Total Marks 100 marks MIS605_Assessment_2_Brief_Design Specification Page 2 of 8 data flows through those processes. Data flow diagrams (including context diagrams) and entity relationship diagrams are the most common process and data modelling techniques used in industry. Instructions 1. Please read MIS605_Assessment 1_Case Study. Please note that every piece of information provided in this case study serves a purpose. 2. Once you have completed reading the case study, please read the attached MIS605_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 all the 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 the processes into a more explicit Level 1 DFD. (24 marks) 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 MIS605_Assessment_2_Brief_Design Specification Page 3 of 8 example, would Subject Name be an attribute for a Subject? Would Date of Birth be an attribute for Students? (20 marks) Task 5. Should data be stored in files in a file system or in a database for the System? Justify your answer. (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 database design to the Third Normal Form (3NF). (16 marks) 4. Please note that your responses to the tasks above must relate to the