Some Simple Database Stuff

Soldato
Joined
27 Jun 2006
Posts
6,333
Hey folks,

Just cramming in a bit of revision for an exam tomorrow and have a few un-sures that I'd like to run by some of you.

This isn't homework or coursework or anything like that but can provide proof if there are any doubting Thomas'. :)

In terms of relational algebra, if I wanted to view 'LecturerName' and 'ModuleName' for people who only worked in 'Department# 1' would this be correct: (Overall Database is called Teaching)

Code:
(TEACHING WHERE Department# = 1)[LecturerName, ModuleName]

The only bit I'm unsure about is the 1 and whether it should be within single or double brackets. I'm assuming it is bracket-less based on the other examples that I've looked at (which have been more or less than) but just wanted to make sure.

Needless to say I'm not filled with confidence about the exam when simple stuff like this is getting in the way. :D

Thanks.
 
Back
Top Bottom