Exam 12: Designing Databases and Entity-Relationship Diagramming

An instance uniquely describes records.

A foreign key consists of the primary key fields from two intersecting relations.

A composite primary key is:

There are _____ primary steps in designing and building a database.

_____ is a process of assuring that a relational database structure can be implemented as a series of two-dimensional relations.

A(n)_____ is a collection of information that you organize and access according to the logical structure of that information.

A library wishes to store information about its members in its database.Here,members belong to a(n)____ class.

Removing _____ relationships is the most difficult aspect when designing the appropriate structure of a relational database.

An intersection relation will have a _____ primary key that consists of the primary key fields from the two intersecting relations.

What is the most popular type of database?

A relational database uses a series of logically related two-dimensional tables or files to store information in the form of a database.

A database management system helps you specify the logical organization for a database and use the information within it.

Why would you define business rules for a database?

Which symbol should you use in an E-R diagram to show the relationship between a student and the courses they are currently enrolled in?

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.

An intersection relation is:

A primary key is a field (or group of fields in some cases)that uniquely describes each record.

A data dictionary contains:

The first step in designing a relational database involves defining information for each relation.

An organization wishes to store information about its employees in a database.The employees,in this case,constitute a(n)____.