CHAPTER 7

LOGICAL DATABASE DESIGN

Logical 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 ...

Get Fundamentals of Database Management Systems, Second 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.

Start your free trial