Database Design Quiz Week 2

Which notation uses rounded corners (soft boxes) for entities in ER diagrams?

• Crow’s Foot

• Chen’s Notation

• Barker’s Notation

• UML

What is a mandatory attribute marked with in ER diagrams?

• Lowercase "o"

• Asterisk (*)

• Hash (#)

• Exclamation mark (!)

Which of the following is an example of a non-relational database?

• MySQL

• MongoDB

• PostgreSQL

• Microsoft SQL Server

Resolving a many-to-many relationship typically involves:

• Deleting one entity

• Adding an associative entity

• Using abbreviations

• Ignoring the relationship

Which component of a relationship indicates whether it is required to exist?

• Degree

• Optionality

• Name

• Cardinality

What is the purpose of a Unique Identifier (UID)?

• To store redundant data

• To distinguish one instance from another

• To calculate derived values

• To name relationships

Which data category includes pre-computed summaries for faster queries?

• Fact Data

• Summary Data

• Reference Data

• Metadata

In ER diagrams, relationship lines should ideally:

• Be curved

• Be horizontal, vertical, or diagonal

• Cross frequently

• Use jagged edges

Which term refers to data about data?

• Redundancy

• Metadata

• Derived Data

• Fact Data

Storing an employee’s age in a database is an example of:

• Derived data

• Redundant data

• Mandatory data

• Domain data