SlideServe
Télécharger Obtenir Pro
Menu
Accueil Pro
Préférences
ApparenceLight Aide et commentaires
© SlideServe · v2026

Comprehensive Database Design Process: ER Model Principles & Key Constraints

donkor avatar
donkor
9 diapositives · 210 Views · Sep 13, 2014

This chapter delves into the fundamentals of database design, covering data requirements analysis, conceptual and logical design, schema refinement, physical design, application integration, and security considerations. It explores key concepts like entities, relationships, attribute types, candidate keys, constraints, weak entity sets, ISA relationships, and aggregations in an Entity-Relationship (ER) model framework. Learn how to structure and optimize databases efficiently for better performance and functionality.

Comprehensive Database Design Process: ER Model Principles & Key Constraints - slide 1
01 / 9Comprehensive Database Design Process: ER Model Principles & Key Constraints
1 / 17

Télécharger la présentation

Comprehensive Database Design Process: ER Model Principles & Key Constraints
Une image / un lien ci-dessous est fourni (tel quel) pour télécharger la présentation

Politique de téléchargement : le contenu du site vous est fourni TEL QUEL pour votre information et votre usage personnel ; il ne peut être vendu, concédé sous licence ni partagé sur d’autres sites sans l’accord de son auteur.Le contenu vous est fourni TEL QUEL, pour votre information et votre usage personnel uniquement. Téléchargez la présentation en cliquant sur ce lien. Lors du téléchargement, si vous ne parvenez pas à télécharger une présentation, l’éditeur a peut-être supprimé le fichier de son serveur.Pendant le téléchargement, si vous ne parvenez pas à obtenir une présentation, le fichier a peut-être été supprimé par l’éditeur.

F I N

Plus de contenu associé

Transcription de la présentation

  1. The Entity-Relationship Model Chapter 2

  2. Database Design Basics: Six Steps in Design • Data Requirements Analysis: a) what must be stored, b) how will it be used, and c) what actions occur most often. • Conceptual Database Design: Use ERD(s) to group data into entities and relationships. • Logical Database Design: Convert ERD(s) to conceptual schemas. • Schema Refinement: Eliminate redundancy and refine tables for performance. • Physical Database Design: Decide how to store and index the data. • Application and Security Design: Put the DB in the application’s context.

  3. Employees ssn ER Model Basics Attribute (descriptive attribute), entities (relationships) possess these. Entity. A group of these is an entity set. Relationship ( if “ISA”). A group would be a relationship set. ISA Works_In

  4. ER Model Basics (Example) name office phone ssn class name declares Major Students How do we choose a key? Candidate keys and primary keys

  5. ER Model Basics (Example) name office phone ssn class name declares Major Students Two types of constraints to consider: key constraints and participation constratints. Key constraints can be one-to-many or many-to-many Participation constraints can be total or partial

  6. ER Model Basics (Example) name office phone ssn class name declares Major Students Total participation (all) Key constraint (only one) Total participation and key constraint (all and only one)

  7. ER Model: Other Concepts:Weak Entity Sets name did ssn rank name sponsors dependent member The link is “bolded” to show total participation. It must also have an arrowhead to show a key constraint. These symbols must be “bolded” to denote the weak entity set

  8. ER Model: Other Concepts:ISA Relationships name id gender Two constraints of concern with ISA relationships: employee * Overlap (no by default) isa * Covering (no by default) faculty staff student salary contract wage date ins date wage

  9. ER Model: Other Concepts:Aggregation addr order phone name name hires agent customer Could also use a ternary relationship Prod # price name quantity buys product