Untitled

techcws

Aug 29th, 2023

232

Never

Add comment

Not a member of Pastebin yet? Sign Up, it unlocks many cool features!

Oracle 11 2.59 KB | None | 0 0

raw download clone embed print report

Name:-
Div:-FY-IT.B
DATE:-14/10/2022
Subject:-DBMS
Roll-No:-
PC_NO:-
PRATICAL ASSIGMENT-4
1. CREATE ALL tables USING constrains.
TABLE NAME:-EMPLOYEE
CREATE TABLE EMPLOYEE_INFO
(
Empid NUMBER(3) PRIMARY KEY,
Empname VARCHAR2(10) NOT NULL,
Department VARCHAR2(5),
Count_No NUMBER(10) NOT NULL,
Emailid VARCHAR2(20),
EmpHeadId NUMBER(5)
);
ALTER TABLE EMPLOYEE_INFO
ADD UNIQUE(EmpHeadId);
TABLE:-EmpDept
CREATE TABLE empdept01
(
deptid VARCHAR2(5) PRIMARY KEY,
deptname VARCHAR2(20) NOT NULL,
dept_off VARCHAR2(10),
depthead NUMBER(10),
FOREIGN KEY (depthead) REFERENCES EMPLOYEE_INFO(EmpHeadId)
);
TABLE created.
TABLE:-EmpSalary
CREATE TABLE emp_salary
(
emp_id NUMBER(3) PRIMARY KEY,
salary NUMBER(10) NOT NULL,
is_permanent VARCHAR2(3)
);
TABLE:- Project
CREATE TABLE project_info
(
project_id VARCHAR2(5) PRIMARY KEY,
duration NUMBER(3) NOT NULL
);
TABLE:-Emp Project
CREATE TABLE emp_project1
(
emp_id3 NUMBER(3) PRIMARY KEY,
pro_id VARCHAR2(5),
start_year VARCHAR2(10),
end_year VARCHAR2(5),
FOREIGN KEY (pro_id) REFERENCES project_info(project_id)
);
2. INSERT ALL records.
TABLE:-Employee
INSERT INTO EMPLOYEE_INFO
VALUES(101,'Isha','E-101',1234567890,'[email protected]',105)
INSERT INTO EMPLOYEE_INFO
VALUES(102,'Priya','E-102',1234567890,'[email protected]',103);
INSERT INTO EMPLOYEE_INFO
VALUES(103,'Neha','E-103',1234567890,'[email protected]',101);
INSERT INTO EMPLOYEE_INFO
VALUES(104,'Rahul','E-104',1234567890,'[email protected]',106);
INSERT INTO EMPLOYEE_INFO
VALUES(105,'Abhishek','E-105',1234567890,'[email protected]',102);
TABLE:- EmpDept
INSERT INTO empdept
VALUES('E-101','HR','Monday',105);
INSERT INTO empdept
VALUES('E-102','Development','Tuesday',101);
INSERT INTO empdept
VALUES('E-103','House Keeping','Saturday',103);
INSERT INTO empdept
VALUES('E-103','Sales','Saturday',103);
INSERT INTO empdept
VALUES('E-105','Purchase','Tuesday',104);
TABLE:- Empsalary
INSERT INTO emp_salary
VALUES(101,2000,'Yes');
INSERT INTO emp_salary
VALUES(102,10000,'Yes');
INSERT INTO emp_salary
VALUES(103,5000,'No');
INSERT INTO emp_salary
VALUES(104,1900,'Yes');
INSERT INTO emp_salary
VALUES(105,2300,'Yes');
TABLE:-Project
INSERT INTO project_info
VALUES('p-1',23);
INSERT INTO project_info
VALUES('p-2',15);
INSERT INTO project_info
VALUES('p-3',45);
INSERT INTO project_info
VALUES('p-4',2);
INSERT INTO project_info
VALUES('p-5',30);
TABLE:-Empproject
INSERT INTO emp_project2
VALUES(101,'p-1','2010','2010');

Add Comment

Please, Sign In to add comment