Answer to Question #94686 in Databases | SQL | Oracle | MS Access for Phindile Muvhali

Question

Computer (vendor, model, machinetype)
Model (num, speed, ram, hd, price)
Vendor (name, address, phone)
Where vendor indicates the manufacturer of a computer, and machine type takes values such as “desktop”, “laptop” and “server”. Underline indicates the primary key. Following inclusion dependencies hold: vendor ⊆ name, and model ⊆ num. Express following queries in relational algebra:
A. Find all the vendors who make laptop(s).

Answer 1

Dear Phindile Muvhali, your question requires a lot of work, which neither of our experts is ready to perform for free. We advise you to convert it to a fully qualified order and we will try to help you. Please click the link below to proceed: Submit order