Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. a) Using two INSERT statements, insert a new laptop into the database. The laptop should have model number 1200 ; be made by manufacturer

image text in transcribedimage text in transcribed

1. a) Using two INSERT statements, insert a new laptop into the database. The laptop should have model number 1200 ; be made by manufacturer E; have speed 2.5, 1024 RAM, a HD size of 100 , a screen size of 19.7, and cost $2100. b) Using a SELECT statement, confirm that your laptop has been added. (This can be very simple - just select the model number from an appropriate join of the Product and laptop tables.) 2. a) DELETE all PCs with less than 100 GB of hard disk space from all tables in which they appear. (You can use two DELETE statements here if you want.) b) Confirm that this is working correctly by selecting all of the elements of the pc table and then selecting all of the elements of the product table. 3. a) DELETE all printers made by each manufacturer that doesn't make laptops. (You can use two DELETE statements here if you want.) b) Confirm that this is working correctly by selecting all of the elements of the printer table and then selecting all of the elements of the product table. 4. a) Manufacturer A has bought out manufacturer B. Change all of the products that are made by B so that they're now made by maker A.. b) Confirm that this is working correctly by selecting all of the elements of the product table. 5. a) Using just one UPDATE, double the amount of RAM each PC has and add 60 GB to its hard disk. b) Confirm that this is working correctly by selecting all of the elements of the pc table. 6. a) For each laptop made by manufacturer B, add one inch to the screen size and subtract $100 from the price. b) Confirm that this is working correctly by selecting all of the elements of the laptop table. 7. a) INSERT the facts that for every PC, there is a laptop with the same maker, speed, RAM, and hd space, with a 17-inch screen, a model number 1100 larger than the corresponding PC's model number, and a price $300 less than the corresponding PC's price. This should be done with two INSERTs, and it should work regardless of which PCs are in the table. b) Confirm that this is working correctly by selecting all of the elements of the laptop table and then selecting all of the elements of the product table

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Databases DeMYSTiFieD

Authors: Andy Oppel

2nd Edition

0071747990, 978-0071747998

More Books

Students also viewed these Databases questions

Question

1. The evaluation results can be used to change the program.

Answered: 1 week ago

Question

5. To determine the financial benefits and costs of the program.

Answered: 1 week ago