Emp Table

sql> select * from emp;

EMPNO	ENAME	JOB	MGR	HIREDATE		SAL	COMM	DEPTNO
7369	SMITH	CLERK	7902	17-DEC-80		800		20
7499	ALLEN	SALESMAN	7698	20-FEB-81		1600	300	30
7521	WARD	SALESMAN	7698	22-FEB-81		1250	500	30
7566	JONES	MANAGER	7839	02-APR-81		2975		20
7654	MARTIN	SALESMAN	7698	28-SEP-81		1250	1400	30
7698	BLAKE	MANAGER	7839	01-MAY-81		2850		30
7782	CLARK	MANAGER	7839	09-JUN-81		2450		10
7788	SCOTT	ANALYST	7566	09-DEC-82		3000		20
7839	KING	PRESIDENT		17-NOV-81		5000		10
7844	TURNER	SALESMAN	7698	08-SEP-81		1500		30
7876	DAMS	CLERK	7788	12-JAN-83		1100		20
7900	JAMES	CLERK	7698	03-DEC-81		950		30
7902	FORD	ANALYST	7566	03-DEC-81		3000		20
7934	MILLER	CLERK	7782	23-JAN-82		1300		10

Database Models?

Database Models:

The main object of the database is store the inter related data and maintain the data. The very basic elementary piece of data is called as ‘data item’. We assume that item cannot be subdivided into smaller data types and at the same time retain any meaning to the users of the data. The relationship among the data the database models are:

1) File Management System (FMS).

2) Hierarchical Database System (HDBS).

3) Network Database System (NDBs).

4) Relational Database Management System (RDBMS)

What is Database Management System?

What is Database Management System?

A Database Management System is essentially a collection interrelated data and a set of programs to access this data. This  collection of data is called the database. The primary objective of a DBMS is to provide a convenient environment to retrieve and store database information. Database System support single user and multi-user environment. While on one hand DBMS permits only one person to access the database at a given time, on the other RDBMS allows many users simultaneous access to the database.

A Data Base System consists of two parts namely, database Management System and Database Application. Database Management System is the program that organizes and maintains  the information whereas the database management system is the program that organizes and maintains the information stored in the DBMS.

• Database is a collection of data in one or more files for the future reference.
• Database is a collection of interrelated data, i.e., database always stores data along with it’s relationships.

What is database Actually?

What is database Actually?

Database is a platform where we can place the data for the future references. Database is a collection of interrelated data,
i.e., database always stores data along with it’s relationships.