Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Exercise 6.5.1: Write the following database modifications, based on the database schema Product (maker, model, type) PC(model, speed, ram, hd, price) Laptop(model, speed, ram, hd,

image text in transcribed
Exercise 6.5.1: Write the following database modifications, based on the database schema Product (maker, model, type) PC(model, speed, ram, hd, price) Laptop(model, speed, ram, hd, screen, price) Printer(model, color, type, price) of Exercise 2.4.1. Describe the effect of the modifications on the data of that exercise. 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. I b) Insert the facts that for every PC there is a laptop with the same manufacturer, speed, RAM, and hard disk, a 17 -inch screen, a model number 1100 greater, and a price $500 more. c) Delete all PC's with less than 100 gigabytes of hard disk. d) Delete all laptops made by a manufacturer that doesn't make printers. e) Manufacturer A buys manufacturer B. Change all products made by B so they are now made by A. f) 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.)

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

Students also viewed these Databases questions

Question

10. Describe the relationship between communication and power.

Answered: 1 week ago