ITD 256 Exercise 5

docx

School

Northern Virginia Community College *

*We aren’t endorsed by this school

Course

256

Subject

Computer Science

Date

Dec 6, 2023

Type

docx

Pages

10

Uploaded by AmbassadorTrout2479

Report
Nusrat Jahan Professor Spiller ITD256 Exercise 5 Table 1 CREATE SCHEMA `exercise5` ; CREATE TABLE `exercise5`.`order` ( `order_num` INT NOT NULL, `order_date` DATE NULL, PRIMARY KEY (`order_num`)); ALTER TABLE `exercise5`.`order` ADD COLUMN `order_id` INT NOT NULL AFTER `order_date`, DROP PRIMARY KEY, ADD PRIMARY KEY (`order_id`); ; UPDATE `exercise5`.`order` SET `order_num` = ' 21608', `order_date` = '10/20/2010', `order_id` = '1001' WHERE (`order_id` = '0'); INSERT INTO `exercise5`.`order` (`order_num`, `order_date`, `order_id`) VALUES ('21610', '10/20/2010', '1002'); INSERT INTO `exercise5`.`order` (`order_num`, `order_date`, `order_id`) VALUES ('21610', '10/20/2010', '1003'); INSERT INTO `exercise5`.`order` (`order_num`, `order_date`, `order_id`) VALUES ('21613', '10/21/2010', '1004'); INSERT INTO `exercise5`.`order` (`order_num`, `order_date`, `order_id`) VALUES ('21614', '10/21/2010', '1005'); INSERT INTO `exercise5`.`order` (`order_num`, `order_date`, `order_id`) VALUES ('21617', '10/23/2010', '1006');
INSERT INTO `exercise5`.`order` (`order_num`, `order_date`, `order_id`) VALUES ('21617', '10/23/2010', '1007'); INSERT INTO `exercise5`.`order` (`order_num`, `order_date`, `order_id`) VALUES ('21619', '10/23/2010', '1008'); INSERT INTO `exercise5`.`order` (`order_num`, `order_date`, `order_id`) VALUES ('21523', '10/23/2010', '1009');
Table 2 CREATE TABLE `exercise5`.`parts` (
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
`part_num` VARCHAR(255) NOT NULL, `discription` VARCHAR(455) NULL, PRIMARY KEY (`part_num`)); INSERT INTO `exercise5`.`parts` (`part_num`, `description`) VALUES ('AT94', 'iron'); INSERT INTO `exercise5`.`parts` (`part_num`, `description`) VALUES ('DR93', 'gasrange'); INSERT INTO `exercise5`.`parts` (`part_num`, `description`) VALUES ('DW11', 'washer'); INSERT INTO `exercise5`.`parts` (`part_num`, `description`) VALUES ('KL62', 'dryer'); INSERT INTO `exercise5`.`parts` (`part_num`, `description`) VALUES ('KT03', 'dishwasher'); INSERT INTO `exercise5`.`parts` (`part_num`, `description`) VALUES ('PV06', 'homegym'); INSERT INTO `exercise5`.`parts` (`part_num`, `description`) VALUES ('DC52', 'microwaveoven'); INSERT INTO `exercise5`.`parts` (`part_num`, `description`) VALUES ('KV29', 'treadmill');
Table 3 CREATE TABLE `exercise5`.`partsname` ( `description` VARCHAR(225) NOT NULL, `no_order` INT NOT NULL, `quated_price` FLOAT NOT NULL, PRIMARY KEY (`description`)); INSERT INTO `exercise5`.`partsname` (`description`, `no_order`, `quated_price`) VALUES ('gasrange', '2', '495.00'); INSERT INTO `exercise5`.`partsname` (`description`, `no_order`, `quated_price`) VALUES ('washer', '1', '399.99'); INSERT INTO `exercise5`.`partsname` (`description`, `no_order`, `quated_price`) VALUES ('dryer', '4', '329.95'); INSERT INTO `exercise5`.`partsname` (`description`, `no_order`, `quated_price`) VALUES ('dishwasher', '2', '595.00'); INSERT INTO `exercise5`.`partsname` (`description`, `no_order`, `quated_price`) VALUES ('homegym', '2', '794.95'); INSERT INTO `exercise5`.`partsname` (`description`, `no_order`, `quated_price`) VALUES ('microwaveoven', '1', '150.00'); INSERT INTO `exercise5`.`partsname` (`description`, `no_order`, `quated_price`) VALUES ('treadmill', '2', '1290.00');
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Table 4 CREATE TABLE `exercise5`.`relation` ( `order_id` INT NOT NULL, `part_num` VARCHAR(45) NOT NULL, PRIMARY KEY (`order_id`, `part_num`)); INSERT INTO `exercise5`.`relation` (`order_id`, `part_num`) VALUES ('1001', 'at94'); INSERT INTO `exercise5`.`relation` (`order_id`, `part_num`) VALUES ('1002', 'dr93'); INSERT INTO `exercise5`.`relation` (`order_id`, `part_num`) VALUES ('1003', 'dw11'); INSERT INTO `exercise5`.`relation` (`order_id`, `part_num`) VALUES ('1004', 'kl62'); INSERT INTO `exercise5`.`relation` (`order_id`, `part_num`) VALUES ('1005', 'kt03'); INSERT INTO `exercise5`.`relation` (`order_id`, `part_num`) VALUES ('1006', 'bv06'); INSERT INTO `exercise5`.`relation` (`order_id`, `part_num`) VALUES ('1007', 'cd52'); INSERT INTO `exercise5`.`relation` (`order_id`, `part_num`) VALUES ('1008', 'kv29');
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help

Related Documents

cse160_checkin5.py
cse160_checkin4.py
cse160_checkin1.py
probtest May2021 v3.pdf
M05 Check your Knowledge Quiz.pdf
BrittanyA_4_1.docx
one.docx
Tutorial02_Ling300_pronouns (1).docx
Prepare Data For Exploration Weekly Challenge 1 (Part 2).docx
NP_EX16_2a_LevetteWhitlock_Report_1.xlsx
PROG8290 – Assignment 4.docx
2021 - 13 - ELAP 105 - Basic Code STUDENT Package 03.29.2023.pdf
Recommended textbooks for you
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
SEE MORE TEXTBOOKS