Class 10th unit-3 RELATIONAL DATABASE MANAGEMENT SYSTEMS (BASIC)
RELATIONAL DATABASE MANAGEMENT SYSTEMS (BASIC) Database :- 1. A database is an organized collection of data. You can visualize it as a container of information. 2. A database can have one or many tables. 3. Example:- Suppose if you own a stationary shop, you need to keep detailed records of the materials available in your shop. You also need to store information about pricing, stock levels for reordering, old stocks, etc. While in the manual system, you would maintain several files with different bits of information; in the computerized system you would use database programs such as Microsoft Access, OpenOffice.org Base, and MySQL, to organize the data as per your business need. Database Management System :- 1. A database management system is a software package with computer programs that controls the creation, maintenance, and use of a database. 2. A database is an integrated collection of data records, files, and other objects. 3. A DBMS allows different user applicat