The Logical and Physical Database Design Methodologies

Overview/Description
When designing a database – after the requirements are gathered from the organization and the conceptual ERD has been approved – the logical design, and then the physical design can be completed. The logical design consists of taking the conceptual diagram and converting it to represent the logical implementation of the database; this includes identifying the entities, attributes, and the relationships that will exist. This also includes normalizing the database to remove redundant information. After the logical database design, the physical database needs to be implemented. Implementing the physical design includes actually creating the tables, determining the columns and their specifications, and determining indexes and views. This course discusses how to complete the logical database design and how to implement the physical database design.

Target Audience
Individuals looking to gain an understanding of concepts and practices required to design relational databases

Expected Duration (hours)
2.0

Lesson Objectives

The Logical and Physical Database Design Methodologies

define entities for ERD modeling

define attributes for ERD modeling

recognize how to model relationships in the ERD

describe the advanced types of relationships you may need to model in the ERD

define normalization and describe how to apply it to the ER model

develop an initial logical database design using simple E-R modeling techniques

develop a complete logical database design using advanced E-R modeling techniques

determine the tables and the column specifications

recognize how to create views and indexes

describe partitioning and clustering

recognize how to denormalize the design

implement the physical database design