1 / 18

Comprehensive Guide to Database Development Phases and Tools

This chapter introduces the essential context for database development, articulating its goals and phases. It discusses various methodologies, such as traditional life cycle models, spiral methodologies, and rapid application development. The importance of data quality measures including completeness, timeliness, and correctness is emphasized. It outlines the skill sets required for effective database design and covers the features of CASE tools, highlighting the distinctions between front-end and back-end tools. This resource provides foundational knowledge crucial for successful information systems development.

theresa
Télécharger la présentation

Comprehensive Guide to Database Development Phases and Tools

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