Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN: 9780133594140
Author: James Kurose, Keith Ross
Publisher: PEARSON
Bartleby Related Questions Icon

Related questions

Question
100%

9..use the following data to shown minimum and maximum and average of parts unit price

id= 618747_18content id%= 10004576 18stepunull
Remaining Time: 2 hours, 59 minutes, 44 seconds.
v Question Completion Status:
DBS201
Instructions
Write SQL Statements for each one of the questions based on below ERD.
Decide on Data Type and Size based on the sample data in ERD.
Detail_line
PART
1
OrdNo
(PK) PartNo (PK,FK) Quantity
PartNo
(PK)
AX12
Description UnitPrice
Iron
2489
AX12
11
10.99
2491
BT04
1
BT04
Gas Grill
Washer
89.99
2491
BZ66
1
BZ66
189.99
2498
AX12
4
2498
ВТО4
2
Seve Al Aroens
Save and Submt
Click Save and Submit to save and submit. Click Save All Answers to save all answers.
62 M
ENG
2030-11-21
P Type here to search
expand button
Transcribed Image Text:id= 618747_18content id%= 10004576 18stepunull Remaining Time: 2 hours, 59 minutes, 44 seconds. v Question Completion Status: DBS201 Instructions Write SQL Statements for each one of the questions based on below ERD. Decide on Data Type and Size based on the sample data in ERD. Detail_line PART 1 OrdNo (PK) PartNo (PK,FK) Quantity PartNo (PK) AX12 Description UnitPrice Iron 2489 AX12 11 10.99 2491 BT04 1 BT04 Gas Grill Washer 89.99 2491 BZ66 1 BZ66 189.99 2498 AX12 4 2498 ВТО4 2 Seve Al Aroens Save and Submt Click Save and Submit to save and submit. Click Save All Answers to save all answers. 62 M ENG 2030-11-21 P Type here to search
Expert Solution
Check Mark
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;

 

Computer Engineering homework question answer, step 1, image 1

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;

Computer Engineering homework question answer, step 2, image 1

bartleby

Step by stepSolved in 3 steps with 3 images

Blurred answer
Knowledge Booster
Background pattern image
Similar questions
Recommended textbooks for you
Text book image
Computer Networking: A Top-Down Approach (7th Edi...
Computer Engineering
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:PEARSON
Text book image
Computer Organization and Design MIPS Edition, Fi...
Computer Engineering
ISBN:9780124077263
Author:David A. Patterson, John L. Hennessy
Publisher:Elsevier Science
Text book image
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:9781337569330
Author:Jill West, Tamara Dean, Jean Andrews
Publisher:Cengage Learning
Text book image
Concepts of Database Management
Computer Engineering
ISBN:9781337093422
Author:Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:Cengage Learning
Text book image
Prelude to Programming
Computer Engineering
ISBN:9780133750423
Author:VENIT, Stewart
Publisher:Pearson Education
Text book image
Sc Business Data Communications and Networking, T...
Computer Engineering
ISBN:9781119368830
Author:FITZGERALD
Publisher:WILEY