Database Systems Planning, Design and Administration

What is data redundancy?

What is the cardinality of a one-to-many relationship?

What is a key attribute in an entity?

• An attribute that is a combination of other attributes

• An attribute that uniquely identifies an entity

• An attribute that can hold multiple values

• An attribute that is derived from another attribute

In a car dealership, who writes an invoice for each car sold?

• The manufacturer

• The service facility

• The salesperson

• The customer

What is the degree of a relationship set with three entity sets participating?

• Ternary

• n-ary

• Binary

• Unary

What is a derived attribute in an entity?

• An attribute that uniquely identifies an entity

• An attribute that can hold multiple values

• An attribute that is a combination of other attributes

• An attribute that is derived from another attribute

What is the existence of a relationship between a customer and a car in a car dealership?

• Optional

• Mandatory

• Dependent

• Independent

What is a weak entity type in an ER diagram?

• An entity type with multivalued attributes

• An entity type with composite attributes

• An entity type without a key attribute

• An entity type with a key attribute

What is the cardinality of a many-to-many relationship?

• One entity is associated with only one entity

• Many entities are associated with one entity

• Many entities are associated with many entities

• One entity is associated with many entities

What is the purpose of a service ticket in a car dealership?

• To track car repair or service

• To track customer information

• To write an invoice for a car

• To record salesperson details