ERD, Normalization and Modeling Flashcards (10 cards)

All cards

1Question

How does information differ from raw data?

Answer

It is data interpreted and assembled meaningfully.

2Question

Which three levels make up database architecture?

Answer

External, conceptual, and internal.

3Question

What are data before they are organized?

Answer

Raw, unprocessed facts.

4Question

What does mapping enable between database architecture levels?

Answer

Changes at one level without affecting the others.

5Question

What is a requirement?

Answer

A condition or capability needed to solve a problem or achieve an objective.

6Question

What does a data model represent for a database?

Answer

The data structures required by the database.

7Question

Which key is selected from candidate keys, and what two constraints apply to it?

Answer

A primary key; it must be unique and cannot contain null values.

8Question

What roles do database systems support in operations and decision-making?

Answer

Structured storage, retrieval, and management.

9Question

What three elements do data models typically include?

Answer

Entities, attributes, and relationships.

10Question

What uniquely identifies a tuple in a table, and how many candidate keys can a table have?

Answer

An attribute or set of attributes; a table can have multiple candidate keys.

Test yourself with the quiz

Answer 11 questions on ERD, Normalization and Modeling.

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

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?

Take the quiz →

Read the study guide

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

Read the study guide →

Related classes

Make your own flashcards

Upload your class notes and Revizly writes your flashcards in about a minute.

Flashcard maker