Site icon Cliff Notes

San Jose State University Database with A Department Table Discussion

San Jose State University Database with A Department Table Discussion

Question Description

My SQL question.

2. A database with a Department table with 3 records and an Employee table with 4

records is given below:

Department table:

  • DID Dname
  • D1 IS
  • D2 DS
  • D3 FIN
  • Employee table:

  • EID Ename Sex Salary DID
  • E1 Peter M 35000 D1
  • E2 Paul M 55000 D7
  • E3 Smith M 65000 D2
  • E4 Nancy F 55000 D1
  • Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."

    Exit mobile version