80.0k views
1 vote
During the database design process, dbms selection should be done between logical design stage and physical design stage.

a)True
b)False

User SuperManSL
by
8.0k points

1 Answer

6 votes

Final answer:

The DBMS should be selected between the logical design and physical design stages of database design as it influences the physical implementation based on the logical model.

Step-by-step explanation:

The selection of a DBMS (Database Management System) is indeed a crucial step that should be made between the logical design stage and the physical design stage of database design. This is true because the capabilities and limitations of the chosen DBMS will directly impact how the database can be physically implemented based on the logical design.

During the logical design phase, the focus is on the data model and how to logically structure data, independent of any physical considerations. This helps in establishing what the database will contain and how the data will relate. After the logical design, it is important to select an appropriate DBMS before moving on to physical design. The physical design phase involves translating the logical design into a technical specification for storing and retrieving data which is highly dependent on the capabilities of the DBMS. Factors such as performance, scalability, compatibility, and costs associated with a particular DBMS need to be evaluated in relation to the project's requirements.

User Sente
by
8.0k points