B ITM 330 Chapter Notes - Chapter 5: Data Modeling, Data Definition Language, Logical Data Model

• School: SUNY Albany
• Department: Information Technology Management
• Course: B ITM 330
• Professor: Jakov Crnkovic

Document Summary

Db development process: e-r diagramming is a part of conceptual data model, after creating a database, and making work-flows and use-case descriptions, in the systems analysis and design area, the next step is data flow. Diagramming (dfd): the most common problems when dealing with entities, attributes and relationships: Note*** when creating e-r diagram, very often designer will use existing or proposed documents and notes from discussions with future database users. There is no unique solution for any of the real life cases. Conceptual data modeling is a step-by-step process for documenting information requirements that is concerned both with the structure of data and with rules about the integrity of that data. Business rules are specifications that preserve the integrity of the logical data model.