Skip to main content

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: 

  1. Creating Database. 
  2.  Adding Records. 
  3. Modifying Records. 
  4. Displaying Records. 
  5.  Storing Records. 
  6.  Deleting Records. 
  7.  Generating Reports. 
  8.  Printing Reports.
 Some Example of DBMS: MS Access, My-SQL,etc. 

Features of DBMS:

  1. DBMS ensures data security.
  2. DBMS facilitates the sharing of data among different database.
  3. DBMS controls data inconsistency to a large extent.
  4. DBMS reduces the data redundancy to a large context.
Data Consistency: Data consistency means that if any change is made in the data at one place, the corresponding changes in value of other information which is related to that data in other tables is also update.
Data Redundancy: Data redundancy mean storing of the same data in a duplicate form in different table separately in the same database.

Comments

Post a Comment

Popular posts from this blog

BASIC STRUCTURE OF A COMPUTER SYSTEM

Computer Function A computer performs action and accomplishes its task in three basic stages namely:- INPUT – Input is the data that is fed into the computer by the user. PROCESS – Processing refers to the series of action by which the computer converts raw data into information. OUTPUT – Output is the result which is termed as information. Input Unit Data and instructions enter a computer through an input unit in a form that depends upon the input device used. Ex- Keyboard, Mouse, Joystick, Scanner etc. CENTRAL PROCESSING UNIT (C.P.U) CPU is also known as the brain of the “Brain of Computer”. As it appears as a hardware component, but it is also a functional component of a computer system. Functional Elements of a CPU        1.        Arithmetic Logic Unit(ALU)        2.        Control Unit(C.U)        3.    ...
Post a Comment
Read more

DEVICES USED IN NETWORK

  1. MODEM: It stands for Modulator- Demodulator. A   modem is a peripheral device which modulates ( convert   digital signals to analog signals) and demodulates( convert   analog signals into digital signals) at the local workstation.   The sending and receiving ends of the communication must   have a modem. Now a days mobile phones have inbuilt   modem devices that help to browse internet.      2. Switch: A network switch is a small hardware device that is used to amplify data signals & create smaller network segment or several subnets of bigger network. It is used to prevent overloading of data in the traffic of a network. It is also responsible for forwarding and transforming data packets between the sub networks.    3. HUB:   A hub is a hardware device which provides common connection point to connect several devices together in a network. It contains multiple ports on which wo...
Post a Comment
Read more

Application OF Computer

Communication : - In the past, people used to communication through letters, telephones etc. The advent of computers has made it possible to share or exchange information in real time (instant). Information can be textual, graphics or visual from any corner of the world in different ways. Like – Email, Online chatting, Video conferencing, FTP (File Transfer Protocol), Telnet, Social Networking. News & Broadcasting : The delivery and reception of news has changed dramatically with the advent of computers. Earlier, Journalists used snail mail, reel-to-reel recorders, dark-room processing for photos and typewriters for composing contents. But now computers have facilitated in Instant Broadcast, Online Newspapers, Online News Channels, etc. Social Networking: Before the advent of computer, people used to interact with friends and relatives in closed groups and meet them during family functions, religious ceremonies and gatherings at local temples, gurudwaras, mosques or church...
Post a Comment
Read more