Create an account
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 __________________________________________.
Please allow access to your computer’s microphone to use Voice Recording.
Having trouble? Click here for help.
We can’t access your microphone!
Click the icon above to update your browser permissions and try again
Reload the page to try again!Reload
Press Cmd-0 to reset your zoom
Press Ctrl-0 to reset your zoom
It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.
Please upgrade Flash or install Chrome
to use Voice Recording.
For more help, see our troubleshooting page.
Your microphone is muted
For help fixing this issue, see this FAQ.
Star this term
You can study starred terms together