provides a description of the data characteristics and the set of relationships that link the data found within the database.
Database Management System
The ______________________ serves as the intermediary between the user and the database.
An _____________ database is used by an organization and supports many users across many departments.
The _______ ____________ structure is quite different from that of an operational or transactional database.
_____________ data exists in a format that does not lend itself to processing that yields information.
A __________ is a logically connected set of one or more fields that describes a person, place, or thing.
a detailed description of an organizations operations.
Business rules are derived from _________________________________________.
Used to define entities, attributes, relationships, and constraints
Which is true of business rules?
A verb associating two nouns in a business rule translates to a _____________ in the data model.
Entity relationship (ER)
The _________ ______________ model was developed to allow designers to use a graphical tool to examine structures rather than describing them with text.
A _____________ model represents a global view of the database as viewed by the entire organization.
In the relational model, ______ are important because they are used to ensure that each row in a table is uniquely identifiable.
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.
Referential __________ means that if the foreign key contains a value, that value refers to an existing valid tuple (row) in another relation.
Since it is used to link the tables that originally were related in a M:N relationship, the composite entity structure includes -as foreign keys - at least the __________ keys of the tables that are to be linked.
When the PK of one entity does not contain the PK of a related entity, the relationship is ______.
If an employee within an EMPLOYEE entity has a relationship with itself, that relationship is known as a ________ relationship.
An ______________ entity is composed of the primary keys of each of the entities to be connected.
The relationships depicted within the _____________ ______________ are sometimes described in terms of "is-a" relationships.
______________ is the bottom-up process of identifying a higher-level, more generic entity super type from lower-level entity subtypes.
The most important characteristic of an entity is its ______________ key, used to uniquely identify each entity instance.
Natural key or Natural identifier
A _______________ ( or ___________) key is a real-world, generally accepted identifier used to uniquely identify real-world objects.
____________ relationships occur when there are multiple relationship paths between related entities.
Normalization works through a series of stages called normal forms. For most purposes in business database design, _____ stages are as high as you need to go in the normalization process.
Attribute A ___________ attribute B if all of the rows in the table that agree in value for attribute A also agree in value for attribute B.
Dependencies based on only a part of a composite primary keys are called ________ dependencies.
In a real-world environment, we must strike a balance between design integrity and ___________.
Make sure entities are in normal form
When designing a database, you should __________________________________________.