create table Inventory( I_FlowerNumber number , I_Location varchar(20), I_Condit
ID: 3889847 • Letter: C
Question
create table Inventory( I_FlowerNumber number , I_Location varchar(20), I_Condition varchar(20), I_Search varchar(40),I_Delete varchar(20), I_Add number,I_Quantity number,PRIMARY KEY (I_FlowerNumber));
create table vendor (V_VendorID VARCHAR(20) ,V_PhoneNumber NUMBER, V_Address VARCHAR(20), V_DirectToStore VARCHAR(10), V_Status VARCHAR(5), V_LastUpdatedBy DATE, V_Password VARCHAR(10), V_LasteUpdateTime TIMESTAMP, PRIMARY KEY(V_VendorID ) );
CREATE TABLE purchase_order (
order_number int NOT NULL,
order_name char(50) NOT NULL,
customer_address char(50),
customer_zip int, customer_city char (50),
order_total varchar(50),
CONSTRAINT purchase_order_pk PRIMARY KEY (order_number) );
I need to create Five to ten test records for each assigned table:
Explanation / Answer
I am leaving "" unfilled so that you will enter your desired data. Run these queries to insert data into your table.
**Inventory table
insert into Inventory(I_FlowerNumber, I_Location, I_Condition, I_Search, I_Delete , I_Add , I_Quantity) values (1, '', '', '', '', 49, 63);
insert into Inventory(I_FlowerNumber, I_Location, I_Condition, I_Search, I_Delete , I_Add , I_Quantity) values (2, '', '', '', '', 56, 71);
insert into Inventory(I_FlowerNumber, I_Location, I_Condition, I_Search, I_Delete , I_Add , I_Quantity) values (3, '', '', '', '', 68, 40);
insert into Inventory(I_FlowerNumber, I_Location, I_Condition, I_Search, I_Delete , I_Add , I_Quantity) values (4, '', '', '', '', 48, 95);
insert into Inventory(I_FlowerNumber, I_Location, I_Condition, I_Search, I_Delete , I_Add , I_Quantity) values (5, '', '', '', '', 12, 76);
**vendor table
insert into vendor(V_VendorID , V_PhoneNumber , V_Address , V_DirectToStore, V_Status , V_LastUpdatedBy, V_Password, V_LasteUpdateTime) values ('', 1, '', '', '', DATE '11/12/2016', '', CURRENT_TIMESTAMP);
insert into vendor(V_VendorID , V_PhoneNumber , V_Address , V_DirectToStore, V_Status , V_LastUpdatedBy, V_Password, V_LasteUpdateTime) values ('', 73, '', '', '', DATE '11/28/2016', '', CURRENT_TIMESTAMP);
insert into vendor(V_VendorID , V_PhoneNumber , V_Address , V_DirectToStore, V_Status , V_LastUpdatedBy, V_Password, V_LasteUpdateTime) values ('', 58, '', '', '', DATE '6/26/2017', '', CURRENT_TIMESTAMP);
insert into vendor(V_VendorID , V_PhoneNumber , V_Address , V_DirectToStore, V_Status , V_LastUpdatedBy, V_Password, V_LasteUpdateTime) values ('', 5, '', '', '', DATE '4/27/2017', '', CURRENT_TIMESTAMP);
insert into vendor(V_VendorID , V_PhoneNumber , V_Address , V_DirectToStore, V_Status , V_LastUpdatedBy, V_Password, V_LasteUpdateTime) values ('', 79, '', '', '', DATE '7/24/2017', '', CURRENT_TIMESTAMP);
insert into vendor(V_VendorID , V_PhoneNumber , V_Address , V_DirectToStore, V_Status , V_LastUpdatedBy, V_Password, V_LasteUpdateTime) values ('', 59, '', '', '', DATE '1/9/2017', '', CURRENT_TIMESTAMP);
insert into vendor(V_VendorID , V_PhoneNumber , V_Address , V_DirectToStore, V_Status , V_LastUpdatedBy, V_Password, V_LasteUpdateTime) values ('', 43, '', '', '', DATE '9/23/2016', '', CURRENT_TIMESTAMP);
**purchase_order table
insert into purchase_order (order_number, order_name, customer_address , customer_zip, customer_city , order_total) values (1, '', '', 88, '', '');
insert into purchase_order (order_number, order_name, customer_address , customer_zip, customer_city , order_total) values (2, '', '', 28, '', '');
insert into purchase_order (order_number, order_name, customer_address , customer_zip, customer_city , order_total) values (3, '', '', 43, '', '');
insert into purchase_order (order_number, order_name, customer_address , customer_zip, customer_city , order_total) values (4, '', '', 9, '', '');
insert into purchase_order (order_number, order_name, customer_address , customer_zip, customer_city , order_total) values (5, '', '', 8, '', '');
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.