Project_city (branch) UNION Project_city (customer)

Project_city (branch) - Project_city (customer)

Project_bname(Select_assets > 2,500,000 (branch))

Project_cname,city (Select_balance > 2,000 (deposit) join customer)

Project_city (customer) - Project_city (branch)

Project_cname((Project_city (customer C) - Project_city (branch)) JOIN ON C.city = customer.city customer) Anti-join: Project_cname (customer anti-join ON customer.city=branch.city (branch))

Project_city(branch) INTERSECT Project_city(customer)

Project_borrow.cname,borrow.amount,deposit.balance (Select_ borrow.amount > deposit.balance (deposit JOIN ON deposit.cname = borrow.cname and deposit.bname=borrow.bname borrow))

Project_bname,assets (Select_city= Vancouver'(customer) JOIN deposit JOIN deposit.bname=branch.bname (branch))

Project_cname (Select_bname='CalgaryCentral'(deposit)) INTERSECT Project_cname (Select_bname='CalgaryCentral'(borrow))

Relational Algebra Lesson

Presentation

•

Computers

•

12th Grade

•

Practice Problem

•

Hard

Amanullah Yasin

Used 6+ times

FREE Resource

41 Slides • 25 Questions

Multiple Choice

Multiple Choice

Video Response

Open Video Recorder

Multiple Choice

Two tables have the same number of fields in the same order with the same types, but the names of some fields are different. True or false: The two tables are union compatible.

Yes

Multiple Choice

Ris a relation with 10 rows and 5 columns. Sis a relation with 8 rows and 3 columns. What is the degree and cardinality of the C artesian product?

degree = 8, cardinality = 80

degree = 80, cardinality = 8

degree = 15, cardinality = 80

degree = 8, cardinality = 18