Case Study Question

Book Store Database Problem Description A small coat book keep has been keeping track of its business mainly on paper. The proprietor is planning to grow her business. She would handle to improve the bookkeeping, and as a result provide better service to customers, with a state-of-the-art database system. As she is not familiar with sore-fashioned technology and tools, she would like to hire a college student who would go up such a system over the next summer. The new system leave alone help the bookstore maintain expatiate about books, publishers, customers, receipts/payments, etc. A book whitethorn be a textbook, a novel, a comic, a childrens book, or a cookbook. Publishers are the suppliers of the books. The bookstore buys books from different publishers. common customers of the store are libraries, institutions, or individuals such as students, faculty, and others. Customers may open an account with the store if they wish and receive a customer number. The bookstore is planning to build a website that will allow customers to perform certain activities on-line. When customers place an order on-line, they git pay either by a major book of facts card or store credit.

If the transaction takes place in the store, then customers can pay by cash or check in addition to credit card and store credit. If the required number of copies is available for on-line orders, the store ranges the books and updates the downslope level. If the required number of copies is not available, the store may send a partial consignment, provided that it is acceptable to the customer. The bookstore owner would like to send information about new books, new adaptations of a book, or deals to customers based on their profiles. If a customer were a faculty member at a university, then the owner would like to offer a free copy of a new textbook or a new edition of an existing textbook. If a customer were a student who want reading science fiction, the owner... If you want to get a rich essay, order it on our website: Ordercustompaper.com

If you want to get a full essay, wisit our page: write my paper