Homework Help is Here – Start Your Trial Now!
Business
Management
SELECT PRIMARY KEY For data kept by a single publisher - it contains an entity BOOK, the following is known about the four attributes identified as candidate keys: BookName varchar(50), is always known for each book, and no two books have the same book name ISBN char(13), is unique and always known including for all books REFNumber char(10) is an internal 10 digit code assigned to every book but is commonly shared by multiple editions of the book. PubDate is the date on which the book is published. The publisher, never publishes two books on same date. Prior to publishing, every book still has a value which reflects the tentative publish date, and this is frequently revised through out the publication process. Based on the description above, the best suited attribute for primary key is (only one choice is correct): ISBN REFNumber PubDate Book Name

SELECT PRIMARY KEY For data kept by a single publisher - it contains an entity BOOK, the following is known about the four attributes identified as candidate keys: BookName varchar(50), is always known for each book, and no two books have the same book name ISBN char(13), is unique and always known including for all books REFNumber char(10) is an internal 10 digit code assigned to every book but is commonly shared by multiple editions of the book. PubDate is the date on which the book is published. The publisher, never publishes two books on same date. Prior to publishing, every book still has a value which reflects the tentative publish date, and this is frequently revised through out the publication process. Based on the description above, the best suited attribute for primary key is (only one choice is correct): ISBN REFNumber PubDate Book Name

Understanding Business
Understanding Business
12th Edition
ISBN:9781259929434
Author:William Nickels
Publisher:William Nickels
Chapter1: Taking Risks And Making Profits Within The Dynamic Business Environment
Section: Chapter Questions
Problem 1CE
See similar textbooks
icon
Related questions
Question
SELECT PRIMARY KEY For data kept by a single publisher - it contains an entity BOOK, the following is known about the four attributes identified as candidate keys: BookName varchar(50), is always known for each book, and no two books have the same book name ISBN char(13), is unique and always known including for all books REFNumber char(10) is an internal 10 digit code assigned to every book but is commonly shared by multiple editions of the book. PubDate is the date on which the book is published. The publisher, never publishes two books on same date. Prior to publishing, every book still has a value which reflects the tentative publish date, and this is frequently revised through out the publication process. Based on the description above, the best suited attribute for primary key is (only one choice is correct): ISBN REFNumber PubDate Book Name
Transcribed Image Text:SELECT PRIMARY KEY For data kept by a single publisher - it contains an entity BOOK, the following is known about the four attributes identified as candidate keys: BookName varchar(50), is always known for each book, and no two books have the same book name ISBN char(13), is unique and always known including for all books REFNumber char(10) is an internal 10 digit code assigned to every book but is commonly shared by multiple editions of the book. PubDate is the date on which the book is published. The publisher, never publishes two books on same date. Prior to publishing, every book still has a value which reflects the tentative publish date, and this is frequently revised through out the publication process. Based on the description above, the best suited attribute for primary key is (only one choice is correct): ISBN REFNumber PubDate Book Name
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Understanding Business
Understanding Business
Management
ISBN:
9781259929434
Author:
William Nickels
Publisher:
McGraw-Hill Education
Management (14th Edition)
Management (14th Edition)
Management
ISBN:
9780134527604
Author:
Stephen P. Robbins, Mary A. Coulter
Publisher:
PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract…
Spreadsheet Modeling & Decision Analysis: A Pract…
Management
ISBN:
9781305947412
Author:
Cliff Ragsdale
Publisher:
Cengage Learning
Management Information Systems: Managing The Digi…
Management Information Systems: Managing The Digi…
Management
ISBN:
9780135191798
Author:
Kenneth C. Laudon, Jane P. Laudon
Publisher:
PEARSON
Business Essentials (12th Edition) (What's New in…
Business Essentials (12th Edition) (What's New in…
Management
ISBN:
9780134728391
Author:
Ronald J. Ebert, Ricky W. Griffin
Publisher:
PEARSON
Fundamentals of Management (10th Edition)
Fundamentals of Management (10th Edition)
Management
ISBN:
9780134237473
Author:
Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:
PEARSON
SEE MORE TEXTBOOKS