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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- sample performance improvement period notice
- safeguard privacy policy e quantum inc
- great plains sales order processing fact sheet
- sally runs a bookstore and needs to start keeping track of
- university of vermont
- income tax preparation for your mary kay business
- solomon order to purchase fact sheet
- 1 university of oklahoma
- section1 what is erp
- qatar glass industries exceeding demands capacity
Related searches
- how to start a small business
- how to start a college essay examples
- how to start a marketing business
- how to start a company
- loans to start a small business
- how to start a business
- how to start a marketing agency
- how to start a conclusion paragraph
- getting a loan to start a business
- how to start a business plan
- government grants to start a business
- how to start a garnishment