Create PC and Employee Tables based on the enclosed information using SQL Write the following queries, test
Question:
Create PC and Employee Tables based on the enclosed information using SQL
Write the following queries, test them, and then highlight them to run them together via the Run Script (2nd button). Copy and paste the outputs and also the respective queries in a notepad file, save it, and submit it.
1. Display Employee (Use select)
2. Select user, sysdate from dual;
3. Display data from Inventory and Item tables.
4. List Part number, supplier number, price, New_Price, and quantity ordered from Quotations table. New_Price column shows an increased price by 3% of Price column and renames it as New_Price.
5. List Supplier number, Supplier Name, and Address from Suppliers Table. Display only those suppliers whose names begin with the letter “A.”
6. Display quotations with qonorder that is not zero and price is less than or equal to 1 and delivery time is below 20 days.
7. Display inventory parts where qonhand is blank.
ENCLOSED INFORMATION IS BELOW
PC TABLE
Metadata
Name Null? Type
TAGNUM NUMBER(5)
COMPID CHAR(8)
EMPNUM NUMBER(3)
LOCATION CHAR(12)
User Data
TAGNUM COMPID EMPNUM LOCATION
---------- -------- ---------- ----------------
32808 M759 611 Accounting
37691 B121 124 Sale
57772 C007 567 Info Systems
59836 B221 124 Home
77740 M759 567 Home
EMPLOYEE TABLE
Metadata
Name Null? Type
EMPNUM NUMBER(3)
EMPNAME CHAR(16)
EMPPHONE NUMBER(5)
User Data
EMPNUM EMPNAME EMPPHONE
---------- ---------------------- ----------
124 Alvarez, Ramon 1212
567 Feinstein, Betty 8716
611 Dinh, Melissa 2963
Expert Answer:
