Database is a collection of data. It is a special type of computer file that can integrate multiple data files.
A database is centralized, program independent and organized collection of data which removes data redundancy and ensures data integrity.
A Database system is basically a computer based record keeping system. The collection of data, usually referred to as the database.
A database system should be a repository of the data needed for an organization’s data processing.
A DBMS (Database management system) refers to a software that is responsible for storing, maintaining and utilizing databases. A database along with DBMS is referred to as a database system.
A typical file processing system suffers from some major limitations like Data redundancy, data inconsistency, unsharable data, unstandardized data, insecure data, incorrect data, etc.
On the other hand, a database system overcomes all these limitations and ensures continuous efficiency.
The advantages of database system are:-
- Reduces data redundancy.
- Controlled data inconsistency.
- Secured data
- Integrated data
- Standardized data
Relational Database- Data are stored in form of tables also known as relations. Generally each table represent one entity.
Data => Database => Relational Database => Tables or entities => Tuple or record => Attributes.
Relational Database Management system RDBMS is an application software for creating and managing relational databases. It makes us possible for us to create, read, update and delete data from a database .
Some of the popular RDBMS software which use a client server model are:-
- Oracle
- SQL server
- MySQL
- DB2
- MS access
To give instructions to database we use SQL or structured query language.
The primary purpose of SQL is to query and manupulate data stored in a relational database.
Statement of SQL is classified into 5 categories:-
- Data definition language
- Data retrieval
- Data manipulation language
- Transaction control
- Data control
This is all about Database in python.