Question: 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)

1) Consider the database schema on the relations (where key attributes

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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Database Management Systems Assignment 1 - Deadline Submission TBA Consider the following database schema and example instance: 3. Find the students (sid and name) that have taken at least one of the...

The Industrial\\Organizational Program Handbook Florida Tech 2013-2014 Rev: 7/31/13 Welcome to the Industrial/Organizational Psychology program at Florida Tech! We are glad you have chosen Florida...

In a university, we represent data about both students and employees. The university keeps track of each student's name, student number, social security number, address, phone, birth date, sex, class...

Kindly use the above basic operators to answer the below questions Relational Algebra Give an expression in the relational algebra to express each of the following queries: a. For each relation, what...

Consider the following requirement analysis description and the relevant ER diagram design. The university is organized into colleges (COLLEGE), and each college has a unique name (CName), a main...

dbms Consider the following database schema and example instance: Course Student dept credit cs 1 BOY Enroll Preze 2011 A 30 10 PHYSSE MY Hints: - Primary keys are underlined with red color. - The...

Please find the assignment on page 30 of the attached file(unit outline), which is: Task 2 - Research Focused Project - 25% I need $4000 words for this research paper. Please Use Academic journal...

Suppose that a database is needed to keep track of student enrollments in classes and students' final grades. After analyzing the mini-world rules and the users' needs, the requirements for this...

Study Guide Healthcare Statistics By Jacqueline K. Wilson, RHIA About the Author Jacqueline K. Wilson is a Registered Health Information Administrator (RHIA) who has more than ten years of experience...

The problem or challenge is to formulate an action plan to eliminate the debt within the time frame of two years. This includes not accruing additional debt in the meantime. The obstacle to overcome...

Now assume that Chelene knew that the basement walls were cracked and bowed and that she had hired someone to install paneling prior to offering to sell the house. Did she have a duty to disclose...

Company: National Bank of Canada you will use the constant-growth dividend discount model to estimate your company's expected rate of return. You will assume that the company is attempting to achieve...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

The international logistics pipeline, shown in Figure 4.3, is made up of the same basic elements as any other pipeline. However, this pipeline has a number of special characteristics. Use Table 4.3...

1 Comment on Glups plans to create engineered costs from the perceived benefits of the new material-handling equipment. Glup SA supplies a range of household soaps to supermarkets in northern Europe....

What happens to the break-even point if: 2 The sales price reduces by 5 per cent? Bond SA is planning to manufacture a new product with an initial sales forecast of 3,600 units in the first year at a...