• 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. Financial Model to help organise the year eleven prom

    is shown in the appendix under D. that has been made efficient because its on a completely different sheet and has plenty of room for new data. The list of further investigations that I took is listed on the

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

    This wastes time and makes it easier for us to lose our files. Summary of advantages * Free access to a computer suite with a password protected account * A large hard-drive more than 1TB big which is used to store the whole school's hard drive, allowing each student 100MB

  2. GCSE Database Project ICT

    Data collection (Source data and identifiers, with details of input method, validation and key identifiers) Patient's data The patients Data will be retrieved from the hard-copy format of the patients records. The Secretary then manually adds them (or scans them in).

  1. Organising the database at Costsloadsless.

    hour because another customer will come in and they will have to remember there data as well as the first customers * They don't have to pay electricity on the computers therefore saving money for the business. * They will go threw a lot go pressure to remember everything!

  2. 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.

  1. Task 2 - Access Database - ICT CW

    The system already has a screen name and password protection installed and every user has their own name and password allocated to them so this will ensure safety of the system and the data. The employees will be able to access all the of the database as account are kept separately for management only.

  2. Create a Database based on a case study scenario on a language summer school.

    It also shows the manager in charge of the halls and is used to check information on what rooms are available. Flats This is the Flat entity. The role of this entity is to supply information on who is using the flats and the amount of flats available.

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