BASIC TERMS USED IN DATABASE MANAGEMENT SYSTEMS

 Entity :  Any person or thing which has some characteristics or attributes is called an entity, A person would have different attributes like, name, age,gender, weight, date of birth, place of birth, father's name etc.
 A thing may be a  TV which may have attributes like, make , model no, serial no, year of manufacture,price, date of sale, warranty period etc.

 Table : A table is a chart having multiple columns and rows. Each column shall have a column name. Each row shall hold data related to a particular entity. The picture below shows a typical table. Each table will have data related to a particular  aspect of data.

 Data type : Date can be in the following forms. Some frequently used forms of data are listed below:

 i) Characters: Example - a,b,c X ,Y Z etc
 ii) Strings: Example - Name, Age, Weight etc
 iii) Numbers : Integers Example - 1,4, 56 etc. Real numbers Example - 1.23, 
     45.789  etc Exponential numbers 2.34X10 3
 iv) Date: Example - 23/05/2017,  Jan, 23, 1978 etc

 Database: A Database will have multiple tables. If you consider a person who is working in a Company we can think of the following tables:

 Employee table : Data held- name, age,gender, weight, date of birth, place of birth, employee ID no,father's name etc, date of joining.
 Department table: Department name, department number, employee ID no, designation etc
 Attendance table : date, employee name, employee ID no,present/absent/leave.
 Education and training: SSLC marks, class , year of passing, PUC marks, class, year of passing, diploma/degree marks, 
 class, year of passing, addition training undergone, duration, dates etc.