Database System Concepts
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
Bartleby Related Questions Icon

Related questions

bartleby

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;
expand button
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
Check Mark
Knowledge Booster
Background pattern image
Computer Science
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
Recommended textbooks for you
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education