| Aug 27, 2020 |
COP-4710 |
Due: Tue, Sep 8
before 11:50pm |
|
Assignment-1 |
The purpose of this assignment is to familiarize with Relational algebra and Relational calculus queries.
For each of the following six queries, create one relational algebra query file:
- Premiere Products database
- List the number and city for each customer with credit limit more than $8,000 and is associated with sales rep 65. -- [filename: q1pp.alg]
- List the name of customer and the order date for each order that includes at least one part of item class SG or at least one part of item class HW. -- [filename: q2pp.alg]
- List the part number and description for part(s) with the lowest onHand value. -- [filename: q3pp.alg]
- List the name(s) of customer(s) where each of these customers placed order(s) for all parts listed in the result of the previous query. [Hint: use division operation] -- [filename: q4pp.alg]
- Henry Books database
- List the name of authors who wrote any book published by the publisher JP -- [filename: q5hb.alg]
- List the book title and branch name of each book with price more than $20 and is available at the branch -- [filename: q6hb.alg]
For each of the following two queries, create a domain relational calculus (drc) query file and a tuple relational calculus (trc) query file:
- Henry Books database
- List the book title and branch name of each book with price more than
$20 and is available at the branch. -- [filenames: q7hb.drc, q7hb.trc]
- List the title of the most expensive book and the name of the publisher of the book. -- [filenames: q8hb.drc, q8hb.trc]
Use WinRDBI to test the queries.
Compress all ten files, the following declaration and output of all query files, into a zip file (asg1.zip) and upload it through Canvas.
========================================================
Name: _________________________
Panther-ID: x x x -_______ (last 4 digits)
Course: COP 4710
Assignment#: 1
Due: Tue, Sep 8, 2020
I hereby certify that this work is my own and none of
it is the work of any other person.
Signature: ______________________
=========================================================