Page 1 of 1
Relational Algebra Exercises 3 Write the relational algebra expressions for the following queries. Use the database sche
Posted: Mon May 02, 2022 12:28 pm
by answerhappygod
- Relational Algebra Exercises 3 Write The Relational Algebra Expressions For The Following Queries Use The Database Sche 1 (39.23 KiB) Viewed 33 times
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