In this lecture, we will: Define key data modeling terms; draw entity-relationship (E-R) and class diagrams to represent common business situations; explain the role of conceptual data modeling in is analysis and design; distinguish between unary, binary, and ternary relationships; define four types of business rules; compare the capabilities of class diagrams vs; E-R diagrams; relate data modeling to process and logic modeling. | Business System Development CSC581 Lecture 13 Structuring System Logical Requirements 2 Summary of the previous lecture In previous lecture, we : Used structured English as a tool for representing steps in logical processes in data flow diagrams. Used decision tables and decision trees to represent logical choice in conditional statements. Selected among structured English, decision tables, and decision trees. Outlines We today’s lecture we will: Define key data modeling terms. Draw entity-relationship (E-R) and class diagrams to represent common business situations. Explain the role of conceptual data modeling in IS analysis and design. Distinguish between unary, binary, and ternary relationships. Define four types of business rules. Compare the capabilities of class diagrams vs. E-R diagrams. Relate data modeling to process and logic modeling Conceptual Data Modeling A detailed model that captures the overall structure of data in an organization Independent of any database . | Business System Development CSC581 Lecture 13 Structuring System Logical Requirements 2 Summary of the previous lecture In previous lecture, we : Used structured English as a tool for representing steps in logical processes in data flow diagrams. Used decision tables and decision trees to represent logical choice in conditional statements. Selected among structured English, decision tables, and decision trees. Outlines We today’s lecture we will: Define key data modeling terms. Draw entity-relationship (E-R) and class diagrams to represent common business situations. Explain the role of conceptual data modeling in IS analysis and design. Distinguish between unary, binary, and ternary relationships. Define four types of business rules. Compare the capabilities of class diagrams vs. E-R diagrams. Relate data modeling to process and logic modeling Conceptual Data Modeling A detailed model that captures the overall structure of data in an organization Independent of any database management system (DBMS) or other implementation considerations Process of Conceptual Data Modeling Develop a data model for the current system Develop a new conceptual data model that includes all requirements of the new system In the design stage, the conceptual data model is translated into a physical design Project repository links all design and data modeling steps performed during SDLC 8 Deliverables and Outcome Primary deliverable is an entity-relationship (E-R) diagram or class diagram As many as 4 E-R or class diagrams are produced and analyzed E-R diagram that covers data needed in the project’s application E-R diagram for the application being replaced E-R diagram for the whole database from which the new application’s data are extracted E-R diagram for the whole database from which data for the application system being replaced is drawn 9 Deliverables and Outcome (cont.) Second deliverable is a set of entries about data objects to be stored in repository or project dictionary. .
