Sally runs a bookstore and needs to start keeping track of ...



Sally runs a bookstore and needs to start keeping track of the books she has in inventory and the customers she sells books to. When a customer buys a book, Sally would like to be able to ask for their phone number, which she would key into an application which would retrieve their biographical information such as address and phone. If the phone number is not found, Sally would ask the customer if they would like to be on her mailing list and provide a form for them to fill out.

If the customer had purchased books before, Sally would like the screen to show past purchases by category for this customer. Sally could then “promote” any new releases in categories the customer seemed to favor. Sally would also like to do target mailing lists based on customer preferences.

For inventory, Sally needs to have all the information necessary to order a particular book from its supplier that is one of the ten suppliers she deals with. Sally also would like to know when she needs to order particular books, other than searching the shelves each night.

Areas for improvement:

Add an author entity so Sally could pull up books by author. Would need to have a many to many relationship between books and authors.

Could be expanded to actually generate the orders for suppliers.

Notes: All past history would be in the Transaction table.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download