Before you keep reading...

Runestone Academy can only continue if we get support from individuals like you. As a student you are well aware of the high cost of textbooks. Our mission is to provide great books to you for free, but we ask that you consider a $10 donation, more if you can or less if $10 is a burden.

Support Runestone Academy Today

Before you keep reading...

Making great stuff takes time and $$. If you appreciate the book you are reading now and want to keep quality materials free for other students please consider a donation to Runestone Academy. We ask that you consider a $10 donation, but if you can give more thats great, if $10 is too much for your budget we would be happy with whatever you can afford as a show of support.

Support Runestone Academy Today

2. DATA MODELING

Part 2 of this book concerns graphical modeling in general, and entity-relationship diagrams in particular. The diagram below shows the strong dependencies between chapters; chapters will assume knowledge introduced in earlier chapters as implied by the graph. The dotted outlines indicate chapters from other sections of the book.

Chapter dependency graph for Part 2

Table of contents for Part 2

• 2.1. Introduction to data modeling
• 2.2. Entity-relationship diagrams
  • 2.2.1. Basic model
    • 2.2.1.1. Entities
    • 2.2.1.2. Attributes
    • 2.2.1.3. Keys
    • 2.2.1.4. Relationships
    • 2.2.1.5. Cardinality ratios and participation
    • 2.2.1.6. Putting it together
  • 2.2.2. More complex modeling options
    • 2.2.2.1. Recursive relationships
    • 2.2.2.2. Weak entities
    • 2.2.2.3. Composite attributes
    • 2.2.2.4. Multivalued attributes
    • 2.2.2.5. Derived attributes
    • 2.2.2.6. Relationship attributes
    • 2.2.2.7. Higher-arity relationships
  • 2.2.3. Complete example
  • 2.2.4. Using ERD to design a database
    • 2.2.4.1. Analysis
    • 2.2.4.2. Design, implementation, and beyond
  • 2.2.5. Self-check exercises
• 2.3. Converting ERD to a relational model
  • 2.3.1. Entities
    • 2.3.1.1. Regular entities
    • 2.3.1.2. Weak entities
  • 2.3.2. Relationships
    • 2.3.2.1. Many-to-many
    • 2.3.2.2. One-to-many
    • 2.3.2.3. One-to-one
    • 2.3.2.4. Higher arity relationships
    • 2.3.2.5. Identifying relationships
  • 2.3.3. Multivalued attributes
  • 2.3.4. Full model conversion
  • 2.3.5. Self-check exercises
• 2.4. ERD alternatives and variations
  • 2.4.1. Crow’s foot notation
    • 2.4.1.1. Entity-relationship modeling
    • 2.4.1.2. Lower level models
  • 2.4.2. Common variations
    • 2.4.2.1. Cardinality ratios and participation
    • 2.4.2.2. Attributes

You have attempted of activities on this page