Milllie$$s Musical Emporium $($MME$)$ Ltd has grown from a small company based in a small market town, to one of the country$$s leading suppliers of musical instruments and associated media $($e$.$g$.$ printed music, books, CDs and DVDs$).$ However, they have never quite managed to move away from using a paper$-$based filing system for storing customer, sales, and stock information. To cope with their growth and allow for more efficient stock recording, the store has decided to computerise their customer management and stock recording system. You have been tasked with developing a database application to meet their needs.

Current Position

Currently, MME Ltd record details of all customers $($including their name, address, telephone number, date of birth and bank details, i$.$e$.$ bank name, address, sort code and account number$)$ who either purchase a musical instrument or media. Records are also kept of every transaction that takes place in any of the stores.

A stock warehouse is also kept. This makes it possible to see where any given product $($including its identifier, type, name, description, cost$)$ is currently stored. The stock warehouse also contains details of all purchases and allows stores to move stock from one store to another. This is particularly useful for those customers who wish to purchase a product that is not available in their local store.

The organisation would also like to be able to create management reports, which may, for example, show all sales at a particular store or a group of stores, between certain dates.