ERD, Normalization and Modeling

From the study guide

Course Outline

  1. Database Systems and Their Environment
  2. Database Architecture and Independence
  3. Database Roles and Requirements
  4. Data Models and Relational Concepts
  5. Keys in Relational Databases
  6. ERD Entities and Attributes
  7. ERD Relationships and Cardinality
  8. Enhanced Entity-Relationship Modeling
  9. Mapping EER Models to Schemas
  10. Normalization and Data Anomalies
  11. UML and Use Case Diagrams
  12. UML Classes and Relationships
  13. Data Flow Diagrams
  14. SQL Fundamentals and Commands
  15. SQL Data Retrieval and Manipulation
  16. SQL Aggregation, Subqueries, and Joins
  17. Data Changes and Database Security
  18. Database Interfaces and Wireframes
  19. Database Testing
  20. Software Documentation
Read the full study guide →

Practice quiz preview

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?

Take the quiz (11 questions) →

Flashcard preview

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.

See all 10 flashcards →

Frequently asked questions

What does the ERD, Normalization and Modeling study guide cover?

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 →

How many questions are in the ERD, Normalization and Modeling quiz?

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) →

How do I study ERD, Normalization and Modeling with flashcards?

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 →

Related classes

Turn your own class notes into a study guide

Upload a PDF or paste your notes. Revizly writes a study guide, a practice quiz and flashcards in about a minute.