Databses Post 01

What is  Database ?

A database is a collection of data that is organized so that it can easily be accessed, managed, and updated

In everyday life most of us get involve with databases.

Eg; phone, super markets, cms, other web sites

Following elements are Used Database.

Banking

          For customer information, accounts, and loans, and banking transactions

Airlines:

          For reservations and schedule information

Universities:

          For student information, course registrations, and grades

Credit card transactions:

          For purchases on credit cards and generation of monthly

Telecommunication:

          For keeping records of calls made, generating monthly bills, maintaining balances on prepaid calling cards, and storing information about the communication networks statements

Finance:

          For storing information about holdings, sales, and purchases of financial instruments such as stocks and bonds

Sales:

          For customer, product, and purchase information

Manufacturing:

          For management of supply chain and for tracking production of items in factories, inventories of items in warehouses/stores, and orders for items.

Human resources:

          For information about employees, salaries, payroll taxes and benefits, and for generation of paychecks

Types of Databases:

• Traditional database applications
• Multimedia databases
• Geographic information systems
• Data warehousing and online transaction processing
• Real time and active database technology

What is Database Management System ?

A set of programs to access data which enables users to create and maintain a database

Facilities:

·         Defining : specifying data types, structures and constraints for the data to be stored

·         Constructing : storing data on some storage media

·         Manipulating : retrieve specific data, update the data and generate reports

·         Sharing : allow access database for multiple users concurrently

·         Protection : system protection among hardware/software malfunction and security protection against unauthorized access

·         Maintaining : change the system as requirements change overtime