Chapter 6. Creating the Database Schema and Populating Data

I l @ ve RuBoard

IN THIS CHAPTER

• The Fading Role of the DBA

• Building a Database Schema

• The Database from 20,000 Feet

At this point, you should have a good idea of how an application will be represented in Java objects ”you're halfway there. But Java objects by themselves have no permanence, so you'll need to back up some of them with database records to hold their data for long- term retrieval.

In this chapter, you'll learn how to design and populate a database schema that can interact with JSP. As you'll see, sometimes a single Java object maps to a single table, and sometimes it maps to several. In addition, you'll see how MySQL handles sequences and you'll learn the special requirements that this imposes on design.

I l @ ve RuBoard