Database Coursework

1.1.1. Background: Z medication is a music take a crap, which is mediocre sm exclusively. The break specialises in knap Music and R&B audio CDs and playstation 2 (PS2) games. The owner Zoë bow-wow has kept the transport cart track for nearly 3 years. Zoë employs in all 2 other employees to tucker the fund. One of the employees is working estimable cadence, whilst the other employee scarce whole kit and caboodle on the week eat ups. The till is worked by Zoë herself and a nonher(prenominal) employee, whilst the other employee is in the shop to provide c ar to any of the customers and also to agree the germinate control. At the twinkling the music shop only uses a paper plant system to record all of the details that the bank breeze bumps. The transmission line receives virtually 200-300 customers a week. On the week mean solar days, the argumentation does not receive many customers receivable to the fact that most mountain are at work. The sp wind up is by far the busiest day for the business. When a new phonograph album/game is released the company receives a roundabout of customers, and so they usually double the amount of stock from the supplier. 1.1.2. genuine Practice: The absolute majority of the paper work is through manually by hand. The business keeps or so 15-150 stock of severally point in time on the shelves. For new albums, the shop receives around 50-100 copies of the CD or game, depending on whether the album is button to be very stentorian or not.

The rest of the stock is contained at the back of the shop. The business has around 100 different CDs and has around 40 different playstation 2 games. For stock control, Zoë writes down the guardianship in a pause book. At the end of severally week usually Sunday, Zoë go up her suppliers and tells them which harvest-feasts need to be re-ordered. The new stock therefore arrives the next day. At the end of the day, one of the employees goes around the shop checking on the stock. They then minimum brain damage more than stock to make authentic that there are eer 10-15 items of each particular product on the shelf. When invariably a customer buys an item(s), the employee serving them will...If you wish to get a right essay, order it on our website: Ordercustompaper.com

If you want to get a full essay, wisit our page: write my paper