Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN: 9780133594140
Author: James Kurose, Keith Ross
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
thumb_up100%
9..use the following data to shown minimum and maximum and average of parts unit price
Expert Solution
arrow_forward
Step 1
Parts table:
Creating parts table:
create table parts (
PartNo varchar(5) primary key,
Description varchar(25) not null,
UnitPrice number(6,2));
Inserting data into parts table:
- insert into parts values('AX12','Irin',10.99);
- insert into parts values('BT04','Gas Grill',89.99);
- insert into parts values('BZ66','Washer',189.99);
Displaying data from parts table:
- select * from parts;
arrow_forward
Step 2
Detail_line table:
creating Detail_line table:
create table Detail_line (
OrdNo integer,
PartNo varchar(5) not null,
Quantity integer, PRIMARY KEY (OrdNo,PartNo),
FOREIGN KEY (PartNo) REFERENCES Parts(PartNo));
Inserting Data into Detail_line Table:
- insert into Detail_line values(2489,'AX12',11);
- insert into Detail_line values(2491,'BT04',1);
- insert into Detail_line values(2491,'BZ66',1);
- insert into Detail_line values(2498,'AX12',4);
- insert into Detail_line values(2498,'BT04',2);
Displaying data from Detail_line table:
- select * from Detail_line;
Step by stepSolved in 3 steps with 3 images
Knowledge Booster
Similar questions
- You need to make use of an Oracle function in order to compute the number of days that have passed from your birthday up to the present moment.arrow_forwardCamille needs to identify the number of projects that have a final cost of more than $100,000 and those that were completed in 2019.Create formulas that provide this information as follows: In cell K11, create a formula using the DCOUNT function to count the number of projects with final costs of more than $100,000, using the data in the entire Projects table (Projects[#All]) and counting the values in the column of final costs ("Final Cost") that are equal to the values in the range J9:J10. In cell K15, create a formula using the DCOUNTA function to count the number of projects completed in 2019, using the data in the entire Projects table (Projects[#All]) and counting the values in the column of completion dates ("Completed") that are equal to the values in the range J13:J14.arrow_forwardBelow are some rows of the PROVIDERS table for a factory: PCODE 10192 98411 0489035 NAME Hans, Inc. Tools and More Motors Inc. PHONE 231 - 3092 231-1029 993 - 1821 All providers from the factory zone of the city start with 231. You want to get the providers that are in the factory zone of the city. Which of the following is more appropriate? O a. O b. SELECT * FROM PROVIDERS WHERE PHONE LIKE '% 231' O C. O d. SELECT * FROM PROVIDERS WHERE PHONE LIKE $231%' SELECT * FROM PROVIDERS WHERE PHONE LIKE 231 SELECT * FROM PROVIDERS WHERE PHONE LIKE '%231%'arrow_forward
- 4. Find all instructors in Finance department who have taught some course in 2008. 5. Find all students from Physics department who took course 'CS-319'.arrow_forwardTechnology College Muscat hired you as a programmer to automate their manual Student Registration System. The college requires you to develop a C++ program to manage their Students' personal and academic record. You are required to develop a C++ program using C++ structures, arrays, and user defined functions. The college stores each student's full name, a maximum of 30 character long, student's age, numeric student's ID number of 8 digits long, student's modules enrolled and student's module result. You are required to implement 3 different functions, a function to get/input all the data of a student from a user. A function to get/input student's modules and result against each module and to calculate average marks of each students, and a function to display all students' personal and academic data. You are required to demonstrate storing of 5 students and displaying their stored data with average marks. You are also required to calculate and display the overall result analysis for 5…arrow_forwardA field goal kicker makes 4 of 5 extra points during a game. What percent of extra points were made?arrow_forward
- 4. Find all instructors in Finance department who have taught some course in 2008. 5. Find all students from Physics department who took course 'CS-319|* .arrow_forwardIn cell C16, create a formula that adds 1 to the growth rate (cell C14) and multiplies the result by the estimated profit from 2021 (cell C15). Use an absolute row reference to cell C14.arrow_forwardPlease! Can someone help me with this questionarrow_forward
- Please do the exercise! Thank youuuarrow_forwardThe file ClassificationData.xlsx (Screenshot attached below) contains the following information about the top 25 MBA programs: percentage of applicants accepted, percentage of accepted applicants who enroll, mean GMAT score of enrollees, mean undergraduate GPA of enrollees, annual cost of school (for state schools, this is the cost for out-of-state students), percentage of students who are minorities, percentage of students who are non-U.S. residents, and mean starting salary of graduates (in thousands of dollars).Use these data to divide the top 25 schools into 4 clusters, usingfor example the K-Means clustering algorithm, and interpret your clusters. The method is explained in our textbook: Section 8.8 in the Fourth and Fifth Edition or Section 14.3 in the Sixth Edition. More precisely, use Evolutionary Solver to find 4 schools to be used as cluster centers and to assign all other schools to one of these cluster centers. Each school is then assigned to the nearest cluster center,…arrow_forwardquestion B is x = y^z not x = y^2arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Computer Networking: A Top-Down Approach (7th Edi...Computer EngineeringISBN:9780133594140Author:James Kurose, Keith RossPublisher:PEARSONComputer Organization and Design MIPS Edition, Fi...Computer EngineeringISBN:9780124077263Author:David A. Patterson, John L. HennessyPublisher:Elsevier ScienceNetwork+ Guide to Networks (MindTap Course List)Computer EngineeringISBN:9781337569330Author:Jill West, Tamara Dean, Jean AndrewsPublisher:Cengage Learning
- Concepts of Database ManagementComputer EngineeringISBN:9781337093422Author:Joy L. Starks, Philip J. Pratt, Mary Z. LastPublisher:Cengage LearningPrelude to ProgrammingComputer EngineeringISBN:9780133750423Author:VENIT, StewartPublisher:Pearson EducationSc Business Data Communications and Networking, T...Computer EngineeringISBN:9781119368830Author:FITZGERALDPublisher:WILEY
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