Introduction to Database Design

Database schema defines database’s structure, tables, relationships, domains, and constraint rules

• Tables

  • BOOK (ISBN, Title, AuthID, PubID, Price)
  • PUBLISHER (PubID, PubName, PubPhone)
  • AUTHOR (AuthID, AuthName, AuthPhone)

• Relationships

  • Each book is published by one and only one publisher
  • Each publisher publishes one or more books

• Domains (set of values in a column)

  • Physical description (e.g., set of integers 0 < x < 99999)

• Constraints (business rules)

  • Price cannot be less than zero; Author phone field cannot be left blank

Previous slide

Next slide

Back to first slide

View graphic version