Introduction to Designing a Relational Database

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

Prerequisite
Please contact us for information about prerequisites.

Expected Duration
90 minutes

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.

Objective

Relational Database Design

  • 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.
  • Requirement Analysis and Conceptual Design

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

    $129/month
     

    ANNUAL SUBSCRIPTION

    $1295/year

    Multi-license discounts available for Annual and Monthly subscriptions.