Reference no: EM13934315
Consider the following schema:
Suppliers(sid: integer, sname: string, address: string) Parts(pid: integer, pname: string, color: string) Catalog(sid: integer, pid: integer, cost: real)
The key fields are underlined, and the domain of each field is listed after the field name. Thus sid is the key for Suppliers, pid is the key for Parts, and sid and pid together form the key for Catalog. The Catalog relation lists the prices charged for parts by Suppliers. Write the following queries in relational algebra, tuple relational calculus, and domain relational calculus:
1. Find the names of suppliers who supply some red part.
2. Find the sids of suppliers who supply some red or green part.
3. Find the sids of suppliers who supply some red part or are at 221 Packer Ave.
4. Find the sids of suppliers who supply some red part and some green part.
5. Find the sids of suppliers who supply every part.
6. Find the sids of suppliers who supply every red part.
7. Find the sids of suppliers who supply every red or green part.
8. Find the sids of suppliers who supply every red part or supply every green part.
9. Find pairs of sids such that the supplier with the first sid charges more for some part than the supplier with the second sid.
10. Find the pids of parts that are supplied by at least two different suppliers.
11. Find the pids of the most expensive parts supplied by suppliers named Yosemite Sham.
12. Find the pids of parts supplied by every supplier at less than $200. (If any supplier either does not supply the part or charges more than $200 for it, the part is not selected.)
|
Were there significant changes to any of the specific
: Were there significant changes to any of the specific line-item details that you think would require further explanation or analysis?
|
|
Products manufactured by nanuq australia
: A large retailer (in Sydney) that sells products manufactured by Nanuq Australia needs to develop an inventory policy for electric heaters. The annual demand for the electric heaters is 3,000 (A) units. Each unit costs the retailer $50 (c) with ho..
|
|
Principle and practice of health and social care
: ABC Care Home is situated in London and caters to care needs of vulnerable people. The service users come from diverse ethnic and religious background and have varied physical and medical needs.
|
|
Broad range of theoretical models
: The TQM approach to the management of human resources. The interpretation of quantitative and qualitative data to manage events. Support your evaluation with reference to a broad range of theoretical models that have been introduced and discussed i..
|
|
Find the sids of suppliers who supply every part
: Find the sids of suppliers who supply every part. Find the sids of suppliers who supply every red part. Find the sids of suppliers who supply every red or green part.
|
|
Description of how you collected the data
: References to data sources used for your study. Although you will work as a group to undertake your analysis, you must submit an individual report. The text, graphs, tables etc included in your report should be your own work. Data have been collec..
|
|
How address different sexual orientation as group supervisor
: Does anyone have any thoughts or comments on how to address different sexual orientations (LGBT) as the group supervisor? My understanding is the strength of the group comes from the interaction and acceptance of each member. Any thoughts on how t..
|
|
Fundamental quality management tools and techniques
: Before starting this assessment activity, read the full assessment description, marking criteria, submission requirements and guidance provided in the course textbook and below.
|
|
Presentation of data for the senior investment advisers
: Having completed your Graduate Degree from Cambridge, you have just got a job at a small investment advisory firm. Your firm recommends investment funds to Self-Managed Super Fund (SMSF) clients based on their risk and return characteristics.
|