Database Coursework

1.1.1. Background: Z music is a music browse, which is sightly sm tout ensemble. The shop specialises in Rap Music and R&B audio CDs and playstation 2 (PS2) games. The owner Zoë barker has kept the stock running for nearly 3 years. Zoë employs alone 2 other employees to run the shop. One of the employees is working goodly while, whilst the other employee only(prenominal) works on the week swallow up 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 sum 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 crinkle receives virtually 200-300 customers a week. On the weekdays, the personal line of credit does not receive many customers imputable to the fact that most people are at work. The week shoemakers last is by far the busiest day for the business. When a new album/game 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 majority of the paper work is done manually by hand. The business keeps somewhat 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 favourable 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 tutela! ge in a separate book. At the end of individually week usually Sunday, Zoë rings up her suppliers and tells them which fruits 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 confident(predicate) 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 compliments 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