CSDB101 Module 3 Practice

Three (3) Stages of Database Design (DB Design)

Four (4) Stages of Build Process

Collect and analyze the business requirements of the user

Is a design document for building a database that has clear goal

Has a level of abstraction, focuses on business and performs model at the comprehensive level. Often used for enteprise data model and establishing the enterprise architecture.

Accurately expresses keys, attributes, relationships etc. And the data model is higly reusable the work to develop a system.

In Logical Data Modelling denormalization is performed according to the requirement level.

Design in which physical characteristics are considered in order to improve performance and storage efficiency, so that the data can be actual ported to a database.

Abstract conceptualization of the information structure appearing in the real world.

Generally represented by and entity-relationship (ER) model.

Conversion of the result of the conceptual design, which is created for human understanding into logical structure that can be easily stored in a database.

A physical schema is created as phase deliverables.

A logical schema is created as phase deliverables.

Determination of the physical storage structure of the database created using logical structure design.

Determination of the physical storage structure of the database created using logical structure design.

Database implementation of database development phase.

Management and monitoring of database quality.

Directly involved from the phase of requirement collection, establishes a data management system and defines the data standards.

Review and reflect the physical structure area, such as indexes, partition as well as the clustering storage space and denormalization.