DDD Design

Multiple Choice

Which of the following best describes an end-user requirement in the context of database design?

• A specific feature that the database must provide to meet user needs

• A technical specification for how data is stored

• A security protocol for database access

• A backup schedule for database maintenance

Open Ended

Why is it important to identify both end-user and functional requirements when designing a database?

Multiple Choice

Which of the following best describes an entity in a database?

• A specific example of a person or thing in a table

• A characteristic or property of a table

• A person, place, thing, event, or concept about which data is stored

• A unique identifier for a row in a table

Open Ended

Explain the difference between a primary key and a foreign key in the context of relational databases.

Multiple Choice

A compound key is formed by combining two or more attributes. In the example of a Class entity, which attributes are combined to form the compound key?

• studentID + subjectCode + teacherRef

• subjectCode + teacherRef + columnID

• teacherRef + columnID + studentID

• subjectCode + columnID + studentID

Multiple Select

Which of the following are valid attribute types in a database?

• text

• number

• date

• Boolean

Open Ended

Describe two types of validation that can be applied to data entry in a database and explain their importance.

Multiple Select

Which of the following are valid types of cardinality in relationships?

• one-to-one

• one-to-many

• many-to-many

• many-to-one

Multiple Choice

What does the cardinality of a relationship define in a database context?

• The number of participants in the relationship

• The type of entities involved

• The attributes of each entity

• The data type of the relationship

Multiple Choice

Which example best illustrates a one-to-one relationship?

• A School is managed by one Headteacher, and a Headteacher manages one School

• A School employs many Teachers

• Many Students study many Subjects

• A Teacher teaches many Subjects

Open Ended

Explain why direct many-to-many relationships cannot be implemented by a relational database system and how this issue can be resolved.

Multiple Choice

What is the main purpose of creating an entity-occurrence diagram?

• To identify the cardinality of the relationship between two entities

• To list all attributes of entities

• To show the data types of each entity

• To create a database schema

Multiple Choice

Which type of relationship is shown between the School and Headteacher entities in the entity-occurrence diagram?

• One-to-one

• One-to-many

• Many-to-many

• Many-to-one

Multiple Choice

Which of the following best describes the relationship between the School and Teacher entities as shown in the entity-occurrence diagram?

• One-to-one

• One-to-many

• Many-to-many

• Many-to-one

Multiple Select

Which of the following statements are true about the entity-occurrence diagram involving Student and Subject entities?

• Each student can be associated with multiple subjects.

• Each subject can be associated with multiple students.

• Each student can be associated with only one subject.

• Each subject can be associated with only one student.

Open Ended

Explain how the relationships between School, Headteacher, and Teacher entities are represented in entity-occurrence diagrams. What can you infer about the nature of these relationships?

Open Ended

What is a compound key and how is it used in the context of database entities? Provide an example based on the information given.

Multiple Select

Which of the following are indicated by an entity-relationship diagram?

• The name of each entity

• The name of the relationship between two entities

• The cardinality of the relationship

• The data types of each attribute

Multiple Choice

What is the purpose of an entity-relationship diagram (ERD) in a system?

• To summarize the relationships between entities

• To store data permanently

• To perform calculations

• To display user interfaces

Open Ended

Explain the use of crow’s feet notation in entity-relationship diagrams.

Multiple Choice

How are entities, attributes, and relationships represented in an entity-relationship diagram according to the slides?

• Entities: labelled rectangles, Attributes: labelled ovals, Relationships: labelled line

• Entities: labelled ovals, Attributes: labelled rectangles, Relationships: labelled line

• Entities: labelled lines, Attributes: labelled rectangles, Relationships: labelled ovals

• Entities: labelled rectangles, Attributes: labelled lines, Relationships: labelled ovals

Open Ended

Describe the relationships between Resort, Hotel, Booking, and Customer as shown in the ER diagram.

Multiple Choice

What is the purpose of an Entity Relationship Diagram in database design?

• To represent the logical structure of a database

• To write SQL queries

• To store data physically

• To create user interfaces

Open Ended

How confident do you feel about identifying end-user and functional requirements of a database problem after this lesson?

Multiple Choice

What are the two main types of requirements you should identify when designing a database for a problem?

• End-user and functional requirements

• Hardware and software requirements

• Security and privacy requirements

• Design and implementation requirements

Open Ended

Explain the importance of query design in the context of databases. How does it impact the efficiency and effectiveness of data retrieval?