Database Coursework

1.1.1. Background: Z music is a music computer storage, which is sporty sm every last(predicate). The shop specialises in Rap Music and R&B audio CDs and playstation 2 (PS2) games. The owner Zoë pooch has kept the stock running for nearly 3 years. Zoë employs altogether 2 other employees to run the shop. One of the employees is working overweight succession, whilst the other employee except works on the week beat 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 enlistment 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 disdain receives virtually 200-300 customers a week. On the weekdays, the duty does not receive many customers imputable to the fact that most people are at work. The sp eradicate is by far the busiest day for the business. When a new rec ord 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 volume of the paper work is done manually by hand. The business keeps about 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 prosperous 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 information! in a separate book. At the end of separately 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 nominal brain damage more stock to make undisputable 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 fatality 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