I am a little lost on the relational algebra question below, please help. Consid

Question

I am a little lost on the relational algebra question below, please help.



Consider a supplier-parts example database. The database has three relations, with the schema listed below.


Supplier (Name, City)
Part (Name, Color, Weight)
Shipment (SupplierName, PartName)


Shipment(SupplierName) is a foreign key on Supplier(Name). Shipment(PartName) is a foreign key on Part(Name).


Formulate the following queries in relational algebra.
• What are the names of suppliers?
• What are the names of suppliers located in Paris?
• What parts are red and weigh more than 40?
1. using selection -
2. using intersection and selection -
• From which cities are red parts shipped?
• What are the names of suppliers that ship a part?
• What are the names of suppliers that do not ship a part?
• What are the names of suppliers that ship at least two different parts?
• What are the names of suppliers that ship exactly one part?
• What are the names of suppliers that ship all of the parts?

Explanation / Answer

dear https://s3.amazonaws.com/answer-board-image/68e5fcfe-63d5-4cc2-99dc-19492012e710.gif

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.