Week 3: Individual Assignment: Data Changes and SQL Statements
Enter records into the Employee table for workers identified in the employee files for the
administrative offices and the Del Mar store
INSERT INTO EMPLOYEE VALUES
('Edelman', 'Glenn', '175 Bishops Lane', 'La Jolla', 'CA','619', '555-0199', 'Sales Workers', '07-
OCT-2003',21500.75, 'M', 64, '472');
INSERT INTO EMPLOYEE VALUES
('McMullen', 'Eric', '763 Church St', 'Lemon Grove', 'CA', '619', '555-0135', 'Sales Workers',' 1-
NOV-2002', 13500.00, 'M', 20, '496');
INSERT INTO EMPLOYEE VALUES
('Slentz', 'Raj', '123 Torrey Dr', 'North Clairmont', 'CA', '619', '555-0123', 'Officials Managers',
'1-JUN-2000', 48000.00, 'M', 34, '043');
INSERT INTO EMPLOYEE VALUES
('Broun', 'Erin', '2045 Parkway Apt 2B', 'Encinitas', 'CA', '760', '555-0100', 'Sales Workers', '12-
MAR-2003', 10530.00, 'F', 24,'496');
INSERT INTO EMPLOYEE VALUES
('Carpenter', 'Donald','927 Second St', 'Encinitas', 'CA', '619', '555-0154', 'Office Clerical', '1-
NOV-2003', 15000.00, 'M', 18, '562');
INSERT INTO EMPLOYEE VALUES
('Esquivez', 'David', '10983 N. Coast Hwy Apt 902', 'Encinitas', 'CA', '760', '555-0108',
'Operatives', '25-JUL-2003', 18500.00, 'M',25, '781');
INSERT INTO EMPLOYEE VALUES
('Sharp', 'Nancy', '10793 Montecino Rd', 'Ramona', 'CA', '858', '555-0135', 'Sales Workers',
'12-JUL-2003', 21000.00, 'F', 24, '472');
INSERT INTO EMPLOYEE VALUES
('Chavez', 'Jose', '10793 Montecino Rd', 'Ramona', 'CA', '858', '555-0135', 'Office Clerical', '19-
NOV-2003', 16500.00, 'M', 19, '472');
INSERT INTO EMPLOYEE VALUES
('Chapman', 'Eden', '10793 Montecino Rd', 'Ramona', 'CA', '858', '555-0135', 'Office Clerical',
'13-SEP-2001', 17500.00, 'F', 32, '472');
INSERT INTO EMPLOYEE VALUES
('Munoz', 'Luis', '10793 Montecino Rd', 'Ramona', 'CA', '858', '555-0135', 'Office Clerical', '31-
MAR-2001', 14500.00, 'M', 22, '512');
INSERT INTO EMPLOYEE VALUES
('Miller', 'Art', '10793 Montecino Rd', 'Ramona', 'CA', '858', '555-0135', 'Office Clerical', '29-
SEP-2003', 15000.00, 'M', 19, '512');
INSERT INTO EMPLOYEE VALUES
('Vance', 'Brent', '10793 Montecino Rd', 'Ramona', 'CA', '858', '555-0135', 'Sales Workers',
'29-MAR-2001', 10530.00, 'M', 22, '472');
INSERT INTO EMPLOYEE VALUES
