- In Sql Language 1 (202.9 KiB) Viewed 34 times
In SQL Language
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
In SQL Language
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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!