Get premium membership and access questions with answers, video lessons as well as revision papers.

Describe the main phases involved in database design.

      

Describe the main phases involved in database design.

  

Answers


kelvin
Database design is made up of two main phases: logical and physical database design.
Logical database design is the process of constructing a model of the data used in a company based on a specific data model, but independent of a particular DBMS and other physical considerations.
In the logical database design phase we build the logical representation of the database, which includes identification of the important entities and relationships, and then translate this representation to a set of tables. The logical data model is a source of information for the physical design phase, providing the physical database designer with a vehicle for making tradeoffs that are very important to the design of an efficient database.
Physical database design is the process of producing a description of the implementation of the database on secondary storage; it describes the base tables, file organizations, and indexes used to achieve efficient access to the data, and any associated integrity constraints and security restrictions. In the physical database design phase we decide how the logical design is to be physically implemented in the target relational DBMS. This phase allows the designer to make decisions on how the database is to be implemented. Therefore, physical design is tailored to a specific DBMS.

kevowmuchiri answered the question on July 9, 2018 at 19:08


Next: Describe the purpose of a design methodology.
Previous: Identify important factors in the success of database design.

View More Computer Science Questions and Answers | Return to Questions Index


Learn High School English on YouTube

Related Questions