Introduction to Designing a Relational Database

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