Database Systems, unit: Database Design and ER Diagrams. Core concepts, terminology, and worked-example cues a college student meets for this unit, building on prior units without repeating them. Front: a term, concept, or short problem cue. Back: the definition, explanation, or answer.
38 cards · basic cards · AI-written, checked twice. Edit anything.
- What is database design?
Show answer
The process of structuring a database to efficiently store and organize data- What is an ER (Entity-Relationship) diagram?
Show answer
A visual model showing entities, their attributes, and relationships- What is an entity, in ER modeling?
Show answer
A distinct object or concept represented by a table, such as a customer or product- What is an attribute, in ER modeling?
Show answer
A property or characteristic of an entity- What is a relationship, in ER modeling?
Show answer
An association between two or more entities- What is cardinality, in ER modeling?
Show answer
The numerical relationship between rows of two related entities, such as one-to-many- What is a weak entity?
Show answer
An entity that cannot be uniquely identified without the primary key of another entity- What is an identifying relationship?
Show answer
A relationship linking a weak entity to its owning strong entity- What is a strong entity?
Show answer
An entity that has its own unique primary key and does not depend on another entity- What is a derived attribute?
Show answer
An attribute whose value can be calculated from other attributes, such as age from birth date- What is a multivalued attribute?
Show answer
An attribute that can hold more than one value for a single entity- What is the process of converting an ER diagram into relational tables called?
Show answer
Mapping (or translating the ER model to a relational schema)- How is a one-to-many relationship typically implemented in tables?
Show answer
By placing a foreign key on the 'many' side referencing the 'one' side- How is a many-to-many relationship typically implemented in tables?
Show answer
By creating a junction table with foreign keys to both related tables- What is conceptual database design?
Show answer
Designing a high-level, technology-independent model of the data requirements
FlashKeepers