
December 4th, 2003, 03:47 PM
|
|
Registered User
|
|
Join Date: Dec 2003
Posts: 2
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
I need to write a query in SQL
Hey im completely new 2 this so it will probably seem piss easy to any1 reading this but heres the query i have to do
thanx
Consider the database schema on the relations (where the key attributes are followed by a *)
COURSES(Number*, Faculty, CourseName)
STUDENT(Number*, Surname, FirstName, Faculty)
EXAMS(Student*, Course*, Grade, Date)
Relation EXAMS stores the registration number(attribute Student) of students that passed the exam for a given course (attribute Course is the number of course, not the name of the course), the grade and the date of the exam.
Write the query that finds the surnames of students and the exams they passed (number of course and corresponding grade) in SQL, Relational Algebra, and Relational Calculus.
Any help will be greatly appreciated
Thanks
|