reasons for a DBMS correct answers program-data independence, abstraction, meta data,
multiple views, OPTIMIZATION
3 schema architecture consists of correct answers external view, conceptual- hides the physical,
internal- actual physical storage access paths
examples of high level (conceptual) data models: correct answers ER, UML, OO
example of low level (phsical) data model correct answers XML
Example of implementational data model (combines conceptual and physical) correct answers
Relational
most common db language correct answers SQL
structured information that describes, explains, or otherwise makes it easier to retrieve, use, or
manage an information resource correct answers metadata
3 categories of metadata correct answers structrual
administrative
descriptive
defines how objects are put together, such as how pages of a book are comprised correct answers
structural metadata
information to manage a resource- such as who has access, how it was created, etc. correct
answers administrative metadata
, a resource for discovery and identification- such as title, author, keywords correct answers
descriptive metadata
given info:
Student (Name, CWID, address, GPA, major)
is what type of metadata? correct answers structural
given info:
account #, date created, date modified
is what type of metadata? correct answers administrative
given info:
constraints, min/max values
is what type of metadata? correct answers descriptive
6 database design steps: correct answers 1. requirements collection and analysis
2. conceptual DB design
3. choice of DBMS
4. logical design
5. phsyical DB design
6. implementation
in the requirements collection and analysis phase of designing a DB, you must identify ______,
and their characteristics and relationships among them correct answers objects
examples of objects identified in the realty company DB: correct answers buildings, apartments,
renters