-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy path02_data.sql.txt
More file actions
107 lines (81 loc) · 3.72 KB
/
Copy path02_data.sql.txt
File metadata and controls
107 lines (81 loc) · 3.72 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
-- =============================================
-- Employee Management System
-- Sample Data
-- =============================================
-- Departments
INSERT INTO department VALUES (10, 'IT', 'Bangalore');
INSERT INTO department VALUES (20, 'HR', 'Mumbai');
INSERT INTO department VALUES (30, 'Finance', 'Delhi');
INSERT INTO department VALUES (40, 'Marketing', 'Hyderabad');
INSERT INTO department VALUES (50, 'Operations', 'Pune');
INSERT INTO department VALUES (60, 'Research', 'Chennai');
-- Employees
INSERT INTO employee
VALUES (101, 'Arjun', 'arjun@ems.com', 'Software Engineer',
65000, TO_DATE('15-Jan-2023', 'DD-Mon-YYYY'), 10, NULL);
INSERT INTO employee
VALUES (102, 'Priya', 'priya@ems.com', 'HR Executive',
45000, TO_DATE('20-Feb-2022', 'DD-Mon-YYYY'), 20, NULL);
INSERT INTO employee
VALUES (103, 'Rahul', 'rahul@ems.com', 'Senior Developer',
85000, TO_DATE('10-Mar-2021', 'DD-Mon-YYYY'), 10, 101);
INSERT INTO employee
VALUES (104, 'Neha', 'neha@ems.com', 'Accountant',
55000, TO_DATE('05-Apr-2023', 'DD-Mon-YYYY'), 30, NULL);
INSERT INTO employee
VALUES (105, 'Vikram', 'vikram@ems.com', 'Software Engineer',
70000, TO_DATE('12-Jun-2022', 'DD-Mon-YYYY'), 10, 101);
INSERT INTO employee
VALUES (106, 'Sneha', 'sneha@ems.com', 'Marketing Executive',
48000, TO_DATE('25-Jul-2023', 'DD-Mon-YYYY'), 40, NULL);
INSERT INTO employee
VALUES (107, 'Karan', 'karan@ems.com', 'Operations Manager',
75000, TO_DATE('18-Aug-2020', 'DD-Mon-YYYY'), 50, NULL);
INSERT INTO employee
VALUES (108, 'Anjali', 'anjali@ems.com', 'Developer',
68000, TO_DATE('02-Sep-2023', 'DD-Mon-YYYY'), 10, 103);
INSERT INTO employee
VALUES (109, 'Rohit', 'rohit@ems.com', 'Research Analyst',
60000, TO_DATE('11-Nov-2022', 'DD-Mon-YYYY'), 60, NULL);
INSERT INTO employee
VALUES (110, 'Meera', 'meera@ems.com', 'HR Executive',
47000, TO_DATE('30-Jan-2024', 'DD-Mon-YYYY'), 20, 102);
-- Projects
INSERT INTO project
VALUES (501, 'E-Commerce Platform', 2500000,
TO_DATE('10-Jan-2024', 'DD-Mon-YYYY'),
TO_DATE('30-Dec-2024', 'DD-Mon-YYYY'));
INSERT INTO project
VALUES (502, 'Banking Application', 4000000,
TO_DATE('15-Feb-2024', 'DD-Mon-YYYY'),
TO_DATE('31-Mar-2025', 'DD-Mon-YYYY'));
INSERT INTO project
VALUES (503, 'HR Management System', 1500000,
TO_DATE('01-Apr-2024', 'DD-Mon-YYYY'),
TO_DATE('31-Dec-2024', 'DD-Mon-YYYY'));
INSERT INTO project
VALUES (504, 'Mobile Payment App', 3000000,
TO_DATE('20-May-2024', 'DD-Mon-YYYY'),
NULL);
INSERT INTO project
VALUES (505, 'Data Analytics Platform', 3500000,
TO_DATE('01-Jul-2024', 'DD-Mon-YYYY'),
NULL);
INSERT INTO project
VALUES (506, 'Customer Portal', 1800000,
TO_DATE('15-Aug-2024', 'DD-Mon-YYYY'),
TO_DATE('28-Feb-2025', 'DD-Mon-YYYY'));
-- Employee Project Mapping
INSERT INTO employee_project VALUES (101, 501, 'Backend Developer');
INSERT INTO employee_project VALUES (101, 502, 'Developer');
INSERT INTO employee_project VALUES (103, 501, 'Senior Developer');
INSERT INTO employee_project VALUES (103, 502, 'Tech Lead');
INSERT INTO employee_project VALUES (105, 501, 'Backend Developer');
INSERT INTO employee_project VALUES (105, 504, 'API Developer');
INSERT INTO employee_project VALUES (108, 503, 'Developer');
INSERT INTO employee_project VALUES (108, 505, 'Data Engineer');
INSERT INTO employee_project VALUES (102, 503, 'HR Coordinator');
INSERT INTO employee_project VALUES (106, 506, 'Marketing Specialist');
INSERT INTO employee_project VALUES (107, 504, 'Operations Lead');
INSERT INTO employee_project VALUES (109, 505, 'Data Analyst');
COMMIT;