Question: 6. Let's look at some schema info from the PRODUCT table: describe PRODUCT; Look at the column types, whether columns were PKS or Fks and

6. Let's look at some schema info from the PRODUCT table: describe PRODUCT; Look at the column types, whether columns were PKS or Fks and allowed to be null. Time to create some tables - but not in my database, please! Give the command use cs_YOU; where you is replaced by your mysql/UNB username Do a select command to see the PRODUCT table plus one new column, computed as p_min+1: SELECT *, p_min+1 from CS_owen.PRODUCT; Create a table as the result (see p 373 in the textbook): create table mytable as SELECT *, p_min+1 from cs_owen.PRODUCT; now use "describe" to see if the new table you have created has inherited the PK and FK. Also, what is the type of the new column? Screenshot. clean up the mess: DROP TABLE mytable; 615 V_CODE V NAME V_CONTACT V_AREACODE V_PHONE V_STATE V_ORDER 21225 Bryson, Inc Smithson 615 223-3234 TN Y 21226 Superloo, Inc. Fushing 904 2158995 R. N 21231 DE Supply Singh 615 225-3245 TN Y 21344 Gomer Bros. Ortega 889-2546 KY N 22567 Dome Supply Smith 901 678-1419 GA N 23119 Randsets Ltd. Anderson 901 678-3998 GA Y 24004 Bradman Bros. Browning 615 228-1410 TN N 24288 ORDVA, Inc. Hakford 615 898-1234 TN Y 25443 BBK, Inc. Smith 904 227-0093 F N 25501 Damal Supplies Smythe 615 890-3529 TN N 25595 Rubicon Systems Orton 904 456-0092 Y P_MIN P_QOH 8 32 5 18 15 23 15 12 8 5 5 8 6 5 P_CODE 11QER/31 13-02/P2 14-Q1/L3 1546-QQ2 1558-QW1 2232/QTY 2232/QWE 2238/QPD 23109-HB 23114-AA 54778-2T 89-WRE-Q PVC23DRT SM-18277 SW-23116 WR3/TT3 P_DESCRIPT P_INDATE Power painter, 15 psl., 3-nozzle 2017-11-03 00:00:00 7.25-in. pwr. saw blade 2017-12-13 00:00:00 9.00-in. pwr. saw blade 2017-11-13 00:00:00 Hrd. cloth, 1/4-in., 2x50 2018-01-15 00:00:00 Hrd. doth, 1/2-in., 3x50 2018-01-15 00:00:00 B&D jigsaw, 12-in. blade 2017-12-30 00:00:00 B&D jigsaw, 8-in. blade 2017-12-24 00:00:00 B&D cordless drill, 1/2-in. 2018-01-20 00:00:00 Claw hammer 2018-01-20 00:00:00 Sledge hammer, 12 lb. 2018-01-02 00:00:00 Rat-tail file, 1/8-in. fine 2017-12-15 00:00:00 Hicut chain saw, 16 in. 2018-02-07 00:00:00 PVC pipe, 3.5-in., 8-ft 2018-02-20 00:00:00 1.25-in. metal screw, 25 2018-03-01 00:00:00 2.5-in. wd. screw, 50 2018-02-24 00:00:00 Steel matting, 4x8x1/6, .5" m... 2018-01-17 00:00:00 12 5 P PRICE 109.99 14.99 17.49 39.95 43.99 109.92 99.87 38.95 9.95 14.40 4.99 256.99 5.87 6.99 8.45 119.95 P_DISCOUNT V_CODE 0.00 25595 0.05 21344 0.00 21344 0.00 23119 0.00 23119 0.05 24288 0.05 24288 0.05 25595 0.10 21225 0.05 NULL 0.00 21344 0.05 24288 0.00 NULL 0.00 21225 0.00 21231 0.10 25595 23 10 5 8 43 20 11 188 172 237 5 75 75 100 5 18 ATTRIBUTE NAME SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE INV_NUM 211347 211347 211347 211348 211349 PROD_NUM AA-E3422QW QD-300932X RU-995748G AA-E3422QW GH-778345P SALE_DATE 15-Jan-2018 15-Jan-2018 15-Jan-2018 15-Jan-2018 16-Jan-2018 PROD_LABEL Rotary sander Band saw 0.25-in. drill bit Rotary sander Power drill VEND_CODE 211 211 309 211 157 VEND_NAME NeverFail, Inc. NeverFail, Inc. BeGood, Inc. NeverFail, Inc. ToughGo, Inc. QUANT_SOLD 1 8 1 2 1 PROD_PRICE $49.95 $3.45 $39.99 $49.95 $87.75 INV_NUMBER CUS_CODE 1001 10014 1002 10011 1003 10012 1004 10011 1005 10018 1006 10014 1007 10015 1008 10011 INV_DATE 2018-01-16 00:00:00 2018-01-16 00:00:00 2018-01-16 00:00:00 2018-01-17 00:00:00 2018-01-17 00:00:00 2018-01-17 00:00:00 2018-01-17 00:00:00 2018-01-17 00:00:00 NULL NULL NULL 6. Let's look at some schema info from the PRODUCT table: describe PRODUCT; Look at the column types, whether columns were PKS or Fks and allowed to be null. Time to create some tables - but not in my database, please! Give the command use cs_YOU; where you is replaced by your mysql/UNB username Do a select command to see the PRODUCT table plus one new column, computed as p_min+1: SELECT *, p_min+1 from CS_owen.PRODUCT; Create a table as the result (see p 373 in the textbook): create table mytable as SELECT *, p_min+1 from cs_owen.PRODUCT; now use "describe" to see if the new table you have created has inherited the PK and FK. Also, what is the type of the new column? Screenshot. clean up the mess: DROP TABLE mytable; 615 V_CODE V NAME V_CONTACT V_AREACODE V_PHONE V_STATE V_ORDER 21225 Bryson, Inc Smithson 615 223-3234 TN Y 21226 Superloo, Inc. Fushing 904 2158995 R. N 21231 DE Supply Singh 615 225-3245 TN Y 21344 Gomer Bros. Ortega 889-2546 KY N 22567 Dome Supply Smith 901 678-1419 GA N 23119 Randsets Ltd. Anderson 901 678-3998 GA Y 24004 Bradman Bros. Browning 615 228-1410 TN N 24288 ORDVA, Inc. Hakford 615 898-1234 TN Y 25443 BBK, Inc. Smith 904 227-0093 F N 25501 Damal Supplies Smythe 615 890-3529 TN N 25595 Rubicon Systems Orton 904 456-0092 Y P_MIN P_QOH 8 32 5 18 15 23 15 12 8 5 5 8 6 5 P_CODE 11QER/31 13-02/P2 14-Q1/L3 1546-QQ2 1558-QW1 2232/QTY 2232/QWE 2238/QPD 23109-HB 23114-AA 54778-2T 89-WRE-Q PVC23DRT SM-18277 SW-23116 WR3/TT3 P_DESCRIPT P_INDATE Power painter, 15 psl., 3-nozzle 2017-11-03 00:00:00 7.25-in. pwr. saw blade 2017-12-13 00:00:00 9.00-in. pwr. saw blade 2017-11-13 00:00:00 Hrd. cloth, 1/4-in., 2x50 2018-01-15 00:00:00 Hrd. doth, 1/2-in., 3x50 2018-01-15 00:00:00 B&D jigsaw, 12-in. blade 2017-12-30 00:00:00 B&D jigsaw, 8-in. blade 2017-12-24 00:00:00 B&D cordless drill, 1/2-in. 2018-01-20 00:00:00 Claw hammer 2018-01-20 00:00:00 Sledge hammer, 12 lb. 2018-01-02 00:00:00 Rat-tail file, 1/8-in. fine 2017-12-15 00:00:00 Hicut chain saw, 16 in. 2018-02-07 00:00:00 PVC pipe, 3.5-in., 8-ft 2018-02-20 00:00:00 1.25-in. metal screw, 25 2018-03-01 00:00:00 2.5-in. wd. screw, 50 2018-02-24 00:00:00 Steel matting, 4x8x1/6, .5" m... 2018-01-17 00:00:00 12 5 P PRICE 109.99 14.99 17.49 39.95 43.99 109.92 99.87 38.95 9.95 14.40 4.99 256.99 5.87 6.99 8.45 119.95 P_DISCOUNT V_CODE 0.00 25595 0.05 21344 0.00 21344 0.00 23119 0.00 23119 0.05 24288 0.05 24288 0.05 25595 0.10 21225 0.05 NULL 0.00 21344 0.05 24288 0.00 NULL 0.00 21225 0.00 21231 0.10 25595 23 10 5 8 43 20 11 188 172 237 5 75 75 100 5 18 ATTRIBUTE NAME SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE INV_NUM 211347 211347 211347 211348 211349 PROD_NUM AA-E3422QW QD-300932X RU-995748G AA-E3422QW GH-778345P SALE_DATE 15-Jan-2018 15-Jan-2018 15-Jan-2018 15-Jan-2018 16-Jan-2018 PROD_LABEL Rotary sander Band saw 0.25-in. drill bit Rotary sander Power drill VEND_CODE 211 211 309 211 157 VEND_NAME NeverFail, Inc. NeverFail, Inc. BeGood, Inc. NeverFail, Inc. ToughGo, Inc. QUANT_SOLD 1 8 1 2 1 PROD_PRICE $49.95 $3.45 $39.99 $49.95 $87.75 INV_NUMBER CUS_CODE 1001 10014 1002 10011 1003 10012 1004 10011 1005 10018 1006 10014 1007 10015 1008 10011 INV_DATE 2018-01-16 00:00:00 2018-01-16 00:00:00 2018-01-16 00:00:00 2018-01-17 00:00:00 2018-01-17 00:00:00 2018-01-17 00:00:00 2018-01-17 00:00:00 2018-01-17 00:00:00 NULL NULL NULL

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

