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 soon 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 strained 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 playing 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 past constantly after being expelled from university. He then helped out at local venues, at low key parties and occasions. He th en went on to take out 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 mingled clubs such as wicked, Lyyne Chameleon and most recently Avenue Q. His intentions are to raise enough money to be able to go derriere to university.Identifying the userMy client will be the main user of the system, but I will occasionally use the system to check for updates and any accomplishable faults.Statement of the problemMy client currently organizes his music collection manually, using index cards and other pieces of paper. This is organised by Artist name. But this proves piteous 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 declaration consideredMy client could take hold his current method of index cards, (organised vi a artist name) which can prove sometimes useful, as technology can sometimes crash, or guide faults. On the other business deal index cards can be often lost, resulting the time consuming task of re-writing them all out.Another manual firmness of purpose 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 property being taken up, as the folder collection, would have to be extremely large. two alternative software solutions consideredMr 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 justifiedI have chosen to use MS access because it is easy to use, and it is primary to find things using queries and searches.At least 3 Quantitative objectives identified* Database must be password protected* Search Info Easily* drug user friendly way of entering data