Suppliers (sid:integer, sname: varchar(20), city: varchar(20)) Parts (pid:integer, pname: varchar(20), color: varchar(20)) Catalog(sid:integer, pid:integer, cost:real)
Added by Karen U.
Close
Step 1
Step 1: Select Catalog tuples with cost less than 10: C1 := σ_{cost < 10}(Catalog) Show more…
Show all steps
Your feedback will help us improve your experience
Anecia Mcmurrin-Bala and 54 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Write a sequence of operations to answer the query. Also, provide an answer to the query. Use Tables 3.6.4–3.6.7 Find the part numbers of parts of which there are at least 100 items on hand.
Functions, Sequences, and Relations
Relational Databases
Consider the following classic schema (keys are in bold): sales(dept, item, volume) dept(dname, floor) item(iname, type, color) employee(eno, ename, mgr, dept, salary, job-status) supplier(sno, sname) supply(supplier, dept, item, volume) Express the following queries in relational algebra: 1. Find the items sold by no department on the second floor. 2. Find the departments where all the employees earn less than their manager. 3. Find the items sold by at least two departments on the second floor. 4. List the items sold only by departments that sell all the items they are supplied.
Aarya B.
Describe an intersection operation on a relational database. Illustrate how your operator works by answering the following query, using the relations of Tables $3.6 .4-3.6 .7:$ Find the names of all buyers who buy both parts $2 \mathrm{~A}$ and $1199 \mathrm{C}$. Also, write a sequence of operations that could be used to answer the query.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD