DATABASE C192 (DATABASE C192)

external schema correct answer: Also called a subschema, this is a specific view of the data utilized by an end user conceptual schema correct answer: This describes all the entities, attributes, and relationships together with integrity constraints. Each DB has exactly one. internal schema correct answer: A complete description of the internal model, down to the physical storage of data. Each DB has exactly one. logical data independence correct answer: The immunity of the external...

DATABASE C192OA Study Guide 2 What is a limitation of a database management system (DBMS)? Integrity Consistency Redundancy Complexity Which database management system (DBMS) type is an integrated data store (IDS) an example of? Relational DBMS oracle Network DBMS@@ IDS Hierarchical DBMS IMS Object- oriented DBMS What is a valid ISO SQL data type? Prefix Tiny int Boolean Datestamp Which term can be described as the immunity of the external schemas to changes in the conceptual schema? Logical dat...

DATABASE C192OA Study Guide 2 What is a limitation of a database management system (DBMS)? Integrity Consistency Redundancy Complexity Which database management system (DBMS) type is an integrated data store (IDS) an example of? Relational DBMS oracle Network DBMS@@ IDS Hierarchical DBMS IMS Object-oriented DBMS What is a valid ISO SQL data type? Prefix Tiny int Boolean Datestamp Which term can be described as the immunity of the external schemas t...