Skip to main content
O'Reilly home
    • Sign In
    • Try Now
    • Teams
      • For business
      • For government
      • For higher ed
    • Individuals
    • Features
      • Certifications
      • Interactive learning
      • Live events
      • Answers
    • Blog
    • Content sponsorship

Database Design: Know It All by Toby J. Teorey, Stephen Buxton, Lowell Fryman, Ralf Hartmut Güting, Terry Halpin, Jan L. Harrington, William H. Inmon, Sam S. Lightstone, Jim Melton, Tony Morgan, Thomas P. Nadeau, Bonnie O'Neil, Elizabeth O'Neil, Patrick O'Neil, Markus Schneider, Graeme Simsion, Graham Witt

Get full access to Database Design: Know It All and 60K+ other titles, with free 10-day trial of O'Reilly.

There's also live online events, interactive content, certification prep materials, and more.

Start your free trial

List of Figures

Figure 1.1. The database life cycle.

Figure 1.2. Life cycle results, step-by-step.

Figure 1.3. A simple form of ER model using the Chen notation.

FIGURE 2.1. SQL declaration of customers table with primary key cid and candidate key ssn.

FIGURE 2.2. Example of ER diagrams with entities and attributes.

FIGURE 2.3. Examples of ER diagrams with relationships.

FIGURE 2.4. A table representing an entity, Employees, and a ring (recursive relationship), manages.

FIGURE 2.5. Basic ER concepts: (a) entities and attributes, and (b) relationships.

FIGURE 2.6. Examples of relationships R between two entities E and F.

FIGURE 2.7. An ER diagram with labels (x, y) on ER connections.

FIGURE 2.8. Relational design for Employees works_on Projects ...

Get Database Design: Know It All now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.

Start your free trial

About O’Reilly

  • Teach/write/train
  • Careers
  • Community partners
  • Affiliate program
  • Submit an RFP
  • Diversity
  • O’Reilly for marketers

Support

  • Contact us
  • Newsletters
  • Privacy policy
facebook-logo linkedin-logo youtube-logo

Download the O’Reilly App

Take O’Reilly with you and learn anywhere, anytime on your phone and tablet.

Apple app store Google play store

Watch on your big screen

View all O’Reilly videos, Superstream events, and Meet the Expert sessions on your home TV.

Roku Payers and TVs Amazon appstore

Do not sell my personal information

O'Reilly home

© 2022, O’Reilly Media, Inc. All trademarks and registered trademarks appearing on oreilly.com are the property of their respective owners.

Terms of service • Privacy policy • Editorial independence

Don’t leave empty-handed

Get Mark Richards’s Software Architecture Patterns ebook to better understand how to design components—and how they should interact.

It’s yours, free.

Get it now
Cover of Software Architecture Patterns