Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
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.

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.

Computer Networking: A Top-Down Approach (7th Edition)
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...
See similar textbooks
icon
Related questions
Question

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.

8) Assuming tuple (4,83,200,1990) into the publishes table failed. Why did this happen? What database principle was violated?

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 Back Bay Books Boston Web Site City 1 backbay.com Addison Wesley New York addisonwesley.com 3 Modern Library London randomhouse.com 4 Penguin New York penguin.com publishes PNO BNO Pages Copyright 1 231 293 1981 77 235 2001 23 200 1980 565 2001 540 1990 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: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 Back Bay Books Boston Web Site City 1 backbay.com Addison Wesley New York addisonwesley.com 3 Modern Library London randomhouse.com 4 Penguin New York penguin.com publishes PNO BNO Pages Copyright 1 231 293 1981 77 235 2001 23 200 1980 565 2001 540 1990 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 3 steps

SEE SOLUTIONCheck out a sample Q&A here
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
SEE MORE TEXTBOOKS