![andy2461](/avatars/45299.jpg)
andy2461
04.03.2022 •
Computers and Technology
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.
Solved
Show answers
More tips
- H Horoscopes, Magic, Divination How to Cast a Love Spell on a Guy? Guide for Guys...
- S Style and Beauty Tricks and Tips: How to Get Rid of Freckles...
- H Health and Medicine How to perform artificial respiration?...
- C Computers and Internet How to Get Rid of Windows Genuine Check?...
- F Food and Cooking The Disease That Haunted Abraham Lincoln...
- S Style and Beauty How to Make Your Lips Fuller? Ideas and Tips for Beautiful Lips...
- S Style and Beauty How are artificial nails removed?...
- F Family and Home How to Sew Curtain Tapes: Best Tips from Professionals...
- F Family and Home How to Properly Use a Water Level?...
- L Legal consultation What Documents Are Required for a Russian Passport?...
Answers on questions: Computers and Technology
- C Computers and Technology Can anyone suggest a good Proxy Server? My dad is blocking EVERYTHING except school, we cant even search things up. I cant use the links the school sends me either. and it s not...
- P Physics 3. a block of mass m1=1.5 kg on an inclined plane of an angle of 12° is connected by a cord over a mass-less, frictionless pulley to a second block of a mass m2= 1.2 kg hanging...
- M Mathematics Lenght of the room is 20ft and the width is 12ft what is the perimeter...
- S Spanish I m looking for an answer in Spanish for this question. What outdoor activities do you like to do? Why do you enjoy those activities? What activities don t you like to do? Why?...
Ответ:
making his prices a little cheaper, customers like affordable stuff
Explanation: