A private book collector is designing a databse to keep track of her purchases and book holdings.
Consider the entity set 'Book' with the attributes 'title', 'author', 'publisher', 'pubDate', 'numberPages', 'condition', 'cost', and 'datePurchased'.
a. Show how the entity set and its attributes would be represented on an E-R diagram
b. Describe the domain of the 'cost' attribute, making assumptions as needed
c. Identify a superkey for the Book entity set
d. Identify all candidate keys for the entity set
e. Identify a primary key for the entity set and underline it on the E-R diagram