What is Data?
In general, data is any set of characters that has been gathered and translated for some purpose, usually analysis. It can be any character, including text and numbers, pictures, sound, or footage. If data is not put into context, or it doesn't give any information, it doesn't do anything to a human or computer.
Alex, Smith, 1234 Circle, SLC, UT,8404,8015553211
Wha is Information.
When we collect and process data using a computer program or software, they converted it to a meaningful result called information. Information is an organized collection of related data which gives a complete sense.
What is (Database Management System) DBMS
The database is a collection of related data and data is a collection of facts and figures that can be processed to produce information. A database management system (DBMS) is system software for creating and managing databases. The DBMS provides users and programmers with a systematic way to create, retrieve, update and manage data.
There are three major things in the database management system
A database engine (access, lock, and modification )
Database schema (database logical structure or blueprint of database representation)
These three foundational elements help provide concurrency(fact), security, data integrity, and uniform administration procedures.
The user communicates to the DBMS interface for an efficient and faster way of fulfilling her requirement
Different programs to
INSERT, DELETE, UPDATE, and query database for information
Advantages of the Database management system
Reduced data redundancy
Data backup and recovery
Inconsistency avoid (duplicate data remove)
Multiple user interfaces
Process complex query
The disadvantage of Database :
Needs technical training
Backup is needed
Objective Of DBMS
•Data is an organizational resource. It should be collected, validated, protected, logically organized, and stored with controlled redundancy. This is the organizational database. One of the main objectives of DBMS is to facilitate the sharing of a database by current and future applications
• DBMS must ensure data independence for programs
•Data independence to be provided to application programs
•Data independence allows
-Change of database without affecting application programs
-Change of hardware or system software without affecting application programs
-Sharing of data by different applications by providing views appropriate for the application
• Control of Redundancy – Avoid unnecessary duplication
• Relations between data items specified
• Data integrity – maintain consistency of data values
• Data Security – Permit access to data to authorized users only