In this article, I have discussed the Database types, equipment (Field, Record, value).

Database types, equipment

Database types

With respect to the structure database is two types:

  1. Simple database
  2. Relational database

Simple

In this type of database, there will be only a single file/table or multiple file/table but there will be no relation between the files.
Example:

Join_data
Employee_ID
Join_Date
Room_no
3941
20.04.18
204
3940
11.04.18
205
3943
28.05.18
206

Hospital
Doctor_ID
Start_date
Doctor_Room_no
1051
30.04.18
304
1052
01.04.18
307
1130
08.05.18
311

Here are multiple numbers of tables but no connections. This is called a simple database.

Relational 

In this type of database, there will be multiple numbers of files/tables and also there will be relations between them.

Join data
Employee_ID
Join_Date
Room_no
3941
20.04.18
204
3940
11.04.18
205
3943
28.05.18
206


Interview_data
Employee_ID
Interview_date
3941
10.04.18
3940
01.04.10
3943
18.05.18

We can see here is the relation between these two tables. This is called a relational database.

Structure of a table

Every table is built with rows and columns.  
From the Interview_data table, we can see there are 4 rows and 3 columns.

Database Equipment 

Field

 Columns are called field. But we will call the first column as a key field.

Record

 Rows are called a record. But we will not count the first row because we used that as heading,

Value (data)

All the entries are called value.

Differences between  field and record:

Field
Record
Columns of a table.
Rows of a table
We cannot get full information from the field.
We can get details information.
There will be the same type of data.
Different types of data will be there.