Posts

Showing posts from August 19, 2020

DATABASE INTRODUCTION

Database : A database is an organized collection of related information in which facts are properly arranged and stored.  A database is made up of a basic unit called “Table”.  A table is made of different ‘Fields’ and ‘Records’.  Record : Collection of organized data or related facts is called Record.  Field : A field is a collection of same data types.  DBMS (Database Management System): A database Management System is a tool for managing and manipulating information of a database.  The main Functions of a DBMS is:  Creating Database.   Adding Records.  Modifying Records.  Displaying Records.   Storing Records.   Deleting Records.   Generating Reports.   Printing Reports.  Some Example of DBMS: MS Access, My-SQL,etc.  Features of DBMS: DBMS ensures data security. DBMS facilitates the sharing of data among different database. DBMS controls data inconsistency to a large extent. DBMS reduces the data redundancy to a large context. Data Consistency : Data consistency means that if any c