Database Design Concepts Quiz

Which of the following best describes an Entity-Relationship Diagram (ERD)?

• A flowchart that outlines the steps in a business process.

• A diagram that shows the relationships between entities in a database.

• A type of data flow diagram that represents the data flow within an organization.

• A chart used to display the organization of a company's hierarchy.

What is a one-to-one relationship in the context of database design?

• A relationship where one entity instance is associated with multiple instances of another entity.

• A relationship where one entity instance is associated with exactly one instance of another entity.

• A relationship where multiple entity instances are associated with multiple instances of another entity.

• A relationship where many instances of one entity are associated with many instances of another entity.

Which of the following is true about many-to-many relationships?

• They cannot be represented in an ERD.

• They require a junction table to be implemented in a relational database.

• They are the same as one-to-many relationships.

• They can be directly transformed into relational tables without any modifications.

How is a supertype/subtype relationship depicted in an ERD?

• Using a dashed line between entities.

• A diamond shape connected to multiple entities.

• With a triangle symbol pointing from the supertype to the subtypes.

• By a rectangle that contains all possible subtypes within it.

In transforming an ERD to relational tables, how is a one-to-many relationship handled?

When transforming an ERD that includes a supertype/subtype relationship into relational tables, what is a common approach?

• Create separate tables for the supertype and each subtype, with the subtype tables referencing the supertype table.

• Merge all attributes into a single table, discarding the distinctions between supertype and subtypes.

• Use a single table for the supertype and include a column for each possible subtype.

• Create a single table that includes all attributes and an additional type field to differentiate subtypes.

Which of the following statements is true regarding the transformation of ERD into relational tables?

• All relationships in an ERD are transformed into foreign keys in relational tables.

• Only many-to-many relationships require the creation of additional tables.

• Supertype/subtype relationships always result in a single table in the relational schema.

• ERDs do not need to be transformed when using object-oriented databases.

What is the primary benefit of using an ERD in database design?

• It ensures data normalization and eliminates redundancy.

• It provides a visual representation of the database structure, which aids in understanding and communication.

• It allows for the direct creation of relational tables without further modifications.

• It simplifies the database design process by avoiding the need for foreign keys.

What is an Entity-Relationship Diagram (ERD)?

• A blueprint for building a database.

• A diagram that outlines user workflows.

• A graphical representation of entities and their relationships.

• A flowchart showing data processing steps.

Which components are essential in an ERD?

• Entities, attributes, and relationships.

• Tables, records, and fields.

• Users, processes, and data flows.

• Applications, servers, and networks.