Class 12 | MySQL

What You Will Learn:

DataBase Concepts

Data
Data is a collection of raw facts and figures.

Information
Information is a collection of processed data i.e. processed form of data.

Database

A database is a collection of interrelated data and a database system is basically a computer-based record-keeping system. The collection of data usually referred to as the database contains information about one particular enterprise.

A database is a collection of interrelated data items that can be processed by one or more application systems.

What is a Database System? What is its need/advantages?

Sol:
A database is a collection of interrelated data and a database system is basically a computer-based record-keeping system.

Advantages:

A typical file processing system suffers from some major limitations like data redundancy (duplication of data), data inconsistency, unsharable data , unstandardized data , insecure data, incorrect data etc. on the other hand a database system overcomes all these limitations and ensures continues efficiency.

The advantages provided by a database system are:

1. Database system reduces data redundancy (data duplication) to a large extent
2. Database system controlled data inconsistency to a large extent
3. Database facilitates sharing of data
4. Database enforces standardized data
5. Centralized cab ensure data security
6. integrity can be maintained through a database

Purpose of Database

A database system should be such that it should fulfill all the requirements of the data needed for an organization’s data processing. The data should be accurate, private, and protected from damage. It should be organized so that diverse applications with different data requirements can employ/use the data. Different application programmers and different end-user will have different views of the data, which must be derived from the common overall data structure.

Database Applications:

• Banking: all transactions
• Airlines: reservations, schedules
• Universities: registration, grades
• Sales: customers, products, purchases
• Online retailers: order tracking, customized recommendations
• Manufacturing: production, inventory, orders, supply chain
• Human resources: employee records, salaries, tax deductions

Number Of Visitors

0238246