- 07/13/2019 at 9:52 pm #1440555EduGorillaKeymasterSelect Question Language :
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 ﬁelds are underlined, and the domain of each ﬁeld is listed after the ﬁeld name. Therefore 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.
Which of the following will result into “Name of all the suppliers Who supplies red part which cost less than 100”?
Post your Training /Course EnquiryAre You looking institutes / coaching center for
- Only S1
- Only S2
- Both S1 and S2
- None of these
- IIT-JEE, NEET, CAT
- Bank PO, SSC, Railways
- Study Abroad