billy_111 — 2010-01-06T22:13:56-05:00 — #1
How can i convert the following SQL query to relational algebra?
This is the table:-
Module(ModuleNumber, LecId, Schedule)
Student(StuId, firstName, lastName)
This is the SQL:-
SELECT LecName, Schedule FROM Lecturer, Module, Enrol, Student WHERE lastName = 'Burn' AND firstName = 'Edward' AND Module.ModuleNumber = Enrol.ModuleNumber AND Lecturer.LecId = Module.LecId AND Student.StuId = Enrol.StuId
How can i show this SELECT in relational algebra? With the sybols etc..
dan_grossman — 2010-01-06T22:18:18-05:00 — #2
This looks like homework... are you asking us to help you cheat?
r937 — 2010-01-07T00:57:42-05:00 — #3
why in the world do you think you need to do that?????
billy_111 — 2010-01-07T07:57:51-05:00 — #4
Its not homework
It's actually revision for exams. I didnt know if anyone would help me with this though.
Basically i enjoy databases and currently work as a web developer but decided to go forward and do a Masters Degree in Databases.
Just trying to study Relational Algebra, but cant quite get the syntax right.
And its not cheating as im not asking you to do my exams for me, its just help i ask for.
Hope you can help, if not i will delete this thread..
r937 — 2010-01-07T08:20:52-05:00 — #5
masters degree in databases?
this would imply you already have a graduate degree in databases
as keyshawn says on monday night countdown, "c'mon, man!!"
r937 — 2010-01-07T08:42:26-05:00 — #6
oops, i meant to say you already have an undergraduate degree
geez, and i went to university, too
billy_111 — 2010-01-07T08:44:57-05:00 — #7
lol no i have undergraduate degree in multimedia and internet technology (Bsc hons) and currently doing masters (MSc) in Advanced Databases..
So do you know where i can get help with this?
r937 — 2010-01-07T08:55:10-05:00 — #8
- your course textbook(s)
- your course reading materials
- your professor
- your professor's teaching assistant
- fellow students in the same course
billy_111 — 2010-01-07T10:52:28-05:00 — #9
dan_grossman — 2010-01-07T12:27:50-05:00 — #10
I hope that this is the first course taught in a "Masters in Advanced Databases" degree
phpkick — 2010-01-07T13:34:18-05:00 — #11
Well, there's another language/syntax/math thingie I don't want to learn. GL
hash — 2010-01-09T06:42:58-05:00 — #12
My faith in the education system has taken another knock. I've answered some of your posts, and I hope to god you aren't really doing a masters in any sort of db field.
r937 — 2010-01-09T07:14:39-05:00 — #13
did you mean me, hash? because that was me you quoted
let me reassure you, there's no way i'm doing a masters in any university except the one i've almost completed at the school of hard knocks