Given: using linux and connected to an oracle database that is made up of 6 tables: customer, employee, parts, orders, partOrder, telephone. Complete the following tasks. Reminder that you must use linux and oracle sql

Key Information:

a) Employee Primary Key: eid d) partOrder Primary Key: poid Foreign Keys: pid, oid

b) customer primary key: cid e) part Primary Key: pid

c) order primary Key: oid Foreign keys: cid, eid f) telephone Primary Key: tid Foreign Key: eid

1) Create and execute query for order information joined with customer information. 2) Create and execute query that lists employee information together with the number of orders they have processed. 3) Create and execute a query that deletes all PartOrder records for Orders for which the shipping date is in the past. 4) Add a column called processed to the PartOrder table. 5) Create a view of Part information together with the total quantity of such parts for which Orders were received in 2016 (use a different year, if there is no corresponding record in your database)