Podcast
Questions and Answers
Physical Data Independence is the capacity to change the internal schema without having to change the conceptual schema.
Physical Data Independence is the capacity to change the internal schema without having to change the conceptual schema.
True
Logical Data Independence is the capacity to change the conceptual schema without having to change the external schema.
Logical Data Independence is the capacity to change the conceptual schema without having to change the external schema.
True
Physical Data Independence is not important in database design.
Physical Data Independence is not important in database design.
False
Implementation (representational) data models provide concepts that fall between the above two, used by many commercial DBMS implementations (e.g. relational data models used in many commercial systems).
Implementation (representational) data models provide concepts that fall between the above two, used by many commercial DBMS implementations (e.g. relational data models used in many commercial systems).
Signup and view all the answers
In many DBMSs, the DDL is also used to define internal and external instances.
In many DBMSs, the DDL is also used to define internal and external instances.
Signup and view all the answers
Three-tier Architecture Can Enhance Security because clients does not contain user interfaces and Web browsers.
Three-tier Architecture Can Enhance Security because clients does not contain user interfaces and Web browsers.
Signup and view all the answers
Conceptual (high-level, semantic) data models provide concepts that describe details of how data is stored in the computer.
Conceptual (high-level, semantic) data models provide concepts that describe details of how data is stored in the computer.
Signup and view all the answers
When a schema at a higher level is changed, only the mappings between this schema and middle-level schemas need to be changed in a DBMS that fully supports data independence.
When a schema at a higher level is changed, only the mappings between this schema and middle-level schemas need to be changed in a DBMS that fully supports data independence.
Signup and view all the answers