No Slide Title

Download 1.04 Mb.

Page	10/10
Date	27.11.2021
Size	1.04 Mb.
	#57792

1 2 3 4 5 6 7 8 9 10

3. DATABASE DEVELOPMENT LIFECYCLE (DBDLC)

Database Design

Three main phases of DB design:

Conceptual Database Design.

Create a conceptual data model Independent of any implementation details.

Logical Database Design. (What)

At this point you know which type of DBMS you will implementing in - e.g. relational, object-oriented etc (but not the actual DBMS).
Test the correctness of the data model through normalization.

Physical Database Design. (How)

Derive tables & constraints.
Identify storage structures and access methods.
Design security features.

DBMS Selection

Selection of an appropriate DBMS to support the database system.
Undertaken at any time prior to logical design.

Main steps for selecting a DBMS:

Define Terms of Reference of study;
Shortlist two or three products;
Evaluate products;
Recommend selection and produce report.

Application Design

Design of user interface and application programs that use and process the database.
Database design and application design are parallel activities.
Includes two important activities:

transaction design;
user interface design.

Prototyping

Building working model of a database system to evaluate how the final system will look and function.
Purpose:

to identify features of a system that work well, or are inadequate;
to suggest improvements or even new features;
to clarify the users’ requirements;
to evaluate feasibility of a particular system design.

Implementation

Physical realization of the database and application designs.

Create database schemas and empty database files. (DDL)
Create the application programs. (DML and JAVA or C++ ...)

Data Conversion and Loading

Transferring any existing data into new database and converting any existing applications to run on new database.
Only required when new database system is replacing an old system.

Testing

Process of running the database system with intent of finding errors.
Use carefully planned test strategies and realistic data.
Demonstrates that database and application programs appear to be working according to requirements.

Operational Maintenance

Process of monitoring and maintaining database system following installation.

Operational Maintenance Activities:

Monitoring performance of system.
Maintaining and upgrading database application.
Incorporating new requirements into DB application.

Download 1.04 Mb.

Share with your friends:

1 2 3 4 5 6 7 8 9 10

The database is protected by copyright ©ininet.org 2024
send message