SYSTEMS ANALYSIS AND DESIGN METHODS Whitten Bentley Dittman

Chapter 14 – Database Design

This repository of slides is intended to support the named chapter. The slide repository should be used as
follows:
•Copy the file to a unique name for your course and unit.
•Edit the file by deleting those slides you don’t want to cover, editing other slides as appropriate to your
course, and adding slides as desired.
•Print the slides to produce transparency masters or print directly to film or present the slides using a
computer image projector.

Each slide includes instructor notes. To view those notes in PowerPoint, click-left on the View Menu; then
click left on Notes View sub-menu. You may need to scroll down to see the instructor notes.
The instructor notes are also available in hardcopy as the Instructor Guide to Accompany Systems Analysis
and Design Methods, 6/ed.

Irwin/McGraw-Hill
SYSTEMS ANALYSIS AND DESIGN METHODS Whitten Bentley Dittman

Chapter 14 – Database Design

No additional notes

Irwin/McGraw-Hill
SYSTEMS ANALYSIS AND DESIGN METHODS Whitten Bentley Dittman

Chapter 14 – Database Design

Teaching Notes
•The point about data built around applications or vice-versa is illustrated on the next slide.

Irwin/McGraw-Hill
SYSTEMS ANALYSIS AND DESIGN METHODS Whitten Bentley Dittman

Chapter 14 – Database Design

No additional notes

Irwin/McGraw-Hill
SYSTEMS ANALYSIS AND DESIGN METHODS Whitten Bentley Dittman

Chapter 14 – Database Design

No additional notes

Irwin/McGraw-Hill
SYSTEMS ANALYSIS AND DESIGN METHODS Whitten Bentley Dittman

Chapter 14 – Database Design

No additional notes

Irwin/McGraw-Hill
SYSTEMS ANALYSIS AND DESIGN METHODS Whitten Bentley Dittman

Chapter 14 – Database Design

No additional notes.

Irwin/McGraw-Hill
SYSTEMS ANALYSIS AND DESIGN METHODS Whitten Bentley Dittman

Chapter 14 – Database Design

No additional notes

Irwin/McGraw-Hill
SYSTEMS ANALYSIS AND DESIGN METHODS Whitten Bentley Dittman

Chapter 14 – Database Design

No additional notes

Irwin/McGraw-Hill
SYSTEMS ANALYSIS AND DESIGN METHODS Whitten Bentley Dittman

Chapter 14 – Database Design

No additional notes.

Irwin/McGraw-Hill
SYSTEMS ANALYSIS AND DESIGN METHODS Whitten Bentley Dittman

Chapter 14 – Database Design

No additional notes

Irwin/McGraw-Hill
SYSTEMS ANALYSIS AND DESIGN METHODS Whitten Bentley Dittman

Chapter 14 – Database Design

Teaching Notes
It is useful to walk through this diagram.

Irwin/McGraw-Hill
SYSTEMS ANALYSIS AND DESIGN METHODS Whitten Bentley Dittman

Chapter 14 – Database Design

No additional notes

Irwin/McGraw-Hill
SYSTEMS ANALYSIS AND DESIGN METHODS Whitten Bentley Dittman

Chapter 14 – Database Design

No additional notes

Irwin/McGraw-Hill
SYSTEMS ANALYSIS AND DESIGN METHODS Whitten Bentley Dittman

Chapter 14 – Database Design

Teaching Notes
•Point out everything above the DBMS block is traditionally called front-end while the DMBS and data are
called back-end.
•Explain that metadata is “data about data” that describes the structure of the user data.

Irwin/McGraw-Hill
SYSTEMS ANALYSIS AND DESIGN METHODS Whitten Bentley Dittman

Chapter 14 – Database Design

No additional notes

Irwin/McGraw-Hill
SYSTEMS ANALYSIS AND DESIGN METHODS Whitten Bentley Dittman

Chapter 14 – Database Design

No additional notes

Irwin/McGraw-Hill
SYSTEMS ANALYSIS AND DESIGN METHODS Whitten Bentley Dittman

Chapter 14 – Database Design

Teaching Notes
•This is the physical relational database schema for the previous slide.

Irwin/McGraw-Hill
SYSTEMS ANALYSIS AND DESIGN METHODS Whitten Bentley Dittman

Chapter 14 – Database Design

No additional notes.

Irwin/McGraw-Hill
SYSTEMS ANALYSIS AND DESIGN METHODS Whitten Bentley Dittman

Chapter 14 – Database Design

No additional notes

Irwin/McGraw-Hill
SYSTEMS ANALYSIS AND DESIGN METHODS Whitten Bentley Dittman

Chapter 14 – Database Design

Teaching Notes
•This is a review from Chapter 8.
•Logical entity = Physical table.

Irwin/McGraw-Hill
SYSTEMS ANALYSIS AND DESIGN METHODS Whitten Bentley Dittman

Chapter 14 – Database Design

No additional notes

Irwin/McGraw-Hill
SYSTEMS ANALYSIS AND DESIGN METHODS Whitten Bentley Dittman

Chapter 14 – Database Design

No additional notes.

Irwin/McGraw-Hill
SYSTEMS ANALYSIS AND DESIGN METHODS Whitten Bentley Dittman

Chapter 14 – Database Design

No additional notes

Irwin/McGraw-Hill
SYSTEMS ANALYSIS AND DESIGN METHODS Whitten Bentley Dittman

Chapter 14 – Database Design

Teaching Notes
•Referential integrity is discussed on the next slide.

Irwin/McGraw-Hill
SYSTEMS ANALYSIS AND DESIGN METHODS Whitten Bentley Dittman

Chapter 14 – Database Design

Teaching Notes
•Comparing the data types of different databases underscores database-specific data types vs. conceptual
data types and broadens students’ understanding of databases
•If your school uses another database, add a fourth column

Irwin/McGraw-Hill
SYSTEMS ANALYSIS AND DESIGN METHODS Whitten Bentley Dittman

Chapter 14 – Database Design

Teaching Notes
•Comparing the data types of different databases underscores database-specific data types vs. conceptual
data types and broadens students’ understanding of databases
•If your school uses another database, add a fourth column

Irwin/McGraw-Hill
SYSTEMS ANALYSIS AND DESIGN METHODS Whitten Bentley Dittman

Chapter 14 – Database Design

No additional notes

Irwin/McGraw-Hill
SYSTEMS ANALYSIS AND DESIGN METHODS Whitten Bentley Dittman

Chapter 14 – Database Design

No additional notes

Irwin/McGraw-Hill
SYSTEMS ANALYSIS AND DESIGN METHODS Whitten Bentley Dittman

Chapter 14 – Database Design

No additional notes

Irwin/McGraw-Hill
SYSTEMS ANALYSIS AND DESIGN METHODS Whitten Bentley Dittman

Chapter 14 – Database Design

No additional notes

Irwin/McGraw-Hill
SYSTEMS ANALYSIS AND DESIGN METHODS Whitten Bentley Dittman

Chapter 14 – Database Design

No additional notes.

Irwin/McGraw-Hill
SYSTEMS ANALYSIS AND DESIGN METHODS Whitten Bentley Dittman

Chapter 14 – Database Design

Teaching Notes
•DDL can often be created by a CASE tool given a physical data model.
•DDL can also be hand-written.

Irwin/McGraw-Hill