CIS 250 Unit 2 Assignment 1 Directions Modify Oracle table data using the correc
ID: 3624614 • Letter: C
Question
CIS 250 Unit 2 Assignment 1Directions
Modify Oracle table data using the correct SQL statements. You must create the statements in Oracle by using the following steps (SQL > SQL commands > Enter Command). Once your command is error-free, copy and paste your statements into this assignment document. Upload this Word document for grading.
Modification Specifics:
A new manager was recently hired along with 5 employees who will work under her.
The President of our company has created a new department for her to head as well.
You can assume that all the new employees were hired today.
Make sure your changes get saved to the database.
Information:
New Employees (using table l_employees):
First Name Last Name Credit Limit Phone Number
Jane Smith 15.00 7890
Martha Woods 20.25
Bill Bourne
Mike Oleni 33.33 3333
C Etter 43
New Manager (using table l_employees):
Rose Hamby is the manager of all the employees above. Her information is below:
First Name Last Name Credit Limit Phone Number Manager Name
Rose Hamby 14.00 3433 Susan Brown
The new department that was created for Rose is as follows (using table l_department):
Department Code Department Name
IT Information Technology
5. For some unknown reason, HR decided to change the hire date of all the employees that were added today, to tomorrow (09/13/2005). Update the database to reflect this change. Make sure your changes get saved to the database.
10. Supplier ASP’s has decided to raise their prices. They raised the price of all their foods by a $1. Update the database to show this change.
11. The price of grilled steak increased by 2 dollars. Update the database to show this change. Show your sql below.
12. The lunches scheduled for the 5 of December has been moved to the 15th of December. Update the database to show this change. Show your sql below.
13. A new supplier, RGF (Really Good Food) has been approved. RGF supplys all the same items as CBC, but 50 cents cheaper. Show the insert statements required to enter this information into the l_foods and l_suppliers table.
Explanation / Answer
Insert into Newemployees values (‘Jane’,’Smith’,15.00,7890);
Insert into Newemployees values (‘Martha’,’Woods’, 20.25);
Insert into Newemployees values (‘Bill’,’Bourne’);
Insert into Newemployees values (‘Mike’,’Oleni’,33.33, 3333);
Insert into Newemployees values (‘C’,’Etter’,43);
Create table Newmanager (Firstname char(50), Lastname char(50), creditlimit float(10), phonenumber integer(20), managername char(20));
Insert into Newmanager values (‘Rose’,’Hamby’,14.00, 3433, ‘Susan’);
10. Supplier ASP’s has decided to raise their prices. They raised the price of all their foods by a $1. Update the database to show this change.
UPDATE Suppliers SET price_increase = 1 WHERE supplier_id = ‘ASP’;
11. The price of grilled steak increased by 2 dollars. Update the database to show this change. Show your sql below.
Note: Only one question per post, as per the Cramster rule. Please post in seperate posts.