Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1) Consider the database schema on the relations (where key attributes have been underlined): COURSES(Number, Faculty, CourseName) STUDENTS(Number, Surname, FirstName, Faculty) EXAMS(Student, Course, Grade, Date)

image text in transcribed

1) Consider the database schema on the relations (where key attributes have been underlined): COURSES(Number, Faculty, CourseName) STUDENTS(Number, Surname, FirstName, Faculty) EXAMS(Student, Course, Grade, Date) NOTE: 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. a) Formulate in tuple relational calculus the query that retrieves the grades (5marks) achieved in exams that took place on 10/02/15 b) Formulate in relational algebra the query that retrieves the student number and grade of the students in the Faculty of Science that passed the exam for a (15marks) f Siene sed the exm course with CourseName Algebra c) Describe the standard three-level architecture for a DBMS. (5marks) 1) Consider the database schema on the relations (where key attributes have been underlined): COURSES(Number, Faculty, CourseName) STUDENTS(Number, Surname, FirstName, Faculty) EXAMS(Student, Course, Grade, Date) NOTE: 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. a) Formulate in tuple relational calculus the query that retrieves the grades (5marks) achieved in exams that took place on 10/02/15 b) Formulate in relational algebra the query that retrieves the student number and grade of the students in the Faculty of Science that passed the exam for a (15marks) f Siene sed the exm course with CourseName Algebra c) Describe the standard three-level architecture for a DBMS. (5marks)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions