The Logical and Physical Database Design Methodologies

Target Audience
Expected Duration
Lesson Objectives
Course Number

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)

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
  • Course Number: