subject

Q.6. INSERT, DELETE and UPDATE Write the following database modifications in SQL. a) Using two INSERT statements, store in the database the fact that PC model 1100 is made by manufacturer C, has speed 3.2, RAM 1024, hard disk 180, and sells for $2499. b) Delete all PC ’s with less than 100 gigabytes of hard disk. c) Delete all laptops made by a manufacturer that doesn’t make printers. d) Manufacturer A buys manufacturer B. Change all products made by B so they are now made by A. e) For each PC, double the amount of RAM and add 60 gigabytes to the amount of hard disk. (Remember that several attributes can be changed by one UPDATE statement.)

ansver
Answers: 3

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 01:00
How can a broadcast station be received through cable and satellite systems?
Answers: 1
question
Computers and Technology, 22.06.2019 10:50
Write a 3-4 page apa formatted paper comparing your organization’s it strategy with the best practices outlined in your course text. content should include, but not be limited to: developing and delivering on the it value, developing it strategy for the business value and linking it to business metrics. your paper should include an abstract and a conclusion and a reference page with 3-5 references
Answers: 1
question
Computers and Technology, 22.06.2019 21:10
Dameas communication challenge is due to which factor
Answers: 2
question
Computers and Technology, 23.06.2019 02:30
Experimental data that is expressed using numbers is said to be
Answers: 1
You know the right answer?
Q.6. INSERT, DELETE and UPDATE Write the following database modifications in SQL. a) Using two INSER...
Questions
question
Mathematics, 21.04.2021 22:00
question
Mathematics, 21.04.2021 22:00
question
Chemistry, 21.04.2021 22:00
question
Mathematics, 21.04.2021 22:00
question
Mathematics, 21.04.2021 22:00
question
Mathematics, 21.04.2021 22:00