Relational Algebra
Not what you're looking for?
From the following relations, write the Relational Algebra to:
Find the part(s) that have been supplied by more than one vendor during February.
Vendors(vend#, vend_name, vend_phone)
Parts(part#, part_desc, part_price)
Supplys(vend#, part#, supply_date).
Purchase this Solution
Solution Summary
Relational algebra is applied.
Solution Preview
Attached please find the answer.
In relational algebra, there are six basic operators:
1. Select (σ)
2. Project (π)
3. Union ( )
4. Cartesian product ( x )
5. Set difference (-)
6. Rename (ρ)
In order to write this query in relation algebra, I will break the query into parts and then combine the result.
Given the following relations;
Vendors(vend#, vend_name, vend_phone)
Parts(part#, part_desc, part_price)
Supplys(vend#, part#, supply_date)
Find the part(s) that have been supplied by more than one vendor during February.
Steps:
1. Let's find ...
Purchase this Solution
Free BrainMass Quizzes
Word 2010: Table of Contents
Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.
Basic UNIX commands
Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.
C++ Operators
This quiz tests a student's knowledge about C++ operators.
Excel Introductory Quiz
This quiz tests your knowledge of basics of MS-Excel.
Basic Networking Questions
This quiz consists of some basic networking questions.