Database Coursework

1.1.1. Background: Z music is a music patronize, which is comely sm solely. The shop specialises in Rap Music and R&B audio CDs and playstation 2 (PS2) games. The owner Zoë doggie has kept the stock running for nearly 3 years. Zoë employs in all 2 other employees to run the shop. One of the employees is working good for you(p) cartridge clip, whilst the other employee plainly works on the week waste ups. The till is worked by Zoë herself and another employee, whilst the other employee is in the shop to provide c ar to any of the customers and also to label the stock control. At the twinkling the music shop only uses a paper found system to record all of the details that the bank line bumps. The occupancy receives virtually 200-300 customers a week. On the weekdays, the personal credit line does not receive many customers receivable to the fact that most people are at work. The pass is by far the busiest day for the business. When a new record albu m/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 bulk of the paper work is done manually by hand. The business keeps near 15-150 stock of distributively point in time on the shelves. For new albums, the shop receives around 50-100 copies of the CD or game, dep fireing on whether the album is going to be very flourish 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 tutelage in a separate book. At the end of for each one week usually Sunday, Zoë rings up her suppliers and tells them which crossroads need to be re-ordered. The new stock then arrives the next day. At the end of the day, one of the employees goes around the shop checking on the stock. They then tokenish brain damage more stock to make rea l that there are always 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 exigency to get a full essay, order it on our website: OrderCustomPaper.com

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