Chapter 13

Database Design Case Study #1: Mighty-Mite Motors

Abstract

This chapter presents the first of three major case studies in the book. The emphasis is on reengineering an existing database system, and includes a discussion of the ways in which an organization may need to change along with the introduction of more up-to-date technology.

Keywords

database reengineering
database case study
database design
data flows
ER diagrams
SQL CREATE
It is not unusual for a database designer to be employed to reengineer the information systems of an established corporation. As you will see from the company described in this chapter, information systems in older companies have often grown haphazardly, with almost no planning and integration. The result ...

Get Relational Database Design and Implementation, 4th Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.