《hoffer_mdm11e_pp_ch01》.ppt

* * * * * * * * * * * ENTERPRISE DATA MODEL First step in the database development process Specifies scope and general content Overall picture of organizational data at high level of abstraction Entity-relationship diagram Descriptions of entity types Relationships between entities Business rules * * FIGURE 1-6 Example business function-to-data entity matrix * Chapter 1 ? 2013 Pearson Education, Inc. ?Publishing as Prentice Hall TWO APPROACHES TO DATABASE AND IS DEVELOPMENT SDLC System Development Life Cycle Detailed, well-planned development process Time-consuming, but comprehensive Long development cycle Prototyping Rapid application development (RAD) Cursory attempt at conceptual data modeling Define database during development of initial prototype Repeat implementation and maintenance activities with new prototype versions * SYSTEMS DEVELOPMENT LIFE CYCLE(SEE ALSO FIGURE 1-7) * Planning Analysis Physical Design Implementation Maintenance Logical Design SYSTEMS DEVELOPMENT LIFE CYCLE(SEE ALSO FIGURE 1-7) (CONT.) * Planning Analysis Physical Design Implementation Maintenance Logical Design Planning Purpose–preliminary understanding Deliverable–request for study Database activity– enterprise modeling and early conceptual data modeling SYSTEMS DEVELOPMENT LIFE CYCLE(SEE ALSO FIGURE 1-7) (CONT.) * Planning Analysis Physical Design Implementation Maintenance Logical Design Analysis Purpose– (thorough) requirements analysis and structuring Deliverable–functional system specifications Database activity–(thorough and) integrated conceptual data modeling SYSTEMS DEVELOPMENT LIFE CYCLE(SEE ALSO FIGURE 1-7) (CONT.) * Planning Analysis Physical Design Implementation Maintenance Logical Design Logical Design Purpose–information requirements elicitation and structure Deliverable–detailed design specifications Database activity– logical database design (transactions, forms, displays, views, data integrity and security) SYSTEMS DEVELOPMENT LIFE CYCLE(SEE ALSO FIGURE