Question: What is true about the table includes? CREATE TABLE includes ( productid CHAR ( 3 ) NOT NULL, tid VARCHAR ( 8 ) NOT NULL,

What is true about the table includes?
CREATE TABLE includes
( productid CHAR(3) NOT NULL,
tid VARCHAR(8) NOT NULL,
quantity INT NOT NULL,
PRIMARY KEY (productid, tid),
FOREIGN KEY (productid) REFERENCES product(productid),
FOREIGN KEY (tid) REFERENCES salestransaction(tid));
The table includes columns which are optional
All of the column datatypes are character
The table has a composite primary key
Rows are uniquely identified by productid
 What is true about the table includes? CREATE TABLE includes (

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!