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

Question

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). Supplier has 100 tuples Part has 50 tuples Shipment has 2000 tuples Give exact counts of the potential number of tuples, both at a minimum and at a maximum, for each of the following queries. What are the names of suppliers located in Paris? What parts are green or weigh more than 40? What are the colors of parts shipped from Paris? What are the colors of parts that have not been shipped? What are the names of suppliers that ship at least two different parts? What are the names of parts that have been shipped by exactly one supplier? What are the names of suppliers that ship all of the parts?

Explanation / Answer

The relational model coverage has been reorganized and updated in Part 2. ..... For example, we can specify that Name of STUDENT is a string of alphabetic ...... three entities-a supplier s, a part p, and a project j? whenever s supplies part p ro ... foreign keys are a type of reference attribute used to represent relationships.

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

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