COURSE PLAN

ABOUT THE COURSE

A database is collection of interrelated data, stored in such a way so that a user can read, insert, update and delete the data efficiently.Database systems are basically developed for large amount of data. When dealing with huge amount of data, there are two things that require optimization: Storage of data and retrieval of data.

Storage: According to the principles of database systems, the data is stored in such a way that it acquires lot less space as the redundant data (duplicate data) has been removed before storage.Fast Retrieval of data: Along with storing the data in an optimized and systematic manner, it is also important that we retrieve the data quickly when needed. Database systems ensure that the data is retrieved as quickly as possible.

DBMS is a software that manages the data for efficient storage and fast retrievals. MySQL, IBM Db2, Oracle, PostgreSQL etc. are all DBMS softwares that manages the data.DBMS is used in various applications such as telecom, banking, sales, airlines, education, online shopping etc.DBMS also secures the data from unauthorised access as well as corrupt data insertions. It allows multiple users to access data simultaneously while maintaining the data consistency and data integrity.