Unformatted text preview: the order in which the names are listed with the book must be specified (first author, second author, etc.). For example, if a book has two authors, the first author could receive 8% of the book sales as a royalty while the second author could receive 5%. The database includes information about authors, as well as customers that purchase books. This information includes an identifier, the person’s name, and the person’s address (street, city, state, zip). An author of a book can also be a customer. For every purchase, the database records the date of the purchase, the quantity purchased, and the actual price paid, where the actual price paid may be less than the book list price. Customers can also provide ratings on books, where a book is given a rating between 1 and 5 (1 is the best, 5 is the worst). The date of each rating is also recorded together with comments about the book to explain the justification for the rating....
View Full Document
- Fall '08