subject

Consider the following database schema that is part of a larger database and stores information about electronic products (that in our case can be either PC, Laptop or Printer.) Product (maker, model, type) PC (model, speed, ram, hdd, price) Laptop (model, speed, ram, hdd, screen, price) Printer (model, color, type, price) The Product relation gives the manufacturer, model number and type (PC/laptop/printer) of various products. The PC relation gives for each model number that is a PC, the speed (of the processor, in gigahertz), the amount of RAM (in GB), the size of hard disk (in GB), and the price. The Laptop relation is similar, with screen size included. The Printer relation records whether it is a color printer or not (Yes/No), the type (laser/ink-jet), and the price. Write the following queries in Relational Algebra: 1. Find the Laptop models for the Laptops that have at least 8 GBs of RAM. 2. Find the manufacturers that make laser printers. 3. Find the manufacturers that make PCs but not Laptops. 4. Find the manufacturer(s) of the cheapest Laptop(s) (smaller price)

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 23.06.2019 04:31
Type the correct answer in the box. spell all words correctly. the managing director of a company sends a christmas greeting to all his employees through the company email. which type of network does he use? he uses an
Answers: 1
question
Computers and Technology, 24.06.2019 01:00
Me if you do then you get 10 points and brainliest
Answers: 1
question
Computers and Technology, 24.06.2019 10:20
Identify the publisher in this citation: carter,alan.a guide to entrepreneurship.new york: river’2008.print.
Answers: 3
question
Computers and Technology, 24.06.2019 16:00
Read these lines from beowulf.often scyld scefing seized mead-benches from enemytroops, from many a clan, he terrified warriors, even thoughfirst he was found a waif, best explains why the author includes this information in theexposition? a. to emphasize that a hero must learn to be fierceb. to remember the famous story of a popular heroc. to express sadness about losing the old heroesd. to see whether people still respect the old heroes
Answers: 1
You know the right answer?
Consider the following database schema that is part of a larger database and stores information abou...
Questions
question
Mathematics, 11.01.2021 01:00
question
Mathematics, 11.01.2021 01:00
question
Physics, 11.01.2021 01:00
question
SAT, 11.01.2021 01:00
question
Computers and Technology, 11.01.2021 01:00
Questions on the website: 13722363