Database Design Process Quiz

What are the functional requirements in database design?

• User-defined operations.

• Data storage methods.

• Database security measures.

What is a conceptual schema?

• A concise description of data requirements.

• A detailed implementation plan.

• A method for data storage.

What does logical design refer to in database design?

• The actual implementation of the database.

• The conceptual schema.

• The requirements analysis.

What are weak entity types?

• Entity types without key attributes.

• Entities that are always strong.

• Entities that have multiple attributes.

What is an identifying relationship?

• The relationship between weak and strong entity types.

• A relationship that does not involve entities.

• A relationship that is always one-to-one.

What is a key attribute?

• An attribute that helps identify an entity uniquely.

• An attribute that can have multiple values.

• An attribute that is derived from another.

What is a multivalued attribute?

• An attribute that contains a set of values.

• An attribute that can be divided into further attributes.

• An attribute that is derived from another.

What is a composite attribute?

• An attribute that can be divided into further attributes.

• An attribute that contains multiple values.

• An attribute that is derived from another.

What is a derived attribute?

• An attribute whose value is derived from another.

• An attribute that is always unique.

• An attribute that cannot be divided.

What is a primary key?

• An attribute that uniquely identifies a record in a table.

• An attribute that can be null.

• An attribute that is used for indexing.