This topic contains 0 replies, has 0 voices, and was last updated by  EduGorilla 1 year, 11 months ago.

  • Author
    Posts
  • #1440551 Reply
     EduGorilla 
    Keymaster
    Select Question Language :


    Consider the following relational schema. An employee can work in more than one department; the pct time field of the Works relation shows the percentage of time that a given employee works in a given department.
    Emp (eid: integer, ename: string, age: integer, salary: real)
    Works (eid: integer, did: integer, pct time: integer)
    Dept (did: integer, dname: string, budget: real, managerid: integer)
    Consider the following statements:
    S1:
    S2: SELECT ename, age
    FROM Emp E, Works W, Dept D
    WHERE E.eid== W.eid ˄ W.did== D .did ˄ D .dname= ‘hardware’ ˄ ‘Software’
    S3: SELECT ename, age
    FROM Emp E, Works W, Dept D
    WHERE E.eid== W.eid ˄ W.did== D .did ˄ D .dname= ‘hardware’
    INTERSECTION
    SELECT ename, age
    FROM Emp E, Works W, Dept D
    WHERE E .eid== W.eid ˄ W.did== D .did ˄ D .dname= ‘Software’

    Which of the following will result into the “Name and ages of all the employeewho works in both the Hardware department and the Software department.”?

    Options :-

    1. S1 and S3
    2. S2 and S3
    3. Only S3
    4. All of the above
    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 relational schema. An employee can work in more than one department; the pct ….
Your information:




Verify Yourself




Log in with your credentials

or    

Forgot your details?

Create Account