• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 1573

The purpose of my database is to help customer's choose which Music cd or Album they prefer to buy and which is most suitable for their requirements.

Extracts from this document...

Introduction

1 Describe what the User Needs What will the database enable you to do when it is finished? The purpose of my database is to help customer's choose which Music cd or Album they prefer to buy and which is most suitable for their requirements. The database allows them to sort through a wide range of information and gives them opions on which album would best suit them. 2 Describe the data needed what data is needed? For my database to be successful it needs to have the following data: * Basic details of a range of ..... * Cd Names / Info * Artist Info * Cost's * Popularity Of Cd * Record Label / Info Where will you collect data from? I will collect data from a range of sources. These will include internet, artists, magazines and record labels. The most important source will probably be the internet because it is always updated. 3 Describe the tables and the relationships you plan to use How many tables? I plan to create 3 tables. These will be called: 1) Artist Info 2) Cd Info 3) Record Label Info What fields and types of fields, etc. ...read more.

Middle

5 describe how you entered data into your tables I entered my data straight into the tables. This was because it was easier to identify it and easier for people to use it. It also helped me to make sure that everything I entered was correct. I also use extra features for example the "next record" and "last record" buttons these are clearly visible on the screen shot below, I created these so it would be easier for people to move onto the next and previous record and it also improved the design and layout. In the form I had made some changes which improved the design of the form and made it easier to use. First I made some buttons which when clicked on would link to, the next record, last record, find record and exit. I also had to make some changes in the properties make the form better, I removed the navigation buttons and removed the border. So after all the changes the final design looked like this, I changed to option on the navigation option to make it invisible instead I put separate buttons on the form design so it was easier to use and work. ...read more.

Conclusion

I created several back up copies of my data bas this was just in case one got deleted or lost. I saved a copy in school and at home. I checked my work for errors some things that I looked for were, spelling and grammar I done several checks as I went along to make sure that none of the work were spelt incorrectly. I also made sure that the relationships were linked correctly and the form features were working correctly. 8 evaluate what you have done My finished database is different in many ways compared with the one that I has designed for my plan. I added many features which made the design look better and the database easier to use. If I had more time I would have put in many more features and buttons and maybe I would have had more tables which might have allowed me to create more relationships. To extend my database I could put more tables in and maybe I could insert pictures or covers of the albums, which would also improve the quality of the presentation. I made sure that the names of the tables had something in relation with the information in the tables. 1 DATA BASE GNVQ ICT - Sherjeel Akhtar Database report ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application 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 GCSE ICT Systems and Application essays

  1. Technology to help the blind.

    breaks o Something's very disturbing o Gets lost o One of the bad thing about Braille Watches is that it only reminds you once and that's bad because maybe the person is fast a sleep and can't hear it so they will mess the alarm How the technology meets their

  2. Different types of technology How I use ICT at home and at school

    to the restricted computer settings * School it too virus-amateur and thus disallow the use of USB sticks, CDs etc. Conclusion Overall, while the school computer system does all it can to stay safe, risk-free and without threat, it goes too far into limiting our actual ICT use.

  1. Database design.

    ID number Number 6 Foreign No Rent_Video_ID Video ID Number Number 4 Foreign >9999< No Rent_date_out Date Of Video Rented out Date __/__/__ No Rent_date_returned Date of video returned Date __/__/__ No Output from queries and reports The output from the queries allowed me to create a letter.

  2. My task is to help Type a Flight travel agency to make their things ...

    Database: Type a flight Comment: I looked at a switchboard called "Type of flight" and the logo is situated in the middle of the page. It has various buttons such as Enter ID, Search ID, Gender, D.O.B, Name etc. This makes the database faster and sufficient.

  1. GCSE Database Project ICT

    to be sent out to remind patients who have not booked for 5 to 6 months prior. The user needs the patients Telephone Number, ID, reminder date, Time, Title, Past Treatment Description, Forename, Surname, Address (Town and Postcode) and to print out a report to enable the user to 'tick´┐Ż off the people who have re-booked.

  2. Organising the database at Costsloadsless.

    will be members for longer and that will bring more money into the business. Good points Bad points * You don't have to train all the staff to work the computer if they just have to work with there brain * They will forget all the data after about one

  1. System requirements analysis

    1.2 Input, Processing and Outputs a) System inputs (A02.13, A01.41, and A04.41) the patient records were imported from the database to the software. These records were put into a new tab/ excel worksheet which I then renamed to 'patients'. The names above are a few of the names that were imported from the database.

  2. System administration report

    The Moat House is suited in an ideal location close to M25; with scenic surroundings it is a matter of convenience for the customers. As the hotel industry is becoming highly competitive, the hotel aims to offer low rates and high quality service at the same time and build a respectable reputation.

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