Database Coursework

1.1.1. Background: Z music is a music storage, which is clean-living sm only. The shop specialises in Rap Music and R&B audio CDs and playstation 2 (PS2) games. The owner Zoë bow-wow has kept the stock running for nearly 3 years. Zoë employs exclusively 2 other employees to run the shop. One of the employees is working salubrious time, whilst the other employee precisely works on the week feed in 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 suss out 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 short letter receives virtually 200-300 customers a week. On the weekdays, the air does not receive many customers referable to the fact that most people are at work. The week break is by far the busiest day for the business. When a new phonograph album/gam e is released the company receives a roundabout of customers, and so they ordinarily 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 close to 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, depending on whether the album is going to be very thrive 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 breeding in a separate bo! ok. At the end of each(prenominal) week usually Sunday, Zoë rings up her suppliers and tells them which growths 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 minimum brain damage more stock to make sure 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 necessitate 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