SYSTEMS ANALYSIS AND DESIGN [2242-INSY-3305]Spring 2024 | Instructor: Atieno A. AmadiAssignment-3 Logical Data ModelInstructions:Draw a logical data model (ERD) for the Picnics R US case [Refer to ‘Assignment#1’ and‘Assiignment#2’ on Canvas under ‘Assignments’]Guidelines:A data model describes the data that flow through the business processes in anorganization. It represents the logical [rather than physical] organization of data]. Lateron in the system development process, the data model is changed to reflect exactly howthe data will be stored in databases and files.Hints:Whereas a process model (DFD) represents how the business system will operate, adata model (ERD) represents how the data that flow through the processes areorganized and presented. A data model is a formal way of representing the data that areused and created by a business system. Data stores of the DFD generally correspond toentities of the ERD: Identify the entities Add appropriate attributes for each entity Draw the relationships that connect associated entities Check the process models for data stores, external entities, and data flows Check the major inputs and outputs from the use cases Identify attributes of the entity that are relevant to the system under development Check the process model repository entries for details on data flows anddata stores Check the data requirements of the requirements definition Select each entity’s candidate identifier Start with an entity and identify all entities with which it shares relationships Determine the cardinality and modality of the relationships
Submit a Word document with the answers to the following questions. Review Relational Databases Essential Training and Quick Start Guide to SQLWho was
Submit a Word document with the answers to the following questions. Review Relational Databases Essential Training and Quick Start Guide to SQL Who was E.F. Codd? What are the Pros and Cons of a table structure? What is an integrity error? What does CRUD stand for? What is the purpose