Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- (PK) = Primary Key
- (FK) = Foreign Key
- Building(buildingNum(PK), Description, instname, buildName, state, postcode)
- User(UNum(PK), buildingNum(FK), Surname, FirstName, initials, title)
- File(FileNum(PK), title)
- UserAccount(FileNum(PK)(FK), UNum(PK)(FK))
- Job(JobNum(PK), id, title)
- Interest(JobNum(PK)(FK), UNum(PK)(FK), Description)
- select B.buildingNum, B.BuildName, B.instname
- from Building B join User U
- where B.deptNum = U.deptNum in (select I.Description
- from interest I
- where description = null);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement