• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18

I will be making a system for a disc jockey that runs a radio station called TJ beatz, in a body building gym.

Extracts from this document...

Introduction

TJ Beatz FM? Radio Station Description Of Task I will be making a system for a disc jockey that runs a radio station called TJ beatz, in a body building gym. The DJ compiles play lists that will be played in the gym throughout the day. Currently the DJ is using a very old computer system that is not very user friendly, and a bit slow when using the search tool. The DJ will compile play lists from the database he already has. By using track time, type of music, name of artist, artist reference number (random compiled play list) and maybe key words from the title of the songs, e.g. Love, Summer etc. he produces a play list. The DJ might want to produce a play list that lasts half an hour, has different artists and different types of music. If say the DJ was going to compile a play list containing drum and bass music, he would simply type in drum and bass and a list of drum and bass songs will be shown. As he did not write in the length of each track, the songs could range from say one minute to five minutes, unless specified. The songs would also be by different artists, unless specified. Therefore he could search for songs very specifically. The DJ also wants a system that will be faster at finding tracks than his old database. Analysis The DJ showed me a table of how he would like the system to work and the properties it needs. Length Of Track(s) (mins) Artist(s) Style(s) Of Music 2.30mins Chad Muska and Eminem Hip Hop My system will then show: - Tracks Matching requirements Eminem - My name is - 2.30 mins Eminem - Bunch Of Jibberish - 2.30 mins Eminem - Bonnie and Clyde '97 - 2.30 mins Chad Muska - Body Rock - 2.30 mins Chad Muska - Beatz in The Hood - 2.30 mins I agreed that this would be the best way to devise the system and the way to search for certain tracks in this way is the most ideal. ...read more.

Middle

Therefore I will not need to design any sort of data capture forms. When adding fields to the database, I will enter the information into the field entry window. Program Structure Track Search Database Fields Artists Name: I need to include this field in order to recognise tracks and search for songs by that artist. Artists reference Number: I have given each artist on my sample collection of data a reference number for quick recognition and easier searching. Track Name: Each artist in my sample has a few tracks. I will need to be able to recognise each song, and see what the song is about by looking at the track name. Type of Music: When the DJ compiles play lists, he will need to know what sort of music to put into. This field will help him recognise the music type quickly. Track Length: Sometimes the play lists will have to be certain lengths and last for a certain amount of time. By displaying the track length, the DJ will be able to compile a selection of tracks that will fit into his time limit. Choose this track?: When this field is selected, a drop down list appears displaying, 'Yes' and 'No'. As the DJ browses through the database, he can select certain songs by clicking 'Yes' on the Choose this track field. At the end of his browse, he can click on the Play List Display button, and the tracks the DJ selected, will be displayed. He can the print this list out, and arrange the songs onto his CD player. Artists Information Artists reference number: This is so the DJ can relate certain artists to the information provided for each artist in the information database. Artists name: This field is required in order for the DJ to make sure he has chosen the correct artist to find information for. Main Type and Style of music: This is another way of seeing what sort of music certain artists perform. ...read more.

Conclusion

I will now fill in the search with rogue data. I have filled in the search with rogue data in every box. When I press the ok button, it should say something like, "Unable to find record" for example. The ok button is located in the top right of the screen. Here is a screenshot after I have pressed the ok button, confirming my search. The find does not recognise this record. It then asks me if I want to search again or not. It also offers help on searching. Evaluation I have met each required specification needed for the database. * It needed to have a search tool and be able to search for any required track. I met this specification by including a button in the track search database, which has a find macro. * It needed to be able to hold at least 350 records, and the allowance of an extra 50 records if required. So a maximum of 400 records would be needed at any one time. By constructing a database in Lotus Approach, this number of records would be able to be handled by any modern computer. * An easy way to write details of tracks etc. onto blank record files had to be included in my database. Lotus Approach is very user friendly, and inputting data is very easy for any user. * Two different systems were required, one holding artist information, and one for track searching. This was easy to overcome, as all I had to do was simply construct two separate databases. * An easy way to switch between each system was lastly required. By using Lotus Approach, I was able to create two different databases, and link them by joins and macros. I included a switch database button in each database, which would automatically switch the user to the database not already loaded, by just clicking the button. I do not think that any further refinements would be necessary in my database, as it is already to a high standard, and works sufficiently. Tom Sharp. 1st Project 1 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Management & Manipulation of Information section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level Management & Manipulation of Information essays

  1. Marked by a teacher

    Capital Radio

    They allow people to post their thoughts about the radio station and let people listen online. The Viewers can even listen to past show or listen live. The information needed for each system The information that is needed is: Programs like Microsoft Office, so they can operate.

  2. Designing a booking system for an Estate Agent.

    So everybody is involved with the system. The organisation communicates internally and externally through the use of email. They have sufficient ICT skills to work Microsoft programmes such as Word, Publisher and PowerPoint. They also have a basic knowledge of how to use Microsoft access but further explanation would still be needed to explain on how the system would work.

  1. ICT coursework: Designing and implementing a book rental system

    and told me that they could spend �999 on the new hardware and software. For Mr Dawson I would need to buy office 2000 Professional package, which has Access 2002, which is �126.20. I have to buy memory from 20Mb to 24Mb, which is 78.60, and install it.

  2. Database Design

    and filling in the details for all my forms (employee, order, supplier, shipper, and product information). Once I had created and filled in all my forms, I was able to link them together. This is how my forms are linked together: This relationship diagram shows how each table is linked together.

  1. The purpose of this document is to provide a design for an electronic payment ...

    The GUI screen design takes into account colour blindness and internationalisation. 2 Decomposition Descriptions 2.1 Module Decomposition This design document aims to provide a detailed outline of what needs to be extended to the existing S3G system. The aim of the document is to outline what components need to be

  2. I have been asked by a General Sports shop using a manual system to ...

    entered It deleted and re-typed in what I wanted 5 Test that when I save data it actually saves I will save a document then close it, then I will load it up It should have kept the changes that I had made It kept the changes that I made

  1. Planning a payroll system for a martial arts school.

    This causes a lot of limitations to the business, because it is slow, there is a lot of paperwork involved and it's very hard to find every single employers details. They are often errors in calculation that occur within the payroll and lead to the employee wages being incorrect and delayed.

  2. Evalution of my database

    I have also learnt how to make graphs to show the effects of the database. Feedback from others Name: Amy Gowland Date: 03/12/12 Comments: ?Sasha has shown her understanding of each assignment throughout the whole unit and has evaluated her work to her best potential.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work