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

ARITHMETIC OPERATIONS ON BINARY NUMBER

Binary arithmetic is simpler to learn because binary number system deals with only two digits - 0 and 1. Binary number perform all arithmetic operation such as Addition, Substraction, Multiplication and compliment as in decimal number system. Binary Addition The addition table for binary arithmetic consist of only the following four entries: 0+0=0 0+1=1 1+0=1 1+1=0 , plus a carry of 1 to the next column.     1011        + 1100    10111     1100    + 1100     11000 Binary Substraction There are three ways to do substraction between binary numbers:- 1. Simple Substraction 2. Substraction using 1's Complement 3. Substraction using 2's Complement Simple Substraction: The complete table of binary substraction is as follows: 0-0=0 0-1=1, borrow 1 from next column 1-0=1 1-1=0    1101 - 0101   1000     1001   - 0111    0...
Post a Comment
Read more

Media Of Communication Part 2

Unguided Media Unguided media transport electromagnetic wave without using a physical connection. This type of communication referred as wireless communication. We can divided wireless transmission in :-   1. Radio Wave:- Electromagnetic   waves ranging in frequencies between 3KHz and 1GHz are normally called radio wave.   On radio wave connectivity used communication used Bluetooth, Wi-Fi, etc.     Bluetooth :- It is a wireless network connectivity that enables to connect or transfer data between devices over a short range the physical range of connection up to 100 meter. Ex- Mobile phone, barcode scanning, portable speaker, wireless keyboard, mouse etc.      Wi-Fi (Wireless Fidelity):- Wi-Fi is a network of wireless connection. Wi-Fi network establish by radio frequency like Bluetooth, but has more power, resulting a strong connection.    ·   Wi-Fi is also called wireless Ethernet. It has connectivity range up...
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