Product ID is suppose to be Primary Key and Foreign Key, how can this be fixed? 27
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
27 |); 28 29 CREATE TABLE INCLUDES ( 30 ProductID 31 TID 32 Quantity 33 34 CONSTRAINT INCLUDES PK PRIMARY KEY (ProductID, TID), 35 CONSTRAINT INCLUDES FK FOREIGN KEY (TID) 36 REFERENCES SALES_TRANSACTIONS (TID) 37 % ); 38 39 CREATE TABLE PRODUCT ( 40 ProductID 46 CHAR(4) CHAR (6) INT ProductName ProductPrice CHAR (4) CHAR (2) NOT NULL, NOT NULL, NUMERIC (4,2) NOT NULL, NOT NULL, NOT NULL, 41 42 43 VendorID 44 CategoryID 45 CONSTRAINT PRODUCT_PK PRIMARY KEY (ProductID), CONSTRAINT PRODUCT_FK FOREIGN KEY (ProductID) REFERENCES INCLUDES (ProductID) CHAR (3) CHAR (3) NOT NULL, NOT NULL, NOT NULL, 47 48 49 50 51 CREATE TABLE CUSTOMER ( wwwm 52 Customer ID here are no primary or candidate keys in the referenced table 'INCLUDES' that match the referencing column list in the foreign key 'PRODUCT_FK'. CHAR(10) NOT NULL, Messages Mag 102, Level 15, State 1, Line 47 Incorrect syntax near ')'. Completion time: 2022-11-26T23:25:16.8141626-05:00 27 |); 28 29 CREATE TABLE INCLUDES ( 30 ProductID 31 TID 32 Quantity 33 34 CONSTRAINT INCLUDES PK PRIMARY KEY (ProductID, TID), 35 CONSTRAINT INCLUDES FK FOREIGN KEY (TID) 36 REFERENCES SALES_TRANSACTIONS (TID) 37 % ); 38 39 CREATE TABLE PRODUCT ( 40 ProductID 46 CHAR(4) CHAR (6) INT ProductName ProductPrice CHAR (4) CHAR (2) NOT NULL, NOT NULL, NUMERIC (4,2) NOT NULL, NOT NULL, NOT NULL, 41 42 43 VendorID 44 CategoryID 45 CONSTRAINT PRODUCT_PK PRIMARY KEY (ProductID), CONSTRAINT PRODUCT_FK FOREIGN KEY (ProductID) REFERENCES INCLUDES (ProductID) CHAR (3) CHAR (3) NOT NULL, NOT NULL, NOT NULL, 47 48 49 50 51 CREATE TABLE CUSTOMER ( wwwm 52 Customer ID here are no primary or candidate keys in the referenced table 'INCLUDES' that match the referencing column list in the foreign key 'PRODUCT_FK'. CHAR(10) NOT NULL, Messages Mag 102, Level 15, State 1, Line 47 Incorrect syntax near ')'. Completion time: 2022-11-26T23:25:16.8141626-05:00
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these databases questions
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Knowledge Check 01 A company is in its first month of operations. Supplies worth $4,000 were purchased on January 5. At the end of the month supplies worth $3,000 were in hand. What adjusting entry...
-
How do your answers to Problems 27(a)-(e) compare with the corresponding calculations in the discussion (after Example 1) of the area under y=2x using right hand endpoints?
-
a. In each of the following independent problems, design an unbiased random sampling plan, using an electronic spreadsheet or a random number generator program. The plan should include defining the...
-
The horizontal portion of the wire in Figure P28.76 has a length \(\ell=0.100 \mathrm{~m}\), and position \(\mathrm{P}\) is a perpendicular distance \(d=30.0 \mathrm{~mm}\) above the center of the...
-
After graduating from dental school two years ago, Dr. Lauren Farish purchased the dental practice of a long-time dentist who was retiring. In January of this year she had to replace the outdated...
-
In the space provided, 150- to 350-word summary of your financial analysis from Part 2: Financial Ratio Calculations. Include the following in your summary: Make final recommendations as to whether...
-
Imagine that instead of pipetting up to 1 mL of the 50-ppm stock solution of nitrite, you pipetted between 10-50 mL of the stock solution to make your standard solutions. What would your calibration...
-
Estimate the size of the motor necessary to pump a lean oil to the top of an absorption tower operating at a pressure of 445 kPa. The oil is to be pumped from an open tank with a liquid level 3 m...
-
The Priority Queue Class You will use a priority queue of patients to determine the order that patients are seen by the doctor. Before writing the code to simulate the emergency room, you should...
-
When we ask the question "Why Does College Cost So Much? we really mean (choose the one best answer): Why is it so expensive to operate a college? Why does tuition keep Increasing every year? Why is...
-
Consider the scheduling algorithm in the Solaris operating system for time-sharing threads. What is the time quantum (in milliseconds) for a thread with priority 15? With priority 40? Assume that a...
-
The German auto giant, Volkswagen, has chosen St. Thomas, Ontario as the site of its first battery factory outside of Europe. (Globe and Mail, March 2023). (10 Marks) Identify the elements of...
-
What were the average real hourly wage and employment rates in 1979 and 1995 in the retail trade and mining and logging industries? What were the percentage changes in the wage rate and employment...
-
For the standard normal random variable z, find z for each situation. If required, round your answers to two decimal places. For those boxes in which you must enter subtractive or negative numbers...
-
APC16550D UART has a clock running at18.432 MHz and its baud rate is set to 2000.Determine the HEX contents of its DLM and DLL registers. Please can you explain step by step and in detail how you get...
-
Bea Jones (age 32) moved from Texas to Florida in December 2011. She lives at 654 Ocean Way, Gulfport, FL 33707. Bea's Social Security number is 466-78-7359 and she is single. Her earnings and income...
-
Emily Jackson (Social Security number 765-12-4326) and James Stewart (Social Security number 466-74-9932) are partners in a partnership that owns and operates a barber shop. The partnership's first...
-
During the 2012 tax year, Irma incurred the following expenses: Union dues..............................................................$275 Tax return preparation...
-
A slot machine is a gambling device that the user inserts money into and then pulls a lever (or presses a button). The slot machine then displays a set of random images. If two or more of the images...
-
Design a number guessing game program. The program should generate a random number and then ask the user to guess the number. Each time the user enters his or her guess, the program should indicate...
-
As an illustration of the difficulty in identifying monopolies, try to decide which of the following are monopolies: a train operating company; your local evening newspaper; the village hairdresser;...
Study smarter with the SolutionInn App