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

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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!