Describe the design stages of the database life cycle.
Database Life Cycle (DBLC)
The database life cycle (DBLC) defines the stages involved in getting any type of database from the modeling tool to actual implementation of physcial tables. The Database BLC never ends because database monitoring, modification, and maintenance are part of the life cycle, and these activities continue long after a database has been implemented. Put simply, the DBLC encompasses the lifetime of the database.
The five stages in the database life cycle are:
Requirements analysis
Logical design
Physical design
Implementation
Monitoring, modification, and maintenance
Five stages of DBLC: 1) Requirements analysis, 2) Logical design, 3)Physical design, 4) Implementation, 5) Monitoring, modification, and maintenance
The first three stages are database-design stages, which are briefly described below.
I. Requirements Analysis
Requirements Analysis is the first and most important stage in the Database Life Cycle.
It is the most labor-intensive for the database designer.
This stage involves assessing the informational needs of an organization so that a database can be designed to meet those needs.
II. Logical Design
During the first part of Logical Design, a conceptual model is created based on the needs assessment performed in stage one. A conceptual model is typically an entity-relationship (ER) diagram that shows the tables, fields, and primary keys of the database, and how tables are related (linked) to one another. The tables sketched in the ER diagram are then normalized.
The normalization process resolves any problems associated with the database design, so that data can be accessed quickly and efficiently.
conceptual model: A description of the structure of a database.
entity-relationship (ER) diagram: A diagram used during the design phase of database development to illustrate the organization of and relationships between data during database design.
normalization: The process of applying increasingly stringent rules to a relational database to correct any problems associated with poor design.
III. Physical design
The Physical Design stage has only one purpose: to maximize database efficiency.
This means finding ways to speed up the performance of the RDBMS. Manipulating certain database design elements can speed up the two slowest operations in an RDBMS: retrieving data from and writing data to a database.
Developing a conceptual model:
In this course, you will complete the tasks associated with Requirements Analysis and the first part of logical design which is developing a conceptual model. The next lesson provides an overview of the post-design stages of the DBLC.
Before moving on to the next lesson, click the link below to learn more about the stages in the DBLC. DBLC Stages Description
