DBMS

DBMS Programs List


Create and use the following database schema to answer the given queries.

EMPLOYEE Schema
FieldTypeNULLKEYDEFAULT
EnoChar(3)NOPRINIL
EnameVarchar(50)NONIL
Job_typeVarchar(50)NONIL
ManagerChar(3)YESFKNIL
Hire_dateDateNONIL
DnoIntegerYESFKNIL
CommissionDecimal(10,2)YESNIL
SalaryDecimal(7,2)NONIL

DEPARTMENT Schema
FieldTypeNULLKEYDEFAULT
DnoIntegerNOPRINIL
DnameVarchar(50)YESNIL
LocationVarchar(50)YESNew Delhi





EMPLOYEE Schema
CREATE TABLE TUTORIALSDUNIYA.EMP(
Eno CHAR(3) NOT NULL PRIMARY KEY,
Ename VARCHAR(50) NOT NULL,
Job_type VARCHAR(50) NOT NULL,
Manager CHAR(3),			
Hire_date DATE NOT NULL,
Dno INT,
Commission DECIMAL(10,2),
Salary DECIMAL(7,2) NOT NULL
);

DEPARTMENT Schema
CREATE TABLE TUTORIALSDUNIYA.DEPARTMENT
(Dno INT NOT NULL PRIMARY KEY,
Dname VARCHAR(50),
Location VARCHAR(50) DEFAULT 'New Delhi');






If you have any suggestion or found any error in the above program, then do let us know at [email protected] or just comment below.