7 Analysis – data modelling Once the use cases have been documented, data modelling can be used to organise and document the data requirements. Data is viewed as a resource to be shared by as many processes as possible. As a result, data must be organised in a way that is flexible and adaptable to unanticipated business requirements. TO DO – Data Modelling Make assumptions where necessary. 1. Provide a list of the main entities with a brief description of what each entity is. 2. Construct an entity relationship diagram that provides a logical model of the data for the proposed SCEPACMS. It must show all entities, attributes, relationships and cardinality. It should be in 3rd normal form. Label the primary and foreign keys. Identify any parts of your diagram where you need more information to complete the diagram accurately and list the questions you would ask to get this information You now need to build the process models. Process modelling is a technique for organising and documenting the structure and flow of data through a system’s processes and/or the logic, policies, and procedures to be implemented by a system’s processes. TO DO – Process Modelling 1. Draw a context data flow diagram for the SCEPACMS. Use the information in the case study as an indication of the required inputs and outputs. State any assumptions you make. You are finally asked to provide some visuals for Jim and Mary. They are concerned that they don’t quite understand how some processes will work, both in terms of the activities undertaken, and how the ATS will model those activities. TO DO – Object Modelling 1. Create an activity diagram for the Add Class Meeting Attendance use case. 2. Create a system sequence diagram for the Add Class Meeting Attendance use case. At the end of this phase of the project, the Board of directors is so impressed with the work you have produced, that they suggest you continue and design and implement the ATS. But that’s another story.