____ provides a description of the data characteristics and the set of relationships that link the data found within the database.
A(n) ____ might be written by a programmer or it might be created through a DBMS utility program.
A(n) ___ database is used by an organization and supports many users across many departments.
____ data exist in a format that does not lend itself to processing that yields information.
____ data are the result of formatting to facilitate storage, use and generation of information.
A ___ is a logically connected set of one or more fields that describes a person, place or thing.
A(n) ______'s main function is to help you understand the complexities of the real-world environment.
serve as a communication tool between the users and designers
Which of the following is true of business rules?
A verb associating two nouns in a business rule translates to a(n) ___ in the data model.
In the ___ model, each parent can have many children, but each child has only one parent.
In the ___ model, the user perceives the database as a collection of records in 1:M relationships, where each record can have more than one parent.
(DDL) data definition language
A(n) _____ enables a database administrator to define schema components.
The ____ model was developed to allow designers to use a graphical tool to examine structures rather than describing them with text.
A(n) ____ model represents a global view of the database as viewed by the entire organization.
Date Attributes contain calendar dates stored in a special format known as the ___ date format.
In the context of a database table, the statement "A___B" indicates that if you know the value of attribute A, you can look up the value of attribute B.
functionally dependent on
The attribute B is ___ the attribute A if each value in column A determines one and only one value in column B.
A ___ key can be described as a superkey without unnecessary attributes, that is, a minimal superkey.
The ___ constraint can be placed on a column to ensure that every row in the table has a value for that column.
To be considered minimally relational, the DBMS must support the key relational operators ____, PROJECT and JOIN.
____, also known as RESTRICT, yields values for all rows found in a table that satisfy a given condition.
A(n) ____ join links tables by selecting only the rows with common values in their common attribute(s).
A ___ contains at least all of the attribute names and characteristics for each table in the system.
The ___ is actually a system-created database whose tables store the user/designer-created database characteristics and contents.
In a database context, a(n) ___ indicates the use of different names to describe the same attribute.
When you define a table's primary key, the DBMS automatically creates a(n) ___ index on the primary key
column(s) you declared.
logical data independence
Codd's Rule of ___ states: Application programs & ad hoc facilities are logically unaffected when changes are made to the table structures that preserve the original table values (changing order of columns or inserting columns.)
Codd's Rule of ___ states: If the system supports low-level access to the data, users must not be allowed to bypass the integrity rules of the database.
Although the conceptual model can handle ____ relationships and multivalued attributes, you should not implement them in the RDBMS.
maximum & minimum
Knowing the ___ number of entity occurrences is very helpful at the application software level.
An entity is said to be ___-dependent if it can exist in the database only when it is associated with another related
If an entity can exist apart from one or more related entities, it is said to be ____-independent.
When the PK of one entity does not contain the PK of a related entity, the relationship is ____.
A ____ entity has a primary key that is partially or totally derived from the parent entity in the relationship.
The term ____ is used to label any condition in which one or more optional relationships exist.
The existence of a(n) ____ relationship indicates that the minimum cardinality is at least 1 for the mandatory entity.
If an employee within an EMPLOYEE entity has a relationship with itself, that relationship is known as a ___ relationship.
A(n) ____ entity is composed of the primary keys of each of the entities to be connected.
detailed narrative of the organizations description of operations
The following step occurs first in the process of building an ERD: ____.
If Tiny College had some departments that were classified as "research only," they would not offer courses; therefore, the COURSE entity would be ___ to the DEPARTMENT entity.
The M:N relationship between STUDENT and CLASS must be divided into two 1:M relationships through the use of the ENROLL entity; the ENROLL entity is ____.
If the focus is on data-retrieval speed, you might also be forced to include ___ attributes in the design, which would not ordinarily be done.
Complex ___ requirements may dictate data transformations, and they may expand the number of entities and attributes within the design.
enhanced entity relationship model
The extended entity relationship model (EERM) is sometimes referred to as the ___.
The ___ depicts the arrangement of higher-level entity supertypes (patient entities) and lower-level entity subtypes.
Within a specialization hierarchy, every subtype can have ___ supertype to which it is directly related.
The property of ___ enables an entity subtype to inherit the attributes and relationships of the the supertype.
One important inheritance characteristic is that all entity subtypes inherit their ___ key attribute from their supertype.
at the implementation level, the supertype and its subtypes depicted in the specialization hierarchy maintain a ___ relationship.
A ___ is the attribute in the supertype entity that determines to which entity subtype each supertype occurrence is related.
The default comparison condition for the subtype discriminator attribute is the ___ comparison.
is the bottom-up process of identifying a highter-level, more generic entity supertype from lower-level entity subtypes.
A single abstract entity object
An entity cluster is formed by combining multiple interrelated entities into ___.
the most important characteristic of an entity is its ___ key, used to uniquely identify each entity instance.
A ___ key is a real-world, generally accepted identifier used to uniquely identify real-world objects.
If one exists, a data modeler used a ___ as the primary key of the entity being modeled.
entity instance or row
The primary key's main function is to uniquely identify a ___ within a table.
Composite primary keys are particularly useful as identifiers of composite entities, where each primary key combination is allowed only once in the ____ relationship.
The "____" characteristic of a primary key states the following: The PK must uniquely identify each entity instance. A primary key must be able to guarantee unique values.
The "____" characteristic of a primary key states the following: The selected primary key must not be composed of any attributes that might be considered a security risk or violation.
The "____" characteristic of a primary key states the following: The PK should not have embedded semantic meaning. An attribute with embedded semantic meaning is probably better used as a descriptive characteristic of the entity rather than as an identifier.
___ keys work with primary keys to properly implement relationships in the relational model.
place a foreign key in one of the entities
The preferred placement for a foreign key when working with a 1:1 relationship is to ___.
one side is mandatory and the other side is optional
When selecting a foreign key placement for a 1:1 relationship, place the PK of the entity on the mandatory side in the entity on the optional side as a FK, and make the FK mandatory when ___.
___ data refer to data whose values change over time and for which you must keep a history of the data changes.
a __ occurs when you have one entity in tow 1:M relationships to other entities , thus producing an association among the other entities that is not expressed in that model.
___ relationships occur when there are multiple relationship paths between related entities.
Data ___ is a discipline that focuses on proper generation, storage and retrieval of data.
the ___ defines the portion of the database "seen" by the application programs that produce information from the data.
a ___ is a representation of the relational database's entities, the attributes within those entities and the relationships between those entities.
UML (unified modeling language)
___ is a language based on OO concepts that describes a set of diagrams and symbols used to graphically model a system.
The logical view of the relational database is facilitated by the creation of data relationships based on a logical construct known as a ____.
In a relational table, each column has a specific range of values known as the ___ domain.
In the relational model, ___ are important because they are used to ensure that each row in a table is uniquely identifiable.
The relational operators have the property of closure; that is, the use of relational algebra operators on existing relations (tables) produces new relations.
___ is the real power behind the relational database, allowing the use of independent tables linked by common attributes.
The __ catalog can be described as a detailed system data dictionary that describes all objects within the database.
Relationship strength depends on how the primary key of the related entity is formulated, while the relationship ___ depends on how the business rule is written.
Subtypes that contain non-unique subsets of the supertype entity set are known as ___ subtypes.
The ____ constraint specifies whether each entity supertype occurrence must also be a member of at least on subtype.
Usually, a data modeler uses a natural identifier as the ____ of the entity being modeled, assuming that the entity has a natural identifier.
Composite keys are useful as identifiers of weak entities, where the entity has a strong ___ relationship with the parent entity.
If you use a surrogate key, you must ensure that the candidate key of the entity in question performs properly through the use of the ___ and "not null" constraints.
From a data modeling point of view, ___ data refer to data whose values change over time and for which you must keep a history of the data changes.