Exam 12: Designing Databases and Entity-Relationship Diagramming

Within an entity-relationship diagram,a "|" represents a(n)____.

Repeating groups should be eliminated during database design.

An intersection relation is also known as a(n)_____ relation.

Which symbol would you use in an E-R diagram to show that a student can enroll in more than one course?

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

_____ is a set of tools that you use to process information.

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

The _____ contains the logical structure for the information in a database.

What is the first step in designing and building a database?

Which symbol would you use in an E-R diagram to show that a student may or may not enroll in a course?

The complete normalization process is _____ and quite necessary for developing organization-wide databases.

In an E-R diagram,crow's foot denotes a multiple relationship.

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

When creating a database you don't need to know the physical location of the information you want to see or use.

If you find a many-to-many relationship,which of the following is a guideline to be followed when creating an intersection relation?

The numerical nature of the E-R relationship is referred to as "minimum and maximum cardinality."

Which of the following defines a database?

An E-R diagram includes five basic symbols.Which of the following denotes a single relationship between entity classes?

Within an entity-relationship diagram,_______ is used to represent multiple relationships.

In an E-R diagram,O is used to denote an entity class.