Exam 12: Designing Databases and Entity-Relationship Diagramming

The first rule of normalization states that repeating groups can exist among the entity classes.

Once you determine that a relationship does exist,you must then determine the numerical nature of the relationship,what we refer to as " _____."

A database management system is:

An intersection relation is a relation you create to detect a many-to-many relationship.

A supplier is an example of a(n)____.

In an E-R diagram,a dotted line denotes an entity class.

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

Which of the following is not one of the rules of normalization?

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

An entity-relationship (E-R)diagram includes _____ basic symbols.

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 ____.

What is a primary key?

An entity-relationship (E-R)diagram is a graphic method of representing entity classes and their relationships.

_____ are statements concerning the information you need to work with and the relationships within the information.

Within an entity-relationship diagram,O is used to denote a zero or ____.

Business rules help you define the correct structure of your database.

Your implementation of technology should match the way your business works.

An E-R diagram includes five basic symbols.Which one denotes an entity class?

A Social security number is an example of a primary key because it is unique.

In an E-R diagram,"|" denotes a single relationship.