DBMS 1 Lesson 1

This is a critical and little bit hard module in 2nd semester of the 1st year; it’s the DBMS 1.

So I thought to blog some lesson series which might help u. 

Lesson 1:

Firstly we’ll start from the basics.
What is a Database? This defines differently in many books. Below explanation is another way of defining.

Database is a shared collection of logically related data designed to meet the information needs of multiple users in an organization. 

Next come the question why to use a database???? We already have file systems(written documents) then why you need to move to more complex computer based systems???

I will show you why database systems are more appropriate than file based traditional systems.

File systems	Database systems
Data Redundancy - lots of data duplication	Data Redundancy is minimal – data is recorded only once
Data is not shareable – little chance of share data outside it’s application	Data shareable – Database is developed to share data
Data Inconsistency – Several versions of same data may exist.	Data consistency – No several versions of same data
No centralized control to handle data	Presence of centralized data control
Data dependence	Data independence
High Program maintenance	Less Program maintenance
Less data Security	High data Security

Though there are many advantages of Database there are disadvantages as well.

• Performance Problems
• Complexity and Size
• Higher cost of DBMS
• Higher impact of Failure
• Additional hardware components need to be installed

Components of a Database System

Click Here To Download This Lesson in PDF Format

Keep in touch for upcoming Lessons..........