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...
The Low option of the Quality attribute of a Flash movie emphasizes both appearance and speed, but it will sacrifice appearance for speed if necessary.
Answer the following statement true (T) or false (F)
The process of pressing and releasing the left mouse button two times in rapid succession is known as ________
A) double-clicking B) clicking C) dragging D) right-clicking
____ are documents containing a specific programming language, such as HyperText Markup Language (HTML) or JAVA, etc., that are designed to be viewable on the World Wide Web.
A. Web pages B. Crackers C. Macros D. Patches
The ________ function will use average values to determine the rank of a number within a list if tied values are present
Fill in the blank(s) with correct word