Generic Design and Modeling Databases: Logical and Physical Design


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description
This course covers how to complete a logical database design and how to implement the physical database. After the requirements are gathered from the organization and the conceptual ERD has been approved, you will learn that the logical design model consists of taking the conceptual diagram and converting it to represent the logical implementation of the database. In this course, you will learn about identifying the entities, attributes, and the relationships that will exist and about normalizing the database to remove redundant information. You will also learn about creating tables, choosing columns and their specifications, and determining indexes and views.

Target Audience
People who want to get an understanding of the concepts and practices involved in designing relational databases

Prerequisites
None

Expected Duration (hours)
3.0

Lesson Objectives

Generic Design and Modeling Databases: Logical and Physical Design

  • start the course
  • describe the logical data model and its advantages
  • define entities in the logical data model for designing a database
  • identify the different categories of attributes that are used in a logical data model
  • define the data types for attributes in a logical data model
  • define DEFAULT and CHECK constraints and nullability for attributes in a logical data model
  • describe the different keys used in a logical data model
  • describe referential integrity and foreign key constraints for a logical data model
  • define relationships in a logical data model for designing a database
  • define advanced relationships in a logical data model
  • model entity supertypes and subtypes in a logical data model
  • resolve many-to-many relationships when building a logical data model
  • describe normalization in relation to designing a database
  • perform first normal form when designing a database
  • perform second normal form when designing a database
  • perform third normal form when designing a database
  • perform BCNF when designing a database
  • perform fourth and fifth normal forms when designing a database
  • determine the factors in selecting a DBMS for the physical database
  • describe the physical database design phase
  • transform entities to tables in the physical database design
  • transform attributes to columns in the physical database design
  • implement views into a physical database
  • implement indexes into a physical database - Clustered and Non-Clustered Indexes
  • implement indexes into a physical database - Hash and Bitmap Indexes
  • create a logical data model and implement the physical database

    • Course Number:
    df_gdmd_a02_it_enus

    Expertise Level
    Beginner