ICS Part 2 Computer Lectures Chapter 1 Data Basics | What is DBMS and Ad...

ICS Part 2 Computer Lectures Chapter 1 Data Basics | What is DBMS and Advantages & Disadvantages

In this lecture we discuss with Practicals & Animation at the end of lectures :

1)Database Management System: 

A database management system (DBMS) is a software package designed to define, manipulate, retrieve and manage data in a database. A DBMS generally manipulates the data itself, the data format, field names, record structure and file structure. It also defines rules to validate and manipulate this data

2) ADVANTAGES of Database Management system

1. Data Independence 
2. Data Redundancy 
3. Consistency Constraint 
4. Support complex and Data Relationship 
5. Data Security Features 
6. Database Backup & Recovery 
7. Advance Capabilities

3) Disadvantages of database management system

1. High Cost DBMS 
2. Higher Hardware Cost 
3. Appointing Technical Staff 
4. Cost of Staff Training 
5. Problem in wrong database Environment 
6. Need of Data Dictionary

4) Short Questions important Selection 

What is DDL(Data Definition Language)?

 What is DML(Data Manipulation Language)? 

What is DCL(Data Control Language)?



2) Now So Let's Start For Practical With Example
Congratulations Microsoft Access Chapter 1 Data Basics is COMPLETE NOW.

#ICSPart2 #DataBasics #Chapter1
#DBMS #Features #Database #Advantages #disadvantages

Computer Lecturer :Shahzaib Naz