Computers and Technology, 04.03.2022 08:50 kasonlowery

Consider the database schema consists of four relations, whose schemas are: Product(maker, model, type)
PC(model, speed, ram, hd, price)
Laptop(model, speed, ram, hd, screen, price)
Printer(model, color, type, price)

The Product relation gives the manufacturer, model number and type (PC, laptop, or printer) of various products. We assume for convenience that model numbers are unique over all manufacturers and product types; that assumption is not realistic, and a real database would include a code for the manufacturer as part of the model number. The PC relation gives for each model number that is a PC the speed (of the processor, in gigahertz), the amount of RAM (in megabytes), the size of the hard disk (in gigabytes), and the price. The Laptop relation is similar, except that the screen size (in inches) is also included. The Printer relation records for each printer model whether the printer produces color output (true, if so), the process type (laser or ink-jet, typically), and the price.

Write the following declarations:
a. A suitable SQL query for building the relation Product.
b. A suitable SQL query for building the relation PC.
c. A suitable schema for relation Laptop.

Answers: 2

Show answers

Another question on Computers and Technology

Computers and Technology, 23.06.2019 00:10

Write a function so that the main0 code below can be replaced by the simpler code that calls function mphandminutes tomiles0. original main0 int main) l double milesperhour-70.0; double minutestraveled = 100.0; double hourstraveled; double milestraveled; hourstraveled = minutestraveled / 60.0; milestraveled = hourstraveled * milesperhour; cout < "miles" 2 using namespace std; 4 /* your solution goes here/ 6 int maino 1 test passed 7 double milesperhour 70.0 all tests passed 8 double minutestraveled 100.0; 10 cout < < "miles: " < < mphandminutestomiles(milesper-hour, minutestraveled) < < endl; 12 return 0; 13

Answers: 1

Answer

Computers and Technology, 24.06.2019 00:30

Match the sentence fragment in the first column with the appropriate ending in the second column. a little per favore?

Answers: 1

Answer

Computers and Technology, 24.06.2019 01:00

What shows the web address of the page that is currently displayed in the workspace? status window toolbar location bar internet box

Answers: 1

Answer

Computers and Technology, 24.06.2019 01:30

Could you find out how im still getting an 83 percent on this in edhesive a = input("enter an animal: ") s = input ("enter a sound: ") e = "e-i-e-i-o" print ("old macdonald had a farm, " + e) print ("and on his farm he had a " + a + "," + e) print ("with a " + s + "-" + s + " here and a " + s + "-" + s + " there") print ("here a " + s+ " there a " + s) print ("everywhere a " + s + "-" + s ) print ("old macdonald had a farm, " + e)

Answers: 2

Answer

You know the right answer?

Consider the database schema consists of four relations, whose schemas are: Product(maker, model,...

Questions