The following relational schema form a university database which is implemented in a relational database: student (s_ID, s_name, semester, year) department(d ID, d_name, floor) course (c_code, c_title, d_ID, credits) Write down the Relational Algebra for the following queries: a) Find your own name using your own registration number as the student ID. b) Show the ID and name of the department located at the floor number equals the last digit of your own registration number. c) Find the codes and titles of the courses having credits more than 3 credits. d) Find the name of all students from your own semester and year.
The following relational schema form a university database which is implemented in a relational database: student (s_ID, s_name, semester, year) department(d ID, d_name, floor) course (c_code, c_title, d_ID, credits) Write down the Relational Algebra for the following queries: a) Find your own name using your own registration number as the student ID. b) Show the ID and name of the department located at the floor number equals the last digit of your own registration number. c) Find the codes and titles of the courses having credits more than 3 credits. d) Find the name of all students from your own semester and year.
Chapter2: Database Design Fundamentals
Section: Chapter Questions
Problem 11RQ
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Recommended textbooks for you
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr