MIS- Chapter App. C

Which of the following is a type of attribute?

All of these are correct

A field is composed of rows and columns that represent an entity.

False

A one-to-many relationship occurs between two entities in which an instance of one entity can be related to only one instance of a related entity.

False

A primary key is a field that uniquely identifies a given record in a table.

True

Date of birth would be a stored attribute.

True

What is a foreign key?

a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables

Which of the following is a possible business rule?

all of these are correct

Which of the following statements is accurate?

all of these are correct

What is a statement that defines an aspect of a business?

business rule

What expresses the specific number of instances in an entity?

cardinality

What exists to represent the relationship between two other entities?

composite entry

If date of birth is an attribute, age would be a _______ attribute.

derived

What kind of attribute can be calculated using the value of another attribute?

derived attribute

What is a technique for documenting the entities and relationships in a database environment?

entity-relationship diagram

What is a characteristic of a table?

field

What is a primary key?

field that uniquely identifies a given record in a table

What occurs when two entities can be related to each other in many instances?

many-to-many relationship

What has the potential to contain more than one value for an attribute?

multivalued attribute

What kind of attribute is assigned to an attribute when no other value applies or when a value is unknown?

null-valued attribute

What kind of attribute would be given for a person who does not have an email address?

null-valued attribute

What occurs between two entities in which an instance of one entity can be related to many instances of a related entity?

one-to-many relationship

What occurs between two entities in which an instance of one entity can be related to only one instance of a related entity?

one-to-one relationship

What is a collection of related data elements?

record

What has only a single value of each attribute of an entity?

single-value attribute

What kind of attribute would be date of birth?

stored attribute

What is composed of rows and columns that represent an entity?

table

A foreign key is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.

true