Logical Database Design

There are two phases of database design: logical and physical. Just as top-down design is important for standard programming practice, it's also important to start with a logical database design before moving on to the physical design. Throughout logical database design, an engineer is concerned with how application requirements map into database requirements. For example, if a business needs to keep track of employees and departments in its database, we need to develop a logical design that meets that goal.

A key process during logical database design is data modeling, or deciding how your application requirements translate into database structures, and then relating those structures. The resulting data model represents ...

Get Building Scalable and High-Performance Java™ Web Applications Using J2EE™ Technology 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.