Case Study 1: Book ReSale, Inc Transactions

Case Study 1: Book ReSale, Inc System

Mr. John Delgado decided to put up a business on retailing books that are both brand new and already used with the markup of only 10%. So, after renting a spot in a known mall, he started advertising his proposed business to prospected suppliers and clients to great results.

1.      Janet De Castro had a used book, The Devil’s Advocate by Evan Goodling, in good condition sold to Book ReSale for Php 300.50

2.      Clark Henares sells 5 copies of The Notebook by Nicholas Sparks all in good condition for Php 150.00 each

3.      Rubeth Palacios sells her collection of the Percy Jackson series (The Lightning Thief, The Sea of Monsters, The Titan’s Curse, The Battle of the Labyrinth, The Last Olympian) by Rick Riordan for Php 250.00 each, all of whom are in good condition.

4.      Michael de la Cruz sells his copy of The Titan’s Curse for Php 50.00 only as it was in bad condition.

5.      HarperCollins supplies the following brand new books with their corresponding prices and copies:

          1.      The Hunger Games by Suzzane Collins, 350.00, 7

          2.      Catching Fire by Suzzane Collins, 350.00, 7

          3.      Mockingjay by Suzzane Collins, 350.00, 7

          4.      Divergent by Veronica Roth, 400.00,  5

          5.      Insurgent by Veronica Roth, 400.00, 5

          6.      American Gods by Neil Gaiman, 250.00, 3

          7.      The Graveyard Book by Neil Gaiman, 250.00, 3

6.      VisPrint also supplies the following books:

          1.      ABNKKBSNPLAKo by Bob Ong, 100.00, 5

          2.      Bakit Baliktad Magbasa by Bob Ong, 100.00, 5

          3.      Stainless Longganisa by Bob Ong, 150.00, 5

7.      Bryan Guevara bought a copy of Mockingjay. Since he was the first customer, Mr. Delgado gave him a 5% discount.

8.      Jesse Mitchell buys the two copies of The Titan’s Curse.

Assume that you were hired to be a data processing specialist, create a database model for Book ReSale based on the collected data above.

NOTE: In this case study, do NOT take note of the Inventory of Books and the Accounting of Sales. Simply record the transactions in the database.

Solution(in MS Access 2007)(Note: click the smaller download link, not the big one in the ads):

http://www.2shared.com/file/fCqlSGrk/Case_1.html