Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 manufacturer, model

image text in transcribed
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 manufacturer, model number and type PC, Laptop, or printer) of vanous products. We assume for convenience that model numbers are unique overall matters and product types .., model is the primary key). The PC relation gives for each model number that is PC the speed of the processor in gigahertz), the amount of RAM in megabyte) the site of the hard disk on gigabytes), and the prion. The Laptop relation is similar, except that the screensten inches) is so included. The Printer relation records for each printer model whether the printer produces color output(true) the process type (laser or inkjet typically and the price Wite the following no queries using the Product OB. price 5. They These PCs that have the F 7. should be listed 9. Fins Only OZ cuters All queries should be contained in a single plain text file with a selectension. Queries must be in the order about Dont forget to separate each query with a semi-colon Task 2(10550 points) 1.Write the relational algebra expression for each query Alt petric expression shodd be contained in a cingle plain text file with a pension. You can hand write them as well as long as they are legible enough 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 manufacturer, model number and type PC, Laptop, or printer) of vanous products. We assume for convenience that model numbers are unique overall matters and product types .., model is the primary key). The PC relation gives for each model number that is PC the speed of the processor in gigahertz), the amount of RAM in megabyte) the site of the hard disk on gigabytes), and the prion. The Laptop relation is similar, except that the screensten inches) is so included. The Printer relation records for each printer model whether the printer produces color output(true) the process type (laser or inkjet typically and the price Wite the following no queries using the Product OB. price 5. They These PCs that have the F 7. should be listed 9. Fins Only OZ cuters All queries should be contained in a single plain text file with a selectension. Queries must be in the order about Dont forget to separate each query with a semi-colon Task 2(10550 points) 1.Write the relational algebra expression for each query Alt petric expression shodd be contained in a cingle plain text file with a pension. You can hand write them as well as long as they are legible enough

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

Recommended Textbook for

Current Trends In Database Technology Edbt 2004 Workshops Edbt 2004 Workshops Phd Datax Pim P2panddb And Clustweb Heraklion Crete Greece March 2004 Revised Selected Papers Lncs 3268

Authors: Wolfgang Lindner ,Marco Mesiti ,Can Turker ,Yannis Tzitzikas ,Athena Vakali

2005th Edition

3540233059, 978-3540233053

More Books

Students also viewed these Databases questions