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
No comments:
Post a Comment