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.

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

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.

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

D
Consider the following relational database that represents books, publishers,
and books published by publishers.
books
BNO Title
Author
Date Edition
231 The Soul of a New Machine Tracy Kidder
1981 1
Programming Pearls
Programming Pearls
Jon Bentley
Jon Bentley
Thomas Hardy 1850 1
77
2000 2
23
1981 1
2
Tess of the d'Urbevilles
publishers
PNO Publisher
Web Site
City
Back Bay Books Boston
1
backbay.com
Addison Wesley New York addisonwesley.com
3
Modern Library London randomhouse.com
Penguin
4
New York penguin.com
publishes
PNO BNO Pages Copyright
1
231
293
1981
77
235
2001
2
23
200
1980
3
2
565
2001
4
540
1990
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 the database that could be
considered logically non-atomic? Briefly explain why or why not.
8) 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.
have
the
tables
above, inserting the
we
Outline the best strategy to handle publishers that have more than
Transcribed Image Text:D Consider the following relational database that represents books, publishers, and books published by publishers. books BNO Title Author Date Edition 231 The Soul of a New Machine Tracy Kidder 1981 1 Programming Pearls Programming Pearls Jon Bentley Jon Bentley Thomas Hardy 1850 1 77 2000 2 23 1981 1 2 Tess of the d'Urbevilles publishers PNO Publisher Web Site City Back Bay Books Boston 1 backbay.com Addison Wesley New York addisonwesley.com 3 Modern Library London randomhouse.com Penguin 4 New York penguin.com publishes PNO BNO Pages Copyright 1 231 293 1981 77 235 2001 2 23 200 1980 3 2 565 2001 4 540 1990 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 the database that could be considered logically non-atomic? Briefly explain why or why not. 8) 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. have the tables above, inserting the we Outline the best strategy to handle publishers that have more than
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY