Question
Can you write SQL code to create this table? PartsUsed OrdNo PartNo QtyUsed 1 2 1 1 3 4 2 3 1 2 4 5
Can you write SQL code to create this table?
| PartsUsed | ||
|---|---|---|
| OrdNo | PartNo | QtyUsed |
| 1 | 2 | 1 |
| 1 | 3 | 4 |
| 2 | 3 | 1 |
| 2 | 4 | 5 |
| 3 | 2 | 1 |
| 3 | 3 | 2 |
| 3 | 4 | 2 |
| 3 | 20 | 2 |
| 5 | 5 | 5 |
| 5 | 6 | 5 |
| 5 | 8 | 1 |
| 5 | 14 | 1 |
| 5 | 16 | 2 |
| 6 | 7 | 1 |
| 6 | 8 | 2 |
| 7 | 1 | 2 |
| 8 | 1 | 4 |
| 8 | 2 | 1 |
| 8 | 3 | 1 |
| 8 | 4 | 1 |
| 9 | 9 | 1 |
| 9 | 10 | 4 |
| 10 | 4 | 4 |
| 11 | 3 | 2 |
| 11 | 4 | 1 |
| 12 | 1 | 4 |
| 12 | 7 | 2 |
| 13 | 7 | 1 |
| 13 | 8 | 1 |
| 14 | 3 | 6 |
| 14 | 6 | 4 |
| 14 | 14 | 1 |
| 15 | 4 | 1 |
| 15 | 20 | 1 |
| 16 | 9 | 1 |
| 16 | 14 | 1 |
| 17 | 7 | 4 |
| 17 | 13 | 1 |
| 18 | 1 | 5 |
| 18 | 4 | 6 |
| 19 | 8 | 2 |
| 20 | 5 | 2 |
| 20 | 7 | 4 |
| 21 | 15 | 1 |
| 21 | 16 | 1 |
| 21 | 17 | 3 |
| 21 | 18 | 1 |
| 22 | 1 | 5 |
| 22 | 2 | 1 |
| 23 | 4 | 2 |
| 23 | 16 | 3 |
| 23 | 20 | 2 |
| 24 | 3 | 2 |
| 25 | 10 | 1 |
| 25 | 13 | 1 |
| 26 | 14 | 1 |
| 27 | 4 | 6 |
| 27 | 7 | 4 |
| 28 | 19 | 1 |
| 29 | 4 | 1 |
| 29 | 9 | 1 |
| 30 | 2 | 1 |
| 30 | 3 | 2 |
| 30 | 6 | 6 |
| 32 | 8 | 2 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Concepts of Database Management
Authors: Philip J. Pratt, Joseph J. Adamski
7th edition
ISBN: 978-1111825911, 1111825912, 978-1133684374, 1133684378, 978-111182591
