DATABASE

DATABASE

BY-SAMRIDDHI

WHAT IS A DATABASE?

DATABASE IS A WAY OF STORING AND ORGANISING DATA IN TABLES SO THAT THE DESIRED INFORMATION CAN BE EASILY ACCESSED OR EDITED

DATABASE IS USED IN

• RAILWAYS--FOR RESERVATION OR FOR SCHEDULING

• SOCIAL NETWORKING SITES-FOR STORING INFORMATION ON PROFILE OR MESSAGES

• SCHOOLS-FOR STORING INFORMATION RELATED TO SCHOOL

TYPES OF DATABASE

• FLAT DATABASE-INFORMATION STORED IN A SINGLE TABLE

• RELATIONAL DATABASE-INFORMATION STORED IN A MULTIPLE TABLE

MAIN COMPONENTS OF A DATABASE

• RECORDS OR ROW

• FIELDS OR COLUMNS

• QUERY

• REPORTS

• DATA

• FORMS

WHAT IS A PRIMARY KEY?

A PRIMARY KEY OF A TABLE IS A FIELD OR COMBINATION OF FIELDS WHOSE VALUE IS UNIQUE OR EACH RECORD

WHAT IS A QUERY?

A REQUEST TO THE DATABASE TO EXTRACT DATA ASKED BY THE USER

WHAT IS DATABASE MANAGEMENT SYSTEM?

IT IS A SOFTWARE PACKAGE THAT FACILITATES TO CREATE,EDIT,FORMAT,RETRIEVE DATA AS PER THE REQUIREMENT

ADVANTAGES OF A DBMS

• DATA SHARING

• DATA SECURITY

• DATA CONSISTENCY