Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Given the tables have been created without foreign keys added, which of the following ALTER TABLE statements would create a foreign key on the category
Given the tables have been created without foreign keys added, which of the following ALTER TABLE statements would create a foreign key on the categoryid in the product table to reference the categoryid in the category table?
a
ALTER TABLE category
ADD CONSTRAINT fkproduct
FOREIGN KEY categoryid
REFERENCES product categoryid;
b
ALTER TABLE product
ADD CONSTRAINT fkproduct
FOREIGN KEY categoryid
REFERENCES category categoryid;
c
ALTER TABLE product
ADD CONSTRAINT
FOREIGN KEY categoryid
REFERENCES category categoryid;
d
ALTER TABLE product
ADD CONSTRAINT fkproduct
FOREIGN KEY category categoryid
REFERENCES categoryid;
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