Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Problem 2 (25 points) Consider the following excerpt from a database schema about an electronics seller. Product(company, model, type) Phone(model, cpu, ram, cellular_network, price) Headset(model,

image text in transcribed

Problem 2 (25 points) Consider the following excerpt from a database schema about an electronics seller. Product(company, model, type) Phone(model, cpu, ram, cellular_network, price) Headset(model, color, connection_method, price) Charger(model, color, plug_type, price) Give an expression in relational algebra for each of the following queries: 1. Which Phone models support 5g ? [5 points] 2. Which companies make phones with at least 8GB of RAM? [5 points] 3. Which manufacturers make phones but not headsets? [5 points] 4. What RAM size is present in at least two distinct phone models? [5 points] 5. Which company makes the most expensive charger? [ 5 points]

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

Nested Relations And Complex Objects In Databases Lncs 361

Authors: Serge Abiteboul ,Patrick C. Fischer ,Hans-Jorg Schek

1st Edition

3540511717, 978-3540511717

More Books

Students also viewed these Databases questions