1.Consider the relational database & perform the queries for the following:?

Discussion in 'Programming' started by MrPJH, Mar 30, 2007.

0
  1. #1
    .Consider the relational database & perform the queries for the following:
    Employee (person_name, street, city)
    Works(person_name, company_name, salary)
    Company(company_name, city)
    Manages(person_name, manager_name)
    i)Give the scheme definition in SQL corresponding to the relational schema shown in relational database, using references to express foreign –key relationship.
    ii)Find the company with the most employee.
    iii)Find the company with smallest salary.
     
    MrPJH, Mar 30, 2007 IP
  2. nvidura

    nvidura Well-Known Member

    Messages:
    1,780
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    150
    #2
    Well i don't know the answer. But i see an identical question here.. :D
    http://www.sgbau.ac.in/becs3to8.htm under 8SR3 Advanced Database management system... is this your homework?
     
    nvidura, Mar 30, 2007 IP