Database Final (Midterm portion)
model
A _____'s main function is to help one understand the complexities of the real-world environment
1NF
A table that has all key attributes defined, has no repeating groups, and all its attributes are dependent on the primary key is said to be in ___
entity
An ______ is anything about which data are to be collected and stored
entity
An ______ represents a particular type of object in the real world
attribute
An _________ is the equivalent of a field in a file system
Julian
Data attributes contain calendar dates stored in a special format known as the ______ date format
Column
Each table ______ represents an attribute
4NF
Some very specialized applications may require normalization beyond the ___
True
T/F A data model is usually graphical
True
T/F An entity in the entity relationship model corresponds to a table in the relation environment
False
T/F An implementation-ready data model needn't necessarily contain enforceable rules to guarantee the integrity of the data
True
T/F An implementation-ready data model should contain a description of the data structure that will store the end-user data
False
T/F Database programming languages receive all application requests and translate them into the complex operations required to fulfill those requests
True
T/F Entity supertypes and subtypes are organized in a specialization hierarchy
False
T/F Even when a good database blueprint is available, an applications programmer's view of the data should match that of the manager and the end user
True
T/F In order to meet performance requirements, portions of the database design may need to be occasionally denormalized
True
T/F In the entity relationship model, a table row corresponds to an entity instance
True
T/F Metadata describes the data characteristics and the set of relationships that links the data found within the database
False
T/F Normalization is a process that is used for changing attributes to entities
True
T/F Normalization works through a series of stages called normal forms
True
T/F One important inheritance characteristic is that all entity subtypes inherit their primary key attribute from their supertype
False
T/F The Crow's Foot notation is less implementation-oriented than the Chen notation
False
T/F The DBMS reveals much of the database's internal complexity to the application programs and users
False
T/F The entity relationship model is dependent on the database type
True
T/F The entity supertype contains common characteristics, and the entity subtypes each contain their own unique characteristics
True
T/F The only way to access the data in a database is through the DBMS
False
T/F The order of the rows and columns is important to the DBMS
True
T/F The practical significance of taking the logical view of a database is that it serves as a reminder of the simple file concept of data storage
True
T/F The relationship depicted within the specialization hierarchy are sometimes described in terms of "is-a" relationships
False
T/F Within a specialization hierarchy, a supertype can exist only within the context of a subtype
True
T/F Within the database environment, a data model represents data structure with the purpose of supporting a specific problem domain
True
T/F You can think of a table as a persistent representation of a logical relation
UML
The ___ notation of entity relationship modelling can be used for both conceptual and implementation modelling
Conceptual
The entity relationship diagram represents the __________ database as viewed by the end user
Predicate
_________ logic, used extensively in mathematics, provides a framework in which an assertion (statement of fact) can be verified as either true or false
