BMGT 402 Lecture Notes - Lecture 18: Database Design, Database, Data Conversion

• School: University of Maryland
• Department: Business and Management
• Course: BMGT 402
• Professor: Woei- Jyh Lee

Document Summary

Bmgt402 lecture 18 - chapter 11: database analysis & case study. Stage of database system development lifecycle: database planning. Captures data such as aims and objectives of database project. Documentation produced such as mission statement and objectives of database system: system definition. Captures data such as description of major user views (includes job roles or business application areas) Documentation produced such as definition of scope and boundary of database system; definition of user views to be supported: requirements collection and analysis. Captures data such as requirements for user views; systems specifications including performance and security requirements. Documentation produced such as users and system requirements specifications: database designs. Captures data such as users responses to checking the conceptual/logical database design; functionally provided by target. Documentation produced such as conceptual/logical database (includes er model(s), data dictionary, and relational schema); physical database design: application design. Captures data such as users" responses to checking interface design.