Oracle Database Foundation Learning (III)

Oracle Four-sheet EMP Dept Salgrade bunus Structure, remembering the benefits of later SQL statement learning

Td>data

  employee table (EMP)
No.	field	type	description
1	empno	Number (4)	represents employee numbers, is unique
2	ename	varcha R2	indicates employee name
3	JOB	VARCHAR2 (9)	indicates job title
4	MGR	Number (4)	indicates the employee's leader code
5	hiredate	Indicates the time of employment
6	SAL	number (7,2)	represents employee's salary
7	COMM	number (7,2)	represents an employee's bonus or commission
8	deptno	Number (2)	Department No.

Department Table (Dept)
No.	Field	Type	Describe
1	DEPTNO	Number (2)	Department number, which is the unique number
2	Dname	VARCHAR2 (14)	Department Name
3	LOC	VARCHAR2 (13)	Department location

Salary scale (Salgrade)
No.	Field	Type	Describe
1	GRADE	Number	Salary Level
2	Losal	Number	Level minimum Wage
3	Hisal	Number	Highest level wage

Bonus table (Bouns)
No.	Field	Type	Describe
1	Ename	VARCHAR2 (10)	Employee Name
2	JOB	VARCHAR2 (9)	Employee work
3	SAL	Number	Employee wages
4	COMM	Number	Employee bonus (Commission)

Oracle Database Foundation Learning (III)