Explain the difference between conceptual, logical, and physical database design. Why might these tasks be carried out by different people?
What will be an ideal response?
Conceptual database design is concerned with building the data model for the organization that is
completely independent of any physical considerations including DBMS (logical database design
assumes a particular DBMS, for example, relational, but is independent of any other physical
considerations). Physical database design, however, is concerned with actually defining the data
model using the DDL of a particular DBMS. Consequently, conceptual/logical database design
focuses on what the data model represents, whereas physical database design focuses on how the
data model is to be implemented. Different skills are required to undertake these design phases,
which are often found in different people.
You might also like to view...
A good way to assess your CPU usage is to
a. feel the temperature of the CPU with your hand. b. listen for the sound of a spinning hard disk drive. c. check the number reported by the system defrag utility. d. check the Performance tab of the Task Manager.
Transitions in a presentation can make presentations more dynamic and interesting
Indicate whether the statement is true or false