consider a database that consists of the following relations. su

Project Description:

consider a database that consists of the following relations.supplier(sno, sname)part(pno, pname)project(jno, jname)supply(sno, pno, jno)the database records information about suppliers, parts, and projects and includes a ternary relationship between suppliers, parts, and projects. this relationship is a many-many-many relationship. specify and execute the following queries using the ra interpreter.a. retrieve the part numbers that are supplied to exactly two projects.b. retrieve the names of suppliers who supply more than two parts to project ‘j1’.c. retrieve the part numbers that are supplied by every supplier.d. retrieve the project names that are supplied by supplier ‘s1’ only.e. retrieve the names of suppliers who supply at least two different parts each to at least two different projects.
Skills Required:
Project Stats:

Price Type: Negotiable

Expired
Total Proposals: 12
1 Current viewersl
12 Total views
Project posted by:

Proposals

Proposals Reputation Price offered
  • 4.5
    355 Jobs 236 Reviews
    $120 in 0 Day
  • 4.5
    94 Jobs 58 Reviews
    $0 in 0 Day
  • 4.0
    72 Jobs 31 Reviews
    $0 in 0 Day
  • 3.8
    30 Jobs 19 Reviews
    $0 in 0 Day
  • 4.8
    60 Jobs 32 Reviews
    $0 in 0 Day
  • 0.0
    0 Jobs 0 Reviews
    $0 in 0 Day
  • 4.9
    95 Jobs 45 Reviews
    $0 in 0 Day
  • 4.7
    74 Jobs 28 Reviews
    $0 in 0 Day
  • 4.9
    7 Jobs 7 Reviews
    $0 in 0 Day