FNIE Ltd is a company specializing in the import of alcohol. It has a warehouse based on the Rungis International Market south of Paris (rue du Pont des Halles, 94550 Chevilly-Larue). The society...

MATHEMATICS FOR MACHINE LEARNING Marc Peter Deisenroth A. Aldo Faisal Cheng Soon Ong Contents Foreword 1 Part I Mathematical Foundations 9 1 Introduction and Motivation 11 1.1 Finding Words for...

The best definition for nonparametric statistics I can think of is when data does not fit inside the normal parameters of a normal distribution, it calls for the use of this statistical method....

I have problems understanding this case study for database. can someone help me solve this. Deliverables: 1. Create a list with the main business rules 2. Identify the main Entity types and their...

Set Student Name: 1. Describe the relationship between two variables that have a correlation coefficient value: a. Near -1 b. Near 0 c. Near 1 2. Data was collected where a weightlifter was asked to...

What is the difference between MouseListener and MouseAdapter? [3 marks] (b) Via suitable HTML, the compiled version of the following Java code is presented to the appletviewer application: import...

ID Salary 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 65.1 27 36.1 61.4 46.6 73.3 39.7 23.2 74.6 22.8 23.4 62 40.7 23 24 51.1...

CIS 205 Final Project Summer 2018 The final assignment consists of separating a database project into the phases that were outline during the semester. The project should be completed with the...

Instuctor's Annotated Edition TENTH EDITION Understandable Statistics Concepts and Methods Charles Henry Brase Regis University Corrinne Pellillo Brase Arapahoe Community College Australia Brazil...

Demand and Supply Discussion Question: Applications-Ubereconomics Please read the article below and respond to the follow-up question: Why Uber Is an Economist's Dream Does 'surge pricing'...

Demand and Supply Discussion Question: Applications-Ubereconomics Please read the article below and respond to the follow-up question: Using Big Data to Estimate Consumer Surplus: The Case of Uber...

5. Give the corresponding formula for the area of a sector when the angle is measured in degrees.

You are an investor in small businesses, and you have three business plans on your desk. Which of the following potential business owners do you think would be the best bet for an investment (if you...

where on Form 4 7 9 7 will a taxpayer who sold deptreciale real business property at a loss after holding it long term first report the amount of the loss

4 3 . Evaluate the role of resilience engineering principles in designing adaptive safety permit systems capable of responding to dynamic environmental, operational, and socio - economic factors.

If the tax rate is 40 percent, compute the beforetax real interest rate and the after-tax real interest rate in each of the following cases. a. The nominal interest rate is 10 percent and the...

Assume that the reserve requirement is 20%. Also assume that banks do not hold excess reserves and there is no cash held by the public. The Federal Reserve decides that it wants to expand the money...

It is often suggested that the Federal Reserve try to achieve zero inflation. If we assume that velocity is constant, does this zero-inflation goal require that the rate of money growth equal zero?...