Database Design Quiz Week 3

What is a composite UID primarily composed of?

• Optional attributes

• Attributes and/or relationships

• Derived data

• Metadata

Referential integrity ensures:

• Data redundancy

• Parent-child dependency enforcement

• Attribute optionality

• Metadata accuracy

In Barker’s Notation, how is a composite UID involving relationships indicated?

• Crow’s foot symbol

• Bar across the relationship line

• Dotted relationship line

• Lowercase attribute names

Metadata is best described as:

• Raw facts

• Data about data structure and meaning

• Derived totals

• Redundant information

Where would pre-computed totals (e.g., monthly sales) typically be stored?

• Fact data

• Summary data

• Reference data

• Operational data

Normalization is performed during which phase of database design?

• Requirements Gathering

• Logical Design

• Physical Design

• Implementation

A weak entity always depends on:

• A composite UID

• A parent entity

• Derived attributes

• Redundant data

Domains in database design refer to:

• Physical storage locations

• Predefined allowable values (e.g., Y/N)

• Relationship optionality

• Metadata formats

A NoSQL database is optimized for:

• Tabular schemas

• Unstructured/semi-structured data

• Centralized data only

• Historical data aggregation

Resolving a many-to-many relationship between STUDENT and COURSE requires:

• Deleting one entity

• Adding an intersection entity (e.g., ENROLLMENT)

• Using a dotted relationship line

• Ignoring optionality