Unlock access to all the studying documents.
View Full Document
A library provides its members with a unique member ID and uses that ID
for identification. This unique ID used instead of a member’s name is an
example of ____.
The goal of the first step in designing a relational database is to define and
identify _____ and their primary keys for your database.
The staff of a hospital, a supplier of optical fibers, raw materials for
production are all examples of ____.
A(n) _____ is a graphic method of representing entity classes and their
relationships.
An entity-relationship (E-R) diagram includes _____ basic symbols.
Within an entity-relationship diagram, the _______ symbol represents an
entity class.
Within an entity-relationship diagram, _______ is used to represent multiple
relationships.
Within an entity-relationship diagram, a dotted line connecting entity
classes represents a(n) ____.
Within an entity-relationship diagram, a “|” represents a(n) ____.
Within an entity-relationship diagram, O is used to denote a zero or ____.
_____ is a set of tools that you use to process information.
Once you determine that a relationship does exist, you must then determine
_____ is a process of assuring that a relational database structure can be
implemented as a series of two-dimensional relations.
The complete normalization process is _____ and quite necessary for
developing organization-wide databases.
An intersection relation will have a _____ primary key that consists of the
primary key fields from the two intersecting relations.
A(n) _____ relation is a relation you create to eliminate a many–to-many
relationship.
Normalization involves assuring that each field within a relation depends
only on the _____ for that relation.
A(n) _____ is a primary key of one relation that appears in another relation.
Normalization involves removing all repeating groups or _____ relationships.
Removing _____ relationships is the most difficult aspect when designing
the appropriate structure of a relational database.
The business world is full of _____ relationships that must be eliminated
before an organization can correctly implement a relational database.
A(n) _____ helps you specify the logical organization for a database and
access and use the information within the database.
The _____ contains the logical structure for the information in a database.