In SQL Language
Posted: Sat May 14, 2022 7:44 pm
In SQL Language
1. Consider the following database schema and answer the following quires using Relational Algebra (7 points) Book (BkTitle, Publisher, YearPublished, Description) Author (AuthorName, BDYear) Written (AuthorName, BkTitle) Publisher (PubName, PubAddress) a. Find books published after 2000. b. Find all books and their description. c. Find authors who have published a book with every publisher. d. Express the above query (in C) in SQL.
1. Consider the following database schema and answer the following quires using Relational Algebra (7 points) Book (BkTitle, Publisher, YearPublished, Description) Author (AuthorName, BDYear) Written (AuthorName, BkTitle) Publisher (PubName, PubAddress) a. Find books published after 2000. b. Find all books and their description. c. Find authors who have published a book with every publisher. d. Express the above query (in C) in SQL.