1 / 18

Chapter 4

Chapter 4. Introduction to Database Development. Outline . Context for database development Goals of database development Phases of database development CASE tools. Information System. Traditional Life Cycle. Development Alternatives. Difficulties Operational system is produced late

theresa
Download Presentation

Chapter 4

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Chapter 4 Introduction to Database Development

  2. Outline • Context for database development • Goals of database development • Phases of database development • CASE tools

  3. Information System

  4. Traditional Life Cycle

  5. Development Alternatives • Difficulties • Operational system is produced late • Rush to begin implementation • Requirements are difficult to capture • Alternative methodologies • Spiral approaches • Rapid application development • Prototypes may reduce risk

  6. Graphical Models • Explicit or implicit • Data model • Process model • Environment interaction model • Emphasize data model

  7. Broad Goals of Database Development • Develop a common vocabulary • Define data meaning • Ensure data quality • Provide efficient implementation

  8. Data Quality Measures • Completeness • Lack of ambiguity • Timeliness • Correctness • Consistency • Reliability

  9. Database Development Phases Conceptual Data Modeling Data requirements ERD Logical Database Design Tables Distributed Database Design Distribution Schema Physical Database Design Internal Schema, Populated DB

  10. Splitting Conceptual Design

  11. Cross Checking Requirements

  12. Design Skills • Soft • Qualitative • Degree of subjectivity • People-oriented • Hard • Quantitative • Objective • Intensive data analysis

  13. Design Skills in Phases

  14. Features of CASE Tools • Diagramming • Documentation • Analysis • Prototyping

  15. Classification of CASE Tools • Front-end vs. Back-end • Front-end emphasize data modeling and logical analysis • Back-end emphasize code generation and physical design • DBMS dependent vs. DBMS independent

  16. Commercial CASE Tools • PowerDesigner 9 • Oracle 9i Designer • Visual Studio .Net Enterprise Architect • ERWin • ER/Studio • Visible Analyst

  17. ER Assistant • CASE tool distributed with the textbook • Customized for this textbook: supports the ERD notation used in Chapters 5 and 6 • Drawing tool • Diagram checking • Easy to use and powerful tool

  18. Summary • Background for second part of the course • Relationship to information systems development • Broad goals • Development phases • CASE tool features

More Related