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.
What does mapping enable between database architecture levels?
Changes at one level without affecting the others.
What is a requirement?
A condition or capability needed to solve a problem or achieve an objective.
What does a data model represent for a database?
The data structures required by the database.
Which key is selected from candidate keys, and what two constraints apply to it?
A primary key; it must be unique and cannot contain null values.
What roles do database systems support in operations and decision-making?
Structured storage, retrieval, and management.
What three elements do data models typically include?
Entities, attributes, and relationships.
What uniquely identifies a tuple in a table, and how many candidate keys can a table have?
An attribute or set of attributes; a table can have multiple candidate keys.
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?
Go over the full study guide for ERD, Normalization and Modeling.
Read the study guide →Upload your class notes and Revizly writes your flashcards in about a minute.
Flashcard maker