Anytime Children Stories - Case Study In 2016, Jack and Jill opened Anytime Children Stories, a family-owned business that sells electroinic books of classic and best-selling children's stories. Lovingly told stories for bedtime, nap time or quite time. The books can be viewed, watched, or simply listened too. The Company has a number of publishers from whom they purchase the electronic books for resale. For selling purposes, the electronic books are classified by appropriate age groups: 46; 710; and 1114. Roughly 30% of total sales occur within their single retail store; the remaining 70% are through online sales. Sales are particularly strong during the summer vacation months and Christmas shopping season. When the business opened, Jack and Jill bought a software package to handle online and store orders. They also setup their own spreadsheets with information about the publishers to handle the purchasing and inventory of their books. As the business has grown, so too has Jack and Jills realization that they need to have a better handle on the data about thier business as they have not been able to always get the correct information that they need. Anytime Children Stories has hired you to design an application with a relational database to improve their purchasing, inventory, and selling of books. You are now working on designing the relational database. Here is a list of data that you have determined to be stored: Order date CustomerFirstName CustomerLastName Customer Street Customer City Customer State Customer zip Customer Number Customer Email Customer Phone Order Number ISBN BookTitle Category AgeGroup Book Description Book Reviews ShipStatus ShipDate CDs On Hand Publisher Name Publisher Number Publisher email Publisher street Publisher City Publisher State Publisher Zip Published Date Publisher Phone Edition Purchase Price Retail Price Sales Price Author FirstName Author LastName Author DOB Authro DateDied CreditCardNumber CreditCardExpDate CreditCardSecurityNumber Business rules: 1. The Company offers its customers a purchasing incentive: all books are always discounted 40% from the retail price. 2. The Company likes to store the names of potential customers, even if theyve never done business with them. 3. Three times each year, the Company sends out 56 page brochures to advertise their top-selling and latest-release books, including general descriptions of each book (primarily the names of the stories). 4. The Company does not accept customer orders outside of the continental U.S. 5. A customer can have serveral books per order. 6. Online customers can either download the book or have a CD with materials sent to them. There is no extra few for shipping. 7. All shipping is handled by USPS.

Deliverables: A set of files containing an ER Diagram, Table Listing, and SQL statements relating to the Case Study. ER Diagram and Table Listing are to be completed using either MS Word, MS PowerPoint, MS Excel, or MS Visio. NO handwritten material will be accepted. SQL statements are to be completed using Notepad or an SQL editor (SQL Plus) and submitted as a SQL file (.sql) or Text file (.txt).