Title 3.1DatabaseConcepts ,Relational PPT.pdf ✅

Informatics Practices Class XI ( As per CBSE Board) Chapter 12 Database Concepts
DATABASE CONCEPTS A database is a collection of DATA/INFORMATION that is organized so that it can be easily accessed, managed and updated. In Database ,Data is organized into rows, columns and tables, and it is indexed to make it easier to find relevant information. It works like a container which contains the various object like Tables, Queries, Reports etc. in organized way.
WHY DO WE NEED DATABASE To manage large chunks of data: if size of data increases into thousands of records, it will simply create a problem to manage.Database can manage large amount of data. Accuracy: Through validation rule in database ,data accuracy can be maintained. Ease of updating data: With the database, we can flexibly update the data according to our convenience. Moreover, multiple people can also edit data at same time. Security of data: With databases we have security groups and privileges to restrict access. Data integrity: In databases, we can be assured of accuracy and consistency of data due to the built in integrity checks and access controls. DATABASE CONCEPTS
Database Management System(DBMS) A DBMS refers to a software that is responsible for storing, maintaining and utilizing database in an efficient way. A Database along with DBMS software is called Database System. Example of DBMS software are Oracle, MS SQL Server, MS Access, Paradox, DB2 and MySQL etc. MySQL is open source and freeware DBMS. DATABASE CONCEPTS