Relational Algebra Exercises 3 Write the relational algebra expressions for the following queries. Use the database sche
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Relational Algebra Exercises 3 Write the relational algebra expressions for the following queries. Use the database sche
Relational Algebra Exercises 3 Write the relational algebra expressions for the following queries. Use the database schema given below. 1. Find the number of blog entries added for the "Flying Machines“ blog on 01-01-2020. 2. Find all blog entries (text) and the number of comments for those entries. Ignore entries which have less than 5 comments. 3. Find the nicknames of users who wrote comment on each blog. 4. Create a new blog for user "165". Use "345" as the new blog id value. 5. Delete the comment 7650" from the database. 6. Delete the blog "340" from the database. eid User PK uid fname iname nickname email date_registered Blog Comment PK cid FK FK uid date_created text PK FK Blog bid uid date_created title 곳! PK Blog_Entry eid FK bid date_created text
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!