Databases:

Databases are programs designed to organize data in a meaningful way. It offers to store, manage and retrieve relevant information.
The program uses tables to manage the data if you are familiar with how to work with Microsoft Excel then you’re familiar with storing
information in a tabular form.


Typically composed of one or more tables
a. A collection of related information
b. A collection of records

Example:


Picture1.png

Type of Database:


1.
Flat Database -
is standalone database, uses one table. The flat file design puts all database information in one table, or list,
with fields to represent all parameters. A flat file may contain many fields, often, with duplicate data that are prone to data corruption
and redundancy. Merging data between two flat files, create the need to copy and paste relevant information from one file to the other.
There is no automation between flat files. Changing information in one file has no bearing on other files. Flat files offer the functionality to store information, manipulate fields, print or display formatted information and exchange information with others.

2.
Relational Database -
Incorporates multiple tables with methods for the tables to work together. The relationships between
table data can be collated, merged and displayed in database forms. Most relational databases offer functionality to share data:
  • Across networks
  • Over the Internet
  • With laptops and other electronic devices, such as palm pilots
  • With other software systems


Where do we use database?

1. Warehouses

or
Assembly to Sales




2. Airports
Use of Biometrics


3. Banks

ATM Machine



4.
School Library


5. Micro chips in Human Body




Activity for today: Click Here





Read this Article:

Supreme Court Databases