Database Application, Development Process - Database Management - Lecture Slides, Slides of Introduction to Database Management Systems

Download Database Application, Development Process - Database Management - Lecture Slides and more Slides Introduction to Database Management Systems in PDF only on Docsity!

Database

Management

Systems

Lecture - 5

Lecture’s Overview

Database Application Development Process

Preliminary Study of System

Database Design

A DB Design is a model of a particular real-world system

It provides a picture of reality

Should be simple and self- explanatory Docsity.com

Database

Development

Process

Design Stages Analyze User Environment Develop Conceptual Model Map Conceptual Model to Logical Choose DBMS Develop Physical Design Implement System Test System Operational Maintenance Docsity.com

Analyze Existing System

Objective: To understand the working of existing system

Analyze users’ requirements

Data Flow

Diagrams

Data Flow Diagrams (DFDs)

Represent the flow of data between different processes within a system

Data Flow Diagrams

Limitations  Focus only on flows of information  Decision points/basis not included

DFD-Symbols

Dataflows: pipelines through which packets of information flow. Arrows are labeled with name of the data that moves through

DFD-Symbols

Process

transforms incoming data flow into outgoing data flow

OR

DFD-Process

Numbered

Name is verb/object phrase;

Noun for high-level systems

OR

Process

Process

DFD-Symbols Collector

Several data flows combine here

No processing occurs here

DFD-Symbols

Separator

Several data flows split from here

No processing