DatabasesLesson 2 of 4 in the course Database design and normalization

ER Modeling: Core Concepts, Design Levels, Notation, and Limitations

5 flashcards · 5 quiz questions · 5 match pairs · 5 fill-in sentences · English

Save course
Lesson progress
0 / 5

Your progress is kept in this browser only.Sign up to save it

Summary

An entity–relationship (ER) model describes things of interest in a domain and the relationships among them. It provides a structured way to understand information before designing a database.

An ER model is an abstract description of interrelated things in a particular area of knowledge. Its basic elements are entity types, which classify things of interest, and relationships, which describe associations that may exist between instances of those types.

All flashcards

What is an ER model?
An abstract representation of things of interest in a domain, their types, and the relationships that can exist among them.
What is an entity type?
A category used to classify things of interest, such as Student or Course.
What information does an ER model capture for a business?
It describes the information the business needs to remember or that its processes create and use.
Who published a foundational ER modeling paper, and when?
Peter Chen published a foundational paper on ER modeling in 1976.
How can ER models support ontology work?
They can organize concepts in a domain and specify relationships among those concepts.

Quiz questions

  1. In Chen notation, which set of symbols represents entity sets, relationship sets, and attributes, respectively?Answer: Rectangles, diamonds, and ovals.
  2. Which statement distinguishes a logical data model from a physical data model?Answer: A logical model is DBMS-independent; a physical model is technology-specific.
  3. In Crow’s foot notation, what does a ring paired with a crow’s foot indicate?Answer: Zero to many participation.
  4. What can happen when a query joins two one-to-many branches from the same master entity?Answer: Rows may multiply, causing aggregate values to be counted more than once.
  5. What distinguishes a semantic model from an extensional model?Answer: A semantic model expresses platform-independent meaning; an extensional model is technology-specific.

Based on the Wikipedia article Entity–relationship model, licensed CC BY-SA 4.0. Adapted into a summary, flashcards and quizzes.

More in Databases

All Databases lessons
DatabasesSQL Foundations: Language Model, History, Types, and Semantics5 flashcards · 5 quiz questions · 4 gamesPlay free →DatabasesDatabase Query Optimization: Plans, Costs, and Estimation5 flashcards · 5 quiz questions · 4 gamesPlay free →DatabasesDatabase Index Structures, Query Patterns, and Trade-Offs5 flashcards · 5 quiz questions · 4 gamesPlay free →DatabasesDatabase Transaction Isolation: Anomalies, Levels, and Concurrency Control5 flashcards · 5 quiz questions · 4 gamesPlay free →DatabasesSQL Joins: Matching, Row Preservation, and Execution5 flashcards · 5 quiz questions · 4 gamesPlay free →DatabasesForeign Keys, Referential Integrity, and Referential Actions5 flashcards · 5 quiz questions · 4 gamesPlay free →