Exam 12: Designing Databases and Entity-Relationship Diagramming

Before you begin the process of designing a database,it is important that you first understand the business rules.

A(n)_____ is a graphic method of representing entity classes and their relationships.

The business world is full of _____ relationships that must be eliminated before an organization can correctly implement a relational database.

The staff of a hospital,a supplier of optical fibers,raw materials for production are all examples of ____.

Within an entity-relationship diagram,a dotted line connecting entity classes represents a(n)____.

A(n)_____ relation is a relation you create to eliminate a many-to-many relationship.

Normalization involves removing all repeating groups or _____ relationships.

Which of the following denotes a relationship between entity classes in an E-R diagram?

Defining relationships among entity classes is the second step in designing and building a relational database.

If you were looking at an E-R diagram,how would you be able to identify a many-to-many relationship between two entities?

Defining entity classes and primary keys is the third step in designing and building a relational database.

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

An intersection relation consists of:

The goal of the first step in designing a relational database is to define and identify _____ and their primary keys for your database.

An E-R diagram includes four basic symbols.

A relational database is the most popular of all database types.

An E-R diagram includes five basic symbols.Which one denotes an optional relationship between entity classes?

Which of the following would be a good primary key for the entity class of students?

A(n)_____ helps you specify the logical organization for a database and access and use the information within the database.

A(n)_____ is an occurrence of an entity class that can be uniquely described.