This topic contains 0 replies, has 0 voices, and was last updated by  EduGorilla 2 years, 6 months ago.

  • Author
    Posts
  • #1427832 Reply
     EduGorilla 
    Keymaster
    Select 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 fields are underlined, and the domain of each field is listed after the field 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.
    Now consider the following statements:
    S1:
    S2:
    S3:{T |T1Suppliers (X Parts (X.color = ‘red’∧∃Y Catalog (Y.pid= X.pid Y.sid=T1.sid))T.sname= T1.sname)}
    Which of the following result into same output?

    Options :-

    1. Only S1 and S2
    2. Both S1 and S3
    3. Only S3 and S2
    4. All are same.
    Post your Training /Course Enquiry
    Are You looking institutes / coaching center for
    • IIT-JEE, NEET, CAT
    • Bank PO, SSC, Railways
    • Study Abroad
    Select your Training / Study category
Reply To: Consider the following schema: Suppliers (sid: integer, sname: string, address: string) Parts (pid: ….
Your information:




Verify Yourself




Log in with your credentials

or    

Forgot your details?

Create Account