1 / 16

CSIT313 Database Programming

CSIT313 Database Programming. Lecture 1: Database Design Methodology : Introduction. Learning Objectives. Database Design Terminology Purpose of Database Design Phases of Database Design. Database Application Lifecycle. DB Planning. System Definition. Requirements Collection and Analysis.

bruis
Download Presentation

CSIT313 Database Programming

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. CSIT313 Database Programming Lecture 1: Database Design Methodology : Introduction

  2. Learning Objectives • Database Design Terminology • Purpose of Database Design • Phases of Database Design

  3. Database Application Lifecycle DB Planning System Definition Requirements Collection and Analysis Database Design Conceptual Design DBMS Selection Logical Design Application Design Physical Design Implementation Data Conversion & Loading Prototyping Testing Operational Maintenance

  4. Database Application Lifecycle • Database Planning : Management activities that allow the stages of the database application to be realized as efficiently as possible • System Definition : The scope and boundaries of the application including its major application areas and user groups

  5. Database Application Lifecycle • Application Design : Design of the user interface and the application programs that use and process the database. • Prototyping : Building a working model of a database application • Implementation : Physical realization of the database and application design

  6. Database Application Lifecycle • Data Conversion and Loading : Transferring any existing data into the new database and converting any existing processes to run on the new database. • Testing : Process of executing the application programs with the intent of finding errors. • Operational Maintenance : Process of monitoring and maintaining the system following installation.

  7. Overview of Database Design • Data Modeling : • Assist in understanding of the semantics of data • Facilitate the communication about information requirements • Criteria for Optimal Data Models:

  8. Database Design Methodology • A structured approach that uses procedures, techniques, tools and documentation aids to support and facilitate the process of design DBDL Interaction with users Data-driven approach Data dictionary Structured methodology validate Repeat diagrams Structural and integrity considerations

  9. Phases of Database Design • Conceptual Database Design • Process of constructing a model of the information used in an enterprise independent of all physical considerations • Logical Database Design • Process of constructing a model of information used in an enterprise based on a specific data model but independent of a particular DBMS or any other physical considerations • Physical Database Design • Description of the implementation of the database on secondary storage. It describes the storage structures and access methods for efficient access.

  10. Conceptual Logical Physical Overview of Database Design • Build local conceptual data model for each user view • Build and Validate local logical data model for each user view • Build and validate global logical Model • Translate global logical model for target DBMS • Design Physical representation • Design Security Mechanisms • Monitor and Tune operational system

  11. Conceptual Database Design • Build local logical data model for each user view 1.1 Identify entity types 1.2 Identify relationship types 1.3 Identify and associate attributes with entity or relationship types 1.4 Determine Attribute Domains 1.5 Determine candidate and primary key attributes 1.6 Specialize/generalize entity types 1.7 Draw Entity-Relationship Diagram 1.8 Review local conceptual data model with user

  12. Logical Database Design • Build and validate local logical data model 2.1 Map local Conceptual data model to local local data model 2.2 Derive relations from local logical data model 2.3 Validate model using normalization 2.4 Validate model against user transactions 2.5 Draw Entity relationship Diagram 2.6 Define integrity constraints 2.7 Review Local logical data model with user

  13. Logical Database Design • Build and Validate Global Logical data model 3.1 Merge local logical data models into global model 3.2 Validate global logical data model 3.3 Check for future growth 3.4 Draw final Entity Relationship diagram 3.5 Review global logical data model with users

  14. Physical Database Design • Translate Global Logical Data Model for target DBMS 4.1 Design base relations for target DBMS 4.2 Design enterprise constraints for target DBMS • Design Physical Representations 5.1 Analyze transactions 5.2 Choose file organizations

  15. Physical Database design 5.3 Choose secondary indexes 5.4 Consider introduction of controlled redundancy • Design Security Mechanisms 6.1 Design user views 6.2 Design access rules • Monitor and tuner operational system

More Related