The Logical and Physical Database Design Methodologies

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

Prerequisite
Please contact us for information about prerequisites.

Expected Duration
120 minutes

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.

Objective

Logical Database Design

  • 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
  • Physical Database Design

  • 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
  • MONTHLY SUBSCRIPTION

    $129/month
     

    ANNUAL SUBSCRIPTION

    $1295/year

    Multi-license discounts available for Annual and Monthly subscriptions.