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?
3. Which sequence names the three levels of database architecture from user-facing views toward physical storage?
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.
It covers the core concepts of ERD, Normalization and Modeling, organized by topic with the key definitions, explanations and takeaways, so it's easier to learn and remember.
Read the full study guide →The practice quiz has 11 multiple-choice questions, each with an explanation. Use it to check what you know and find your gaps.
Take the quiz (11 questions) →There are 10 flashcards on ERD, Normalization and Modeling, with a question on the front and the answer on the back. Try to recall each answer before you flip, and let spaced repetition bring back the ones you miss.
See all 10 flashcards →Upload a PDF or paste your notes. Revizly writes a study guide, a practice quiz and flashcards in about a minute.