Advertisement
Guest User

Untitled

a guest
Jun 19th, 2019
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.55 KB | None | 0 0
  1. (PK) = Primary Key
  2. (FK) = Foreign Key
  3.  
  4. Building(buildingNum(PK), Description, instname, buildName, state, postcode)
  5. User(UNum(PK), buildingNum(FK), Surname, FirstName, initials, title)
  6. File(FileNum(PK), title)
  7. UserAccount(FileNum(PK)(FK), UNum(PK)(FK))
  8. Job(JobNum(PK), id, title)
  9. Interest(JobNum(PK)(FK), UNum(PK)(FK), Description)
  10.  
  11. select B.buildingNum, B.BuildName, B.instname
  12. from Building B join User U
  13. where B.deptNum = U.deptNum in (select I.Description
  14. from interest I
  15. where description = null);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement