this is for a Database class Please answer question 1 a-d You have just been hir
ID: 3840390 • Letter: T
Question
this is for a Database class
Please answer question 1 a-d
You have just been hired at the famous company WSB.com (Weber State Books) which sells books over the Internet. They have been having problems with their database designs and have hired you as a database expert to help fix them. The Figure below shows a Conceptual Entity Relationship diagram intended to represent WSB.com's main database to track sales of books to customers. Based on the above Figure, answer the following questions (in as much detail as possible).... a. How does one determine the price a given customer paid for a given book? a. What small correction needs to be made to the E-R diagram to capture this data correctly? b. Is it possible for two customers to buy the same book but for different prices? a. If so, how is this possible? If not how does the logic of the E-R diagram prohibit this? c. Does the customer always pay the lowest price for which he or she is eligible? a. If not is there an easy way to modify the E-R diagram in order to assure this? d. Does the E-R diagram ensure that the Offer under which a customer buys a book is, in fact legitimate? That is, an offer is for a particular club's members. Are we guaranteed that the customer belongs to the corresponding club? Why or why not?Explanation / Answer
a. Inorder to capture the price information easily, we need to add the paid attribute to the buys relation. So that it will easy to identify which customer has paidhow much amount.
b. Yes, It is possible because in the description it is said that offer is different for each and every club. That means it is possible two customers from two different clubs can buy the same book but for different price.
c. Yes, in the offer entity it captures the offer amount for every club. Each customer belongs to one club. So according to his club membership he will get the lowest price available for the book.
d. Yes the customer must be belonged to one club as this is captured according to the customer occupation when the first the customer registers with the store or buys the book. So this means each and every customer must belongs to one club type. So he will get the offer accordingly.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.