Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

( 8 points ) Take the following schema and instance into consideration. Suppliers ( sid , sname, city ) Parts ( pid , pname, color

(8 points) Take the following schema and instance into consideration.
Suppliers(sid, sname, city)
Parts(pid, pname, color)
Catalog(sid, pid, cost)
\table[[\table[[Suppliers],[sid sname city]],\table[[Parts],[pid pname]],color],[S1 Smith Shanghai,P1 Nut,Red],[S2 Jones Paris,P2 Bolt,Green],[S3 Blake Paris,P3 Screw,Blue],[S4 Clark Shanghai,P4 Screw,Red],[S5 Adams Athens,P5 Cam,Blue],[P6 Cog,Red]]
\table[[\table[[Catalog],[sid]],pid,cost],[------------------,,],[S1,P1,300],[S1,P2,200],[S1,P3,400],[S1,P4,200],[S1,P5,100],[S1,P6,100],[S2,P1,300],[S2,P2,400],[S3,P2,200],[S4,P2,200],[S4,P4,300],[S4,P5,400]]
State what the following queries compute. Show all intermediary tables that lead to the relational outcome based on the query.
a) Parts (:} Suppliers
image text in transcribed

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

Databases Illuminated

Authors: Catherine M Ricardo, Susan D Urban

3rd Edition

1284056945, 9781284056945

More Books

Students also viewed these Databases questions