CANDIDATE KEY For data kept by a single publisher-contains an entity BOOK, the attributes are known to be as follows: Book Name 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 after book has been registered with book organization Books in process of being published do not yet have an ISBN Price smallmoney, is always available and greater than zero. 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 Based on the description above, which of the following are Candidate Keys? Book Name AN Price Pub Date 1 points CANDIDATE KEY For data kept by a single publisher - it contains an entity BOOK, the attributes are known to be as follows: Book Name varchar(50), is always known for each book and most books do not share book name with another book from the publisher ISBN charf131. is unique and always known for each book Price smallmoney, is always available and greater than zero PubDate is the date on which the book is published. The publisher, never publishes two books on same date. Prior to publishing every book stat has a value which reflects the tentative publish date. Based on the description above. Which of the following are Candidate Keys! Price Book Name PubDate ISBN PRIMARY KEY For data kept about a product, the following candidate keys were identified. Additional information about each of these is provided below. Product Name varchar(501, is always known and copyrighted to make sure it is unique ASIN char(13), is unique and assigned to every single product at the time of entry and never changed. UPC CODE char(10) is is assigned to every packaged product. Products that are not packaged, or are used or refurbished packaged products, may not have UPC Code. Based on the description above, the best suited attribute for primary key is: Product Name ASIN UPC Code Need to create a surrogate key because none of the candidate keys make for a suitable primary key. 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: Book Name varchar, is always known for each book and no two books have the same book name ISBN Char31 is unique and always known after book has been registered with book organization Books in process of being published do not yet have an ISBN REFNumber char(10) is an internal 10 digit code assigned to every book the money plans for book are made PubDate is the date on which the book is published. The publisher, never publishes two books on same date. Prior to publishing every book til at a value which reflects the tentative publish date, and this is often revised frequently throughout the publication process. Based on the description above, the best suited attribute for primary key is SON Book Name Pusate REFNumber