Computers and Technology, 18.02.2022 14:10 drodriguez2324

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)

Answers: 2

Show answers

Another question on Computers and Technology

Computers and Technology, 23.06.2019 22:30

The output voltage of a power supply is assumed to be normally distributed. sixteen observations are taken at random on voltage are as follows: 10.35, 9.30, 10.00, 9.96, 11.65, 12.00, 11.25, 9.58, 11.54, 9.95, 10.28, 8.37, 10.44, 9.25, 9.38, and 10.85

Answers: 1

Answer

Computers and Technology, 24.06.2019 01:00

What are two ways to access the options for scaling and page orientation? click the home tab, then click alignment, or click the file tab. click the file tab, then click print, or click the page layout tab. click the page layout tab, or click the review tab. click the review tab, or click the home tab?

Answers: 2

Answer

Computers and Technology, 24.06.2019 02:10

Which sentences describe the things you need to ensure while creating a sketch and a drawing? while an artistic or creative drawing is a creative expression, a technical drawing is an informative expression. you need to create accurate and neat drawings to convey accurate information. a technical drawing clearly conveys its meaning or information, and does not leave room for interpretation maintain a good speed while creating drawings

Answers: 1

Answer

Computers and Technology, 24.06.2019 14:00

When creating a field in a table, you must set the to determine what type of data the field can store. field property data type field type data property

Answers: 1

Answer

You know the right answer?

Consider the following database schema that is part of a larger database and stores information abou...

Questions