go --products table create a table CREATE TABLE Products ( ProductID INTEGER PRIMARY KEY, ModelNumber INTEGER, ModelName TEXT NOT NULL, ProductImage IMAGE, UnitCost INTEGER, Description TEXT NOT NULL, FOREIGN KEY(CategoryID) REFERENCES Categ ); Foreign key 'FK_Products_a42a460b5f04ceb87f28' references invalid column 'CategoryID' in referencing table 'Products'. -- insert some values INSERT INTO products VALUES (6 108 'Chrome' ge 'Book 3)

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
icon
Concept explainers
Question
100%

How can i fix this error its not going away and i have tryed everything

create a table
ECREATE TABLE Categories (
CategoryID INTEGER PRIMARY KEY,
CategoryName TEXT NOT NULL
);
insert some values
--
INSERT INTO Categories VALUES (1, 'stationary');
INSERT INTO Categories VALUES (2, 'ART');
INSERT INTO Categories VALUES (3, 'Books');
INSERT INTO Categories VALUES (4, 'Wine');
INSERT INTO Categories VALUES (5, 'Soap');
fetch some values
--
SELECT * FROM Categories;
go
E--products table
create a table
--
ECREATE TABLE Products (
ProductID INTEGER PRIMARY KEY,
ModelNumber INTEGER,
ModelName TEXT NOT NULL,
Product Image IMAGE,
UnitCost INTEGER,
Description TEXT NOT NULL,
FOREIGN KEY(CategoryID)
REFERENCES Categ
};
Foreign key 'FK_Products_a42a460b5f04ceb87f28' references invalid column 'CategoryID' in referencing table 'Products'.
insert some values
INSERT INTO products VALUES (6, 100, 'Chrome','',90, 'Book', 3);
INSERT INTO products VALUES (7, 101, 'Juice',
15,
'Pure Juice', 4);
INSERT INTO products VALUES (8, 102, 'stationary', ,50, 'office stationary',1);
INSERT INTO products VALUES (9, 103, 'Cleaner', ,33, 'Appliance Cleaner',5);
INSERT INTO products VALUES (10, 104, 'wood"," ,25, 'Oak Wood', 2);
fetch some values
--
SELECT * FROM products;
Transcribed Image Text:create a table ECREATE TABLE Categories ( CategoryID INTEGER PRIMARY KEY, CategoryName TEXT NOT NULL ); insert some values -- INSERT INTO Categories VALUES (1, 'stationary'); INSERT INTO Categories VALUES (2, 'ART'); INSERT INTO Categories VALUES (3, 'Books'); INSERT INTO Categories VALUES (4, 'Wine'); INSERT INTO Categories VALUES (5, 'Soap'); fetch some values -- SELECT * FROM Categories; go E--products table create a table -- ECREATE TABLE Products ( ProductID INTEGER PRIMARY KEY, ModelNumber INTEGER, ModelName TEXT NOT NULL, Product Image IMAGE, UnitCost INTEGER, Description TEXT NOT NULL, FOREIGN KEY(CategoryID) REFERENCES Categ }; Foreign key 'FK_Products_a42a460b5f04ceb87f28' references invalid column 'CategoryID' in referencing table 'Products'. insert some values INSERT INTO products VALUES (6, 100, 'Chrome','',90, 'Book', 3); INSERT INTO products VALUES (7, 101, 'Juice', 15, 'Pure Juice', 4); INSERT INTO products VALUES (8, 102, 'stationary', ,50, 'office stationary',1); INSERT INTO products VALUES (9, 103, 'Cleaner', ,33, 'Appliance Cleaner',5); INSERT INTO products VALUES (10, 104, 'wood"," ,25, 'Oak Wood', 2); fetch some values -- SELECT * FROM products;
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Query Syntax
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education