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.
