ERD, Normalization and Modeling Practice Quiz (11 questions)

All questions and answers

1. A retailer records customer names and purchase amounts, then aggregates and analyzes them to identify buying trends. What do the resulting trends represent?

Information
A DBMS
A database
Data

Information

Explanation

Information is data that has been interpreted and assembled meaningfully, such as analyzed records revealing purchasing trends. Raw customer names and amounts are data; a database stores structured data, and a DBMS manages access to it.

2. Two departments maintain separate files containing the same supplier details. One updates a supplier’s address while the other does not, and users encounter conflicts when editing shared records. Which file-system problem does this situation illustrate?

Database interfacing, accessibility, and integrity maintenance
Structured storage, efficient retrieval, and controlled manipulation
Meaningful information, accurate interpretation, and user-specific views
Redundancy, inconsistency, and simultaneous-access conflicts

Redundancy, inconsistency, and simultaneous-access conflicts

Explanation

Independent files can duplicate data, become inconsistent when updates are not synchronized, and produce locking or conflicts during simultaneous access. Structured database storage, interpreted information, and DBMS functions are different concepts.

3. Which sequence names the three levels of database architecture from user-facing views toward physical storage?

External, logical, physical
Internal, external, conceptual
External, conceptual, internal
Conceptual, mapping, internal

External, conceptual, internal

Explanation

The three architecture levels are external, conceptual, and internal. The external level provides user-specific views, while the internal level concerns physical storage; mapping and independence are not architecture levels.

4. A database team changes how records are stored on disk but leaves the conceptual schema unchanged. Which kind of data independence permits this change?

Logical data independence
Physical data independence
External-view independence
Architecture mapping

Physical data independence

Explanation

Physical data independence allows storage methods and structures to change without affecting the conceptual schema. Logical data independence instead permits conceptual-schema changes without changing external schemas or application programs.

5. What is a user requirement in a database system?

A statement of what end users need the system to do and the tasks or features it should support
A rule that assigns priority according to immediate business value and urgency
A technical specification defining database structures, interfaces, and security controls
A description of the system's operational qualities, such as performance, reliability, and usability

A statement of what end users need the system to do and the tasks or features it should support

Explanation

A user requirement describes users’ needs, including the tasks a system must support and the features it should provide. Operational qualities such as performance and reliability are examples of non-functional requirements, not the definition of a user requirement.

6. Who proposed the relational data model, and in what year?

Edgar Frank in 1981
Michael Stonebraker in 1986
Peter Chen in 1976
E. F. Codd in 1970

E. F. Codd in 1970

Explanation

E. F. Codd proposed the relational data model in 1970. Peter Chen is associated with the development of entity-relationship modeling, not the relational model.

7. What is the role of a foreign key in a relational database?

It groups attributes into a minimal set that uniquely identifies tuples.
It uniquely identifies each tuple within its own table.
It links tables by referring to another table’s primary key.
It provides an alternative candidate key when another key is selected as primary.

It links tables by referring to another table’s primary key.

Explanation

A foreign key connects data between tables by referencing the primary key of another table. A primary key identifies tuples within its own table, so it does not serve as the cross-table reference.

8. In an ERD, which attribute type can be broken into smaller attributes such as Street, City, and Postal Code?

A multivalued attribute
A composite attribute
A key attribute
A derived attribute

A composite attribute

Explanation

A composite attribute consists of smaller component attributes, as an Address can be divided into Street, City, and Postal Code. A derived attribute is calculated from other data, such as Age from DateOfBirth, rather than being subdivided.

9. How does a ternary relationship differ from a binary relationship in an ERD?

It involves one entity relating to itself rather than two.
It allows multiple instances on both sides rather than one-to-one links.
It represents a whole-part association with an independent part.
It involves three participating entities rather than two.

It involves three participating entities rather than two.

Explanation

Relationship degree counts the entities participating: a ternary relationship has three, while a binary relationship has two. A relationship involving one entity relating to itself is unary, not binary.

10. A hospital database combines the shared attributes of Indoor Patient and Outdoor Patient into a Patient supertype. What is the main modeling effect of this process?

It captures common characteristics in a broader supertype
It allows an instance to belong to overlapping subtypes
It divides a broad entity into more specialized subtypes
It links unrelated entities through an associative table

It captures common characteristics in a broader supertype

Explanation

This is generalization: shared characteristics from specialized entity types are grouped into a supertype. Specialization is the plausible alternative, but it proceeds top-down by dividing a supertype into more specialized subtypes.

11. A design has a small number of overlapping subtypes, and the team wants to map them into a relational schema. Which strategy is suggested for representing their attributes?

Use one table containing columns for all subtypes
Store subtype attributes in an associative table
Create a separate table for every subtype
Move subtype attributes into the supertype's related tables

Use one table containing columns for all subtypes

Explanation

A single table with columns for all subtypes is suggested when there are few subtypes and overlap exists. Separate subtype tables are more suitable when specializations are radically different and have many unique attributes.

Study with flashcards

Lock in the answers with 10 flashcards on ERD, Normalization and Modeling.

How does information differ from raw data?

It is data interpreted and assembled meaningfully.

Which three levels make up database architecture?

External, conceptual, and internal.

What are data before they are organized?

Raw, unprocessed facts.

See the flashcards →

Read the study guide

Go over the full study guide for ERD, Normalization and Modeling.

Read the study guide →

Related classes

Make your own practice quizzes

Upload your class notes and Revizly writes a practice quiz with explained answers in about a minute.

Quiz maker