Q24) ?What product(s) have a price equal to the maximum product price Q25) List all employees with their manager's name Using EMP table Q26) List all invoice data (customer name, invoice number, invoice date, product description) forcustomer number 10014
Q24) ?What product(s) have a price equal to the maximum product price Q25) List all employees with their manager's name Using EMP table Q26) List all invoice data (customer name, invoice number, invoice date, product description) forcustomer number 10014
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
Q24) ?What product(s) have a price equal to the maximum product price
Q25) List all employees with their manager's name Using EMP table
Q26) List all invoice data (customer name, invoice number, invoice date, product description) forcustomer number 10014
Transcribed Image Text:DROP TABLE LINE cascade constraints;
DROP TABLE INVOICE cascade constraints;
DROP TABLE CUSTOMER cascade constraints;
DROP TABLE PRODUCT cascade constraints;
DROP TABLE VENDOR cascade constraints;
DROP TABLE EMPLOYEE cascade constraints;
DROP TABLE EMP cascade constraints;
DROP TABLE P cascade constraints;
DROP TABLE V cascade constraints;
purge recyclebin;
CREATE TABLE PRODUCT (
P_CODE VARCHAR2 (10) CONSTRAINT PRODUCT_P_CODE_PK PRIMARY KEY,
P_DESCRIPT
P_INDATE
P_QOH
P_MIN
P_PRICE
P_DISCOUNT
V_CODE
CONSTRAINT PRODUCT_V_CODE_FK
FOREIGN KEY (V_CODE) REFERENCES VENDOR);
VARCHAR2 (35) NOT NULL,
DATE NOT NULL,
NUMBER NOT NULL,
NUMBER NOT NULL,
NUMBER (8,2) NOT NULL,
NUMBER (4,2) NOT NULL,
NUMBER,
CREATE TABLEV (
V_CODE
V_NAME
V_CONTACT
V_AREACODE
V_PHONE
V_STATE
V_ORDER
INTEGER PRIMARY KEY,
VARCHAR ( 35) NOT NULL,
VARCHAR (15) NOT NULL,
CREATE TABLE CUSTOMER (
Cus_CODE
CuS_LNAME
CuS_FNAME
Cus_INITIAL
CUS_AREACODE
CuS_PHONE
Cus_BALANCE
CONSTRAINT CUS_UI1 UNIQUE (CUS_LNAME, CUS_FNAME));
NUMBER PRIMARY KEY,
VARCHAR (15) NOT NULL,
VARCHAR (15) NOT NULL,
CHAR(1),
CHAR (5) DEFAULT '615' NOT NULL CHECK (CUS_AREACODE IN ('615',"713', '931')),
CHAR(8) NOT NULL,
CHAR (5) NOT NULL,
CHAR (8) NOT NULL,
CHAR (2) NOT NULL,
CHAR (1) NOT NULL);
NUMBER (9,2) DEFAULT 0.00,
CREATE TABLE P (
P_CODE
P_DESCRIPT
P_INDATE
P_QOH
P_MIN
VARCHAR2 (10) PRIMARY KEY,
VARCHAR2 (35) NOT NULL,
DATE NOT NULL,
NUMBER NOT NULL,
NUMBER NOT NULL,
NUMBER (8,2) NOT NULL,
NUMBER (4,2) NOT NULL,
NUMBER);
CREATE TABLE INVOICE (
INV_NUMBER
Cus_CODE
INV_DATE
CONSTRAINT INV_CK1 CHECK (INV_DATE > TO_DATE('01-JAN-2819","D0-NON-YYYY")));
NUMBER PRIMARY KEY,
NUMBER NOT NULL REFERENCES CUSTOMER(CUS_CODE),
DATE DEFAULT SYSDATE NOT NULL,
P_PRICE
P_DISCOUNT
V_CODE
CREATE TABLE LINE (
CREATE TABLE VENDOR (
V_CODE
V_NAME
v_CONTACT
V_AREACODE
V_PHONE
V_STATE
v_ORDER
PRIMARY KEY (V_CODE));
NUMBER NOT NULL,
INV_NUMBER
LINE_NUMBER
P_CODE
LINE_UNITS
LINE_PRICE
PRIMARY KEY (INV_NUMBER, LINE_NUMBER),
FOREIGN KEY (INV_NUMBER) REFERENCES INVOICE ON DELETE CASCADE,
FOREIGN KEY (P_CODE) REFERENCES PRODUCT (P_CODE),
CONSTRAINT LINE_UI1 UNIQUE (INV_NUMBER, P_CODE));
INTEGER,
VARCHAR ( 35) NOT NULL,
VARCHAR (15) NOT NULL,
CHAR (5) NOT NULL,
CHAR (8) NOT NULL,
CHAR (2) NOT NULL,
CHAR (1) NOT NULL,
NUMBER (2,0) NOT NULL,
VARCHAR (10) NOT NULL,
NUMBER (9,2) DEFAULT 8.00 NOT NULL,
NUMBER (9,2) DEFAULT 8.00 NOT NULL,
Transcribed Image Text:CREATE TABLE EMPLOYEE (
EMP_NUM
EMP_TITLE
EMP LNAME
EMP_FNAME
EMP_INITIAL
EMP DOB
EMP_HIRE DATE
EMP_YEARS
EMP_AREACODE
EMP_PHONE
/*P rows
NUMBER PRIMARY KEY,
INSERT INTO P VALUES("11QER/31", "Power painter, 15 psi., 3-nozzle
INSERT INTO P VALUES("13-Q2/P2","7.25-in. pwr. saw blade"
INSERT INTO P VALUES("14-Q1/L3", "9.e8-in. pwr. saw blade"
INSERT INTO P VALUES("1546-Q02", "Hrd. cloth, 1/4-in., 2x5e"
INSERT INTO P VALUES("1558-QW1", "Hrd. cloth, 1/2-in., 3x5e
INSERT INTO P VALUES( "2232/QTY", "B\&D jigsaw, 12-in. blade
INSERT INTO P VALUES("2232/QWE", "B\&D jigsaw, 8-in. blade"
INSERT INTO P VALUES("2238/QPD", "B\40 cordless drill, 1/2-in."
INSERT INTO P VALUES("23109-HB", "C1law hamner
INSERT INTO P VALUES("23114-AA", "Sledge hamner, 12 lb."
INSERT INTO P VALUES("54778-21', "Rat-tail file, 1/8-1in. fine'
INSERT INTO P VALUES("89-WRE-Q', "Hicut chain saw, 16 in."
INSERT INTO P VALUES("PVC230RT", "Pc pipe, 3.5-in., 8-ft"
INSERT INTO P VALUES("SM-18277",'1.25-in. netal screw, 25"
INSERT INTO P VALUES("SW-23116","2.5-in. wd. screw, se
INSERT INTO P VALUES("WR3/TT3' ,"Steel ratting, 4''x8" "x1/6", .5" nesh',"17-JAN-2019", 18, 5,119.95,8.10,25595);
e3-NOV-2018', 8, 5,109.99,8.ee,25595);
,'13-DEC-2018", 32, 15, 14.99,8.e5, 21344);
,'13-NOV-2019', 18, 12, 17.49,0.ee,21344);
,'15-JAN-2019', 15, 8, 39.95,0.00,23119);
,'15-JAN-2819", 23, 5, 43.99,8.80, 23119);
,38-DEC-2018', 8, 5,109.92,8.e5,24288);
,"24-DEC-2018', 6, 5, 99.87,8.e5,24288);
,"28-JAN-2019', 12, 5, 38.95,8.e5,25595);
,"20-JAN-2019', 23, 10, 9.95,0.18,21225);
,"e2-JAN-2019', 8, 5, 14.40,0.e5, NULL);
,'15-DEC-2018', 43, 20, 4.99,0.00,21344);
,'87-FEB-2019", 11, 5,256.99,8.05, 24288);
,28-FEB-2019',188, 75, 5.87,0.e0, NULL);
e1-MAR-2019", 172, 75, 6.99,8.e0,21225);
"24-FLB-2019', 237,100, 8.45,0.e0, 21231);
CHAR (10),
VARCHAR (15) NOT NULL,
VARCHAR (15) NOT NULL,
CHAR (1),
DATE,
DATE,
NUMBER,
CHAR (3),
CHAR (8));
CREATE TABLE EMP (
EMP_NUM
EMP_TITLE
EMP LNAME
EMP_FNAME
EMP_INITIAL
EMP_DOB
EMP_HIRE DATE
EMP_AREACODE
EMP_PHONE
EMP_MGR
NUMBER PRIMARY KEY,
CHAR (10),
VARCHAR(15) NOT NULL,
VARCHAR (15) NOT NULL,
CHAR (1),
DATE,
* VENDOR rows
INSERT INTO VENDOR (SELECT • FROM V);
DATE,
CHAR (3),
CHAR (8),
NUMBER);
/* PRODUCT rows
INSERT INTO PRODUCT (SELECT • FRROM P);
* CUSTOMER rOws
INSERT INTO CUSTOMER VALUES (18018, "Ranas
INSERT INTO CUSTOMER VALUES(10011, 'Dunne
INSERT INTO CUSTOMER VALUES(10012, 'Sith
INSERT INTO CUSTOMER VALUES (10013, 'Olowski" , "Paul' ,'F' ,'615', '894-218e",536.75);
INSERT INTO CUSTOMER VALUES (18014, 'Orlando" , 'Hyron ,NULL, '615','222-1672',8);
INSERT INTO CUSTOMER VALUES (18015, '0""Brian", "Any"
INSERT INTO CUSTOMER VALUES (10016, 'Brown"
INSERT INTO CUSTOMER VALUES (18017, 'Willians", "George", NULL, '615", "298-2556",768.93);
INSERT INTO CUSTOMER VALUES (18018, 'Farriss" ,'Anne ,' ,'713",'382-7185', 216.55);
INSERT INTO CUSTOMER VALUES (10019, 'Snith"
/* Loading data rows
/* Turn Escape character on
/* Default escape character "I
/* Used to enter special characters (8)
,'Alfred", 'A" ,'615s', '844-2573",8);
"Leona" ,"K" ,'713','894-1238',8);
"Kathy" , "W ,'615",'894-2285', 345.86);
SET ESCAPE ON;
,'B' ,'713','442-3381',8);
"Janes' ,'6" ,'615','297-1228', 221.19);
/* v rOws
INSERT INTO V VALUES (21225, 'Bryson, Inc."
INSERT INTO V VALUES (21226, 'SuperLoo, Inc."
INSERT INTO V VALUES (21231, 'D\&E Supply"
INSERT INTO V VALUES (21344, 'Jabavu Bros."
INSERT INTO V VALUES (22567, 'Dome Supply'
INSERT INTO V VALUES (23119, 'Randsets Ltd.'
INSERT INTO V VALUES (24804, 'Bracknan Bros."
INSERT INTO V VALUES (24288, 'ORDVA, Inc."
INSERT INTO V VALUES (25443, 'B\&K, Inc."
INSERT INTO V VALUES (25501, 'Damal Supplies"
INSERT INTO V VALUES (25595, 'Rubicon Systens ,'Du Toit'
,"0lette", "K" ,'615', 297-3829",8);
,'Smithson', '615','223-3234', "TN','Y');
"Flushing', '984','215-8995', "FL','N');
615','228-3245', "TN','Y');
'615','889-2546', 'KY', 'N');
981','678-1419', "GA', 'N');
,'Anderson', '981','678-3998", " GA',"Y');
"Browning', '615', 228-1410, TN', 'N');
,"Hakford','615','898-1234',"TN',"Y');
*984','227-0093', 'FL','N');
,"Smythe' ,'615','890-3529","TN', 'N');
984','456-0092", 'FL', 'Y');
/* INVOICE rows
INSERT INTO INVOICE VALUES(1801,18014, '15-JAN-2019');
INSERT INTO INVOICE VALUES(1002, 18811, '16-JAN-2019');
INSERT INTO INVOICE VALUES(1003,10012, '16-JAN-2019');
INSERT INTO INVOICE VALUES(1004, 18e11, '17-JAN-2019');
INSERT INTO INVOICE VALUES(1005,10018, '17-JAN-2819');
INSERT INTO INVOICE VALUES(1006,10014, '17-JAN-2819');
INSERT INTO INVOICE VALUES(1007,18e15, '17-JAN-2019');
INSERT INTO INVOICE VALUES(1808,18011, '17-JAN-2019');
"Singh"
,"Khunalo'
Smith"
Smith
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY