WHAT IS DATABASE?

September 22, 2020

Do you know about the data ?

Data is collection of distict unit of information. It used in variety of forms, of text, number, media and so on. Data is basicaly information that can be translated into a particular form for efficient movement and processing.

EG: Name, height, weight and etc.

WHAT IS DATABASE??

Database is a systematic collectionn of data. Since data in database is ogranized, it makes data management easy. A database mostly controlled by Database Management System (DBMS).

Database Management System (DBMS)

Collection of programs which enables is user to acess databae, manipulate data & help in representation of data.

Type of DMBS :

Navigational DBMS
Relational DBMS
SQL DBMS
Object oriented DBMS

QUERY?

A way of requesting information from the database.
Can be either a select query or an action query.

Select Query- Retrieving data
Action Query - request additional action to be performed on the data. Such as, deletion, insertion and updating.

PRIMARY KEY:

Key in a relational database that unique for each record.
Unique identifier, such as driver license number, telephone number or vehicle identification nmber (VIN)
Must have one and only primary key

FOREIGN KEY :

is key used to link two tables together.
Field in one table that refers to the primary key in another table.
constrautnt is used to prevent action that would destroy links between table
Prevent invalid data from being inserted into the foreign key column.

REPORT :

Formatted result in database queiries and contain useful data for decision-making and analysis.
Most bussines application contain a built-reporting tool.

RECORD

Composed of field and contains all data about one particular person, company item in database.
contains the data for one customer suport incident report

Information

Data that had been process into useful form.

EG:

Document
audio
images
video

0 comments