Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

In a company database, details of the customers, the products sold and the orders made by customers are stored in the relations Customer, Product and

image text in transcribed
image text in transcribed
In a company database, details of the customers, the products sold and the orders made by customers are stored in the relations Customer, Product and Order, respectively: Customer Product cid cname c001 Jones c002 Smith c003 c004 Williams county Essex Surrey Kent Kent pid pname county stock price Sussex Kent Surrey Kent Essex p01 paint p02 wood p03 mails p04 hammer p05 screws 1114 0.50 2030 0.50 1506 1.00 1253 1.00 2214 1.00 Order ordno month cid pid quantity ojan c001 100 1012 jan c001 p02 100 019 feb c001 1023 mar c00 p03 1013 jan c002p0 1026 may c002 p3 04 40 1015 1014 jan 1021 feb c004 p01 100 80 120 c003 p02 120 100 an 04 3. For each of the following queries in relational algebra: Show the resulting relation (table); Describe the result in your own words. county-Kent' ( Customer ) 11 pname, price ( county- ) ) (a) Kent (Product (c) II county (Customer) II county (Product) (d) (e) pname ( Product Xd Order ) came-Jones, ( Customer ) pid-pol, ( Order )

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

More Books

Students also viewed these Databases questions

Question

=+54-2 Assess how memory changes with age.

Answered: 1 week ago