Questions 1

False

An entity is represented by a column in the Entity-Relationship Model.

Data is in second normal form (2NF) if it contains no repeating groups and has a primary key to uniquely identify each record.

False

False

If a primary key has been identified for the data, then the data is considered to be in first normal form (1NF).

many-to-many

If a recipe contains several ingredients, and those ingredients can also be used in other recipes, this would be an example of what type of relationship?

third normal

If the data has no partial dependencies, repeating groups, or transitive dependencies, and has a composite primary key, the data is in which form?

systems analysis

In which step of the Systems Development Life Cycle (SDLC) is the solution to the identified problem determined and understood?

one-to-many

Suppose that a patient in a hospital can only be assigned to one room. However, the room may be assigned to more than one patient at a time. This is an example of what type of relationship?

True

The simplest approach to remove a partial dependency is to use each portion of the primary key to create separate tables.

A many-to-many relationship cannot exist in a relational database.

True

Data mining refers to analyzing historical data stored in a database.

True

bridging table

What is added to a relational database to eliminate many-to-many relationships?

foreign key

What name is used to denote a common field that exists between two tables, but is also the primary key for one of the tables?

field

What represents a characteristic or attribute that is being collected about an entity?

a person's hair color

Which of the following is an example of an attribute?

normalization process

Which of the following is used to determine the correct organization for data that is to be stored in a database?

first normal form (1NF)

Which of the following may contain partial dependencies, but cannot contain repeating groups?

field

Which of the following terms best describes where a group of characters that represents a customer's address would be stored in the logical design?

character

Which of the following terms is considered the basic unit of data in a database?

foreign key

Which of the following usually correlates to a primary key in another table?

column

A field in the logical design of a database corresponds to a ____ in the physical database.

row

A record in the logical design of a database is represented by what in the physical database?

one-to-one

A solid straight line in an E-R Model depicts a(n) ____________________ relationship.

character

A(n) ____________________ is a basic unit of data that can consist of a letter, number, or special symbol.

record

A(n) ____________________ is a group of related fields.

database

A(n) ____________________ is a storage structure that contains data.