LOGICAL DATABASE DESIGN - Fundamentals of Database Management Systems - page 157

CHAPTER 7

LOGICAL DATABASE

DESIGN

L ogical database design is the process of deciding how to arrange the attributes
of the entities in a given business environment into database structures, such as
the tables of a relational database. The goal of logical database design is to create well
structured tables that properly reflect the company's business environment. The tables will
be able to store data about the company's entities in a non-redundant manner and foreign
keys will be placed in the tables so that all the relationships among the entities will be
supported. Physical database design, which will be treated in the next chapter, is the
process of modifying the logical database design to improve performance.

OBJECTIVES

Describe the concept of logical database design. ■

Design relational databases by converting entity-relationship diagrams into
relational tables.

■

Describe the data normalization process.

■

Perform the data normalization process.

■

Test tables for irregularities using the data normalization process.

■

Learn basic SQL commands to build data structures .

■

Learn basic SQL commands to manipulate data. ■

CHAPTER OUTLINE
Introduction
Converting E-R Diagrams into Relational
Tables
Introduction
Converting a Simple Entity
Converting Entities in Binary
Relationships
Converting Entities in Unary
Relationships

Converting Entities in Ternary
Relationships
Designing the General
Hardware Co. Database
Designing the Good Reading
Bookstores Database
Designing the World Music
Association Database
Designing the Lucky Rent-A-Car
Database