Question: 1. Create the relational database which includes 3 tables (Slide #10). Insert data to the database. You can make up data of your own. 2.

1. Create the relational database which includes
1. Create the relational database which includes
1. Create the relational database which includes 3 tables (Slide #10). Insert data to the database. You can make up data of your own. 2. Report all brown items that have been sold. 3. Report all brown items that have not been sold. CREATE TABLE sale saleno INTEGER, saledate DATE NOT NULL, saletext VARCHAR (50) PRIMARY KEY (saleno)); CREATE TABLE item( itemno INTEGER, itemname VARCHAR(30) NOT NULL, itemtype CHAR (1) NOT NULL, itemcolor VARCHAR(10), PRIMARY KEY (itemno)); CREATE TABLE lineitem( lineno INTEGER, lineaty INTEGER NOT NULL, lineprice DECIMAL (7,2) NOT NULL, saleno INTEGER, itemno INTEGER, PRIMARY KEY (lineno, saleno), CONSTRAINT fk_has_sale FOREIGN KEY (saleno) REFERENCES sale (saleno), CONSTRAINT fk_has_item FOREIGN KEY (itemno) REFERENCES item(itemno))

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 General Management Questions!