Tuple and Domain Relational Calculus Exercises Write both tuple and domain relational calculus expressions for the following queries. Use the database schema given below. 1. Find the full names of all registered users. 2. Find the titles of the blogs created on 01-01-2020. 3. Find the nicknames of the blog owners whose blogs were created on 01-01-2020. 4. Find the blog entries which were added on 01-01-2020 for the blog "Flying Machines". 5. Find the last names of the users who posted comments to all entries of the blog "420" ("420" is a value for bid field). User Blog_Comment PK uid PK cid fname Fk eid Iname Fk uid nickname date_created email text date_registered Blog Blog_Entry PK bid PK eid Fk uid Fk bid date_created date_created title text
Added by Justin H.
Close
Step 1
Find the full names of all registered users. ** Show more…
Show all steps
Your feedback will help us improve your experience
Corbin Tegner and 54 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Write the following queries in relational algebra, using the university schema. a. Find the titles of courses in the Comp. Sci. department that have 3 credits. b. Find the IDs of all students who were taught by an instructor named Einstein; make sure there are no duplicates in the result. c. Find the highest salary of any instructor. d. Find all instructors earning the highest salary (there may be more than one with the same salary). e. Find the enrollment of each section that was offered in Autumn 2009. f. Find the maximum enrollment, across all sections, in Autumn 2009. g. Find the sections that had the maximum enrollment in Autumn 2009.
Sri K.
Write the following queries in relational algebra, using the university schema. a. Find the ID and name of each instructor in the Physics department. b. Find the ID and name of each instructor in a department located in the building "Watson". c. Find the ID and name of each student who has taken at least one course in the "Comp. Sci." department. d. Find the ID and name of each student who has taken at least one course section in the year 2018. e. Find the ID and name of each student who has not taken any course section in the year 2018.
Akash M.
Author Book Publisher Member Phone Member MemberID Name - Last Name Name - First Name DOB Checkout Date Borrowed By Checkin Date Publisher PubID Pub_name Book ISBN Title Year Published Written By Published By Author Author ID Name - Last Name Name - First Name has PNumber Type
Aarya B.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD