51.
Defining relationships among entity classes is the second step in designing
and building a relational database.
52.
An entity-relationship (E-R) diagram is a graphic method of representing
entity classes and their relationships.
53.
An E-R diagram includes four basic symbols.
54.
In an E-R diagram, a dotted line denotes an entity class.
55.
In an E-R diagram, “|” denotes a single relationship.
56.
In an E-R diagram, O is used to denote an entity class.
57.
In an E-R diagram, a rectangle denotes a relationship.
58.
In an E-R diagram, crow’s foot denotes a multiple relationship.
59.
Your implementation of technology should match the way your business
works.
60.
The numerical nature of the E-R relationship is referred to as “minimum and
maximum cardinality.”
61.
To develop the numerical relationships or cardinality among entity classes,
you must clearly understand the business environment and its business
rules.
62.
The first rule of normalization states that repeating groups can exist among
the entity classes.
63.
Normalization is a process of assuring that a relational database structure
can be implemented as a series of three-dimensional relations.
64.
An intersection relation is a relation you create to detect a many-to-many
relationship.
65.
A foreign key consists of the primary key fields from two intersecting
relations.
66.
Repeating groups should be eliminated during database design.
67.
Defining entity classes and primary keys is the third step in designing and
building a relational database.
68.
A database management system helps you specify the logical organization
for a database and use the information within it.
69.
A data dictionary consists of the primary key fields from the two
intersecting relations.
Fill in the Blank Questions
70.
A(n) _____ is a collection of information that you organize and access
according to the logical structure of that information.
71.
A relational database uses a series of logically related _____ tables or files
to store information in the form of a database.
72.
_____ are statements concerning the information you need to work with and
the relationships within the information.
73.
A(n) _____ is a concept about which you wish to store information and that
you can identify with a unique key.
74.
The first step in designing a _____ is to define the various entity classes and
the primary keys that uniquely define each record or instance within each
entity class.
75.
A library wishes to store information about its members in its database.
Here, members belong to a(n) ____ class.
76.
A(n) _____ is a field (or group of fields in some cases) that uniquely
describes each record.
77.
A(n) _____ is an occurrence of an entity class that can be uniquely
described.