How data base design fits into the overall systems development process

Database Design :
Is the method of producing a detailed data representation of a database.

The database design process is comprised of the next six steps:

Requirements collection and analysis:

The first step in designing a database is to choose what type of data require to be stored in the database, and what applications must be built on top of it, and what operations are most common and subject to presentation requirements.

Conceptual database design:

The aim is to create a simple explanation of the data that very much matches how users and developers imagine of the data.

Choosing a DBMS :

The Purpose of this step is to establish which the best framework for implementing the produced schema is. For example, type of DBMS (relational, network, deductive …). Or, what types of query languages.

Data model mapping(data model mapping) :

That is to alter the generic, DBMS independent conceptual schema in the data model of the selected DBMS.

Physical database design :

To decide the specific storage structures and access paths for the database files.

Database system implementation :

Database system implementation, consists of inflowing data and maintaining the DBMS

In order to have a good database design , usually those six steps must be considered on the design.

Written by: Mohammed Alaslani

Advertisement