Write a SQL statement to INSERT five records to each table. SQL commands must ru

Question

Write a SQL statement to INSERT five records to each table. SQL commands must run correct.

CREATE TABLE Season ( Season_id int PRIMARY KEY, Type_of_Season varchar(255), Color varchar(255), Size_name varchar(255), Supplier varchar(255));

CREATE TABLE Price ( Item_id int PRIMARY KEY, Size_name varchar(255), Color varchar(255), Product_id int, Supplier varchar(255) );

CREATE TABLE Clothing ( Product_id int PRIMARY KEY, Size_name varchar(255), Name varchar(255), Supplier varchar(255), Type_of_season varchar(255) );

CREATE TABLE Shoes ( Product_id int PRIMARY KEY, Size_name varchar(255), Type varchar(255), Supplier varchar(255), Name varchar(255) );

CREATE TABLE Sizes ( Size_id int PRIMARY KEY, Size_name varchar(255), Color varchar(255), Supplier varchar(255), Product_id int );

Explanation / Answer

Season Table

INSERT INTO Season (Season_id,Type_of_Season,Color,Size_name,Supplier)
VALUES (101,'winter','black','small','supone');

INSERT INTO Season (Season_id,Type_of_Season,Color,Size_name,Supplier)
VALUES (101,'winter','blue','small','supone');

INSERT INTO Season (Season_id,Type_of_Season,Color,Size_name,Supplier)
VALUES (102,'Rainy','blue','small','suptwo');

INSERT INTO Season (Season_id,Type_of_Season,Color,Size_name,Supplier)
VALUES (103,'Summer','white','large','supthree');

INSERT INTO Season (Season_id,Type_of_Season,Color,Size_name,Supplier)
VALUES (103,'Summer','Green','large','supthree');

______________________________________________________

Price Table

INSERT INTO Price (Item_id,Size_name,Color,Prodcut_id,Supplier,Type_of_Season)
VALUES (111,'small','red','xx89','supone','rainy');
INSERT INTO Price (Item_id,Size_name,Color,Prodcut_id,Supplier,Type_of_Season)
VALUES (112,'small','black','xx88','supone','rainy');
INSERT INTO Price (Item_id,Size_name,Color,Prodcut_id,Supplier,Type_of_Season)
VALUES (113,'xl','white','xx90','suptwo','winter');
INSERT INTO Price (Item_id,Size_name,Color,Prodcut_id,Supplier,Type_of_Season)
VALUES (116,'small','white','xx67','supone','summer');
INSERT INTO Price (Item_id,Size_name,Color,Prodcut_id,Supplier,Type_of_Season)
VALUES (117,'small','yellow','xx96','suptwo','summer');

_________________________________________________________

Clothing Table

Insert into Clothing ( Product_id Size_name, Name, Supplier , Type_of_season )values
(111,'small','Shirt','supone','winter');
Insert into Clothing ( Product_id Size_name, Name, Supplier , Type_of_season )values
(112,'large','T-shirt','supone','winter');
Insert into Clothing ( Product_id Size_name, Name, Supplier , Type_of_season )values
(113,'small','shirt','supone','Rainy');
Insert into Clothing ( Product_id Size_name, Name, Supplier , Type_of_season )values
(114,'XL','short shirt','suptwo','summer');
Insert into Clothing ( Product_id Size_name, Name, Supplier , Type_of_season )values
(115,'XXL','Longshirt','suptwo','summer');

_______________________________________________________

Shoes Table

Insert into Shoes ( Product_id, Size_name , Type , Supplier , Name )
values(550,'small','running shoe','supone','bata');
Insert into Shoes ( Product_id, Size_name , Type , Supplier , Name )
values(551,'small','office','supone','bata');
Insert into Shoes ( Product_id, Size_name , Type , Supplier , Name )
values(552,'Medium','Casual','suptwo','Ultra');
Insert into Shoes ( Product_id, Size_name , Type , Supplier , Name )
values(553,'Large','Casual','supthree','pretty');
Insert into Shoes ( Product_id, Size_name , Type , Supplier , Name )
values(555,'small','school','supthree','tough');

__________________________________________________________

Sizes table

-----------------------

Insert into Sizes ( Size_id, Size_name , Color, Supplier, Product_id)
values(101,'small','black','supone',550);

Insert into Sizes ( Size_id, Size_name , Color, Supplier, Product_id)
values(102,'small','white','suptwo',551);

Insert into Sizes ( Size_id, Size_name , Color, Supplier, Product_id)
values(103,'Medium','Yellow','suptwo',552);
Insert into Sizes ( Size_id, Size_name , Color, Supplier, Product_id)
values(104,'Large','Yellow','suptwo',553);

Insert into Sizes ( Size_id, Size_name , Color, Supplier, Product_id)
values(105,'XXL','white','supthree',554);

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.