ICT Database

My client, (full time DJ) Mr. I. C. H. Cheezeburger has just been employed by Avenue Q, a newly opened club in the west end. He is currently having problems organising his very vast and varied, music collection. He currently organizes his collection manually using index cards. This proves extremely impractical, as they are often mislaid, and he is forced to start again, creating even more work than necessary. Clients Background. My client was born on 5th May 1985 in Chelsea. He went to Dun Raven in Streatham; he was bullied at school, until in year 10 he moved to St William Perkins all boys' school. Where he excelled in, Music and, Performing arts. He later took a level performing arts, music, ICT, and Textiles. He went on to university, but was expelled after three months. He was interested in dj-ing since a young age, and went on to do it in his spare time, and then constantly after being expelled from university. He then helped out at local venues, at low key parties and occasions. He then went on to take an apprenticeship, and started charging for his services. He then bought his own flat in Woking, with a small studio, where he could focus constantly on his DJ-ing. He has been employed by various clubs such as â€Å"wicked†, â€Å"Lyyne† â€Å"Chameleon† and most recently â€Å"Avenue Q†. His intentions are to raise enough money to be able to go back to university. Identifying the user My client will be the main user of the system, but I will occasionally use the system to check for updates and any possible faults. Statement of the problem My client currently organizes his music collection manually, using index cards and other pieces of paper. This is organised by Artist name. But this proves inadequate and time consuming, as he often loses his lists, resulting in him having to write it all out again. Using valuable time, that could be spent doing something more constructive. Manual solution considered My client could keep his current method of index cards, (organised via artist name) which can prove sometimes useful, as technology can sometimes crash, or have faults. On the other hand index cards can be often lost, resulting the time consuming task of re-writing them all out. Another manual solution would be to use folders to organise his collection, (organised either by artist name, or song name) this is more effective than index cards as they are large, and easier to keep track of. But, could result in a large amount of space being taken up, as the folder collection, would have to be extremely large. Two alternative software solutions considered Mr Cheezeburger could use itunes to organize his music collection, as it is user friendly and very easy to use. Contrariwise to be able to use itunes QuickTime and safari must be downloaded using up more memory, causing the system to be slower, also, an itunes library cannot be transferred to multiple computers in a short space of time. MS Excel could also be used, as it is easy to use, and the cells can be filtered and things can be located quickly and easily. On the other hand it is easy to make errors, and they effect the system long term. Proposed solution justified I have chosen to use MS access because it is easy to use, and it is simple to find things using queries and searches. At least 3 Quantitative objectives identified * Database must be password protected * Search Info Easily * User friendly way of entering data