Introduction to Designing a Relational Database


Overview/Description
Target Audience
Expected Duration
Lesson Objectives
Course Number


Overview/Description
Database design is an important process for creating databases. In an organization, the process sets the foundation for good database implementation and ensures that everything required for the business is provided. It also ensures that the database will perform as expected for the users. This course discusses what database modeling is and how it is used to aid database design. This course also describes the four steps in the database design life cycle, which are: requirements gathering and analysis, conceptual database design, logical database design, and physical database design. In addition, this course describes how to complete the first two steps in the database design life cycle – gathering and analyzing business requirements and developing the conceptual database design.

Target Audience
People who want to get an understanding of the concepts and practices to design relational databases.

Expected Duration (hours)
1.5

Lesson Objectives

Introduction to Designing a Relational Database

  • recognize how to use data modeling to represent real-world concepts
  • match each schema of the three-schema database architecture with its correct description
  • match the four steps in the database design life cycle with their correct descriptions
  • describe the process of relational database design
  • recognize the four steps in the database design life cycle.
  • recognize how to analyze requirements for database design
  • plan an interview
  • conduct an interview
  • record and analyze data
  • describe how to generate a conceptual Entity-Relationship Diagram or ERD
  • analyze requirements for database design
  • recognize how to gather business requirements
  • recognize how to generate a conceptual Entity-Relationship Diagram or ERD
  • Course Number:
    df_dbds_a01_it_enus