Consider the following relational database that represents books, publishers, and books published by publishers. 1) Does this database schema allow for a book to have more than one publisher? Explain why or why not using an example. 2) Does this database schema allow for a book to be currently out of print (not currently being published)? Explain why or why not using an example. 3) List three super keys of the books relation.
Consider the following relational
1) Does this database schema allow for a book to have more than one publisher? Explain why or why not using an example.
2) Does this database schema allow for a book to be currently out of print (not currently being published)? Explain why or why not using an example. 3) List three super keys of the books relation.
4) List all candidate keys of the books relation.
5) List all of the candidate keys of the publishes relation.
6) List all of the superkeys of the publishes relation.
7) Are there any attributes in considered logically non-atomic? Briefly explain why or why not. Assuming tuple (4,83,200,1990) into the publishes table failed. Why did this happen? What database principle was violated?
9) Does the SQL statement ( select title, author from books;) evaluate to a relation? Briefly explain.
10) one web site. the database that could be we have the tables above, inserting the Outline the best strategy to handle publishers that have more than
Trending now
This is a popular solution!
Step by step
Solved in 4 steps