INTRODUCTION TO RELATIONAL DATABASE MANAGEMENT SYSTEM ppsx

1A.1 Relational Database Design

LESSON: 1A

INTRODUCTION TO RELATIONAL

DATABASE MANAGEMENT

SYSTEM

Objectives

In this lesson, you will learn to:

 Define a Database Management System (DBMS)

 Identify the different DBMS users

 Describe the need for a database system

 Define the architecture of a DBMS in terms of:

x External level

x Conceptual level

x Internal level

 Identify the functional components of a DBMS

 Identify the need for database planning

 Identify the stages in the Database Development Life Cycle (DDLC)

 Identify the effects of poor database planning and design

Relational Database Design 1A.2

Introduction to Relational Database Management

System

©NIIT Lesson 1 / Slide 1 of 12

Introduction to Relational Database

Management System

Objectives

In this section, you will learn to:

• Define a Database Management System (DBMS)

• Identify the components of a DBMS

• Describe the need for a database system

• Define the architecture of a DBMS in terms of:

• External level

• Conceptual level

• Internal level

• Identify the functional components of a DBMS

• Identify the need for database planning

• Identify the stages in the Database Development Life Cycle (DDLC)

• Identify the effects of poor database planning and design

INSTRUCTOR NOTES

Lesson Overview

The lesson introduces the concept of a database management system (DBMS) and the

various users of a DBMS. This lesson also covers the benefits, components, and

architecture of a DBMS. In addition, this lesson explains the need for database

planning and design and the stages in the database development life cycle.