Skip to page content

Database Management System — Part 1: Concepts, Types, Features and Database Design

Beta

Lesson

Database Management System

Part 1 — what a database and a DBMS are, the types and features, and how to design related tables for an imagined business.

In this lesson you will

Distinguish data from information and explain what a database and a DBMS are
Describe the hierarchical, network, relational and object-oriented types of DBMS
State the main features and advantages of a DBMS for accounting
Identify fields, records, data types and primary, composite and foreign keys, and predict when a DBMS will reject a record
Design related tables and explain relationships, forms, reports and indexing

Part 1 at a glance

Concept

Tables, fields and records at Monal

A table (relation) holds one kind of thing.
A field is a column; a record is a row; a blank value is NULL.

Imagined data. 5 fields (columns) × 6 records (rows); NULL = no agent.
CustCode	CustName	City	CreditLimit	Agent
C01	Anupam Annapurti	Sehore	100000	Anshul
C02	Sanchi Provisions	Vidisha	80000	NULL
C03	Saptarshi Traders	Begamganj	120000	Ruchika
C04	Nirmay Stores	Sironj	60000	Anshul
C05	Gaurang Mart	Vidisha	80000	NULL
C06	Aarohi Foods	Ganjbasoda	90000	Ruchika