• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20
  21. 21
  22. 22
  23. 23
  24. 24
  25. 25
  26. 26
  27. 27
  28. 28
  29. 29
  30. 30
  31. 31
  32. 32
  33. 33
  34. 34
  35. 35
  36. 36
  37. 37
  38. 38
  39. 39
  40. 40
  41. 41
  42. 42
  43. 43
  44. 44
  45. 45
  46. 46

Database Design

Extracts from this document...


AVCE ICT UNIT 6 Database Design HMV I have chosen to design a new database system for HMV for this assignment so that they will be able to store information about their customers, suppliers, employees, order details, different products and shippers. HMV is the UK and Ireland's leading specialist retailer of Music, DVD/Video, computer games and related products. The company operates around 200 stores in key shopping locations nationwide, covering up to over 1million sq. ft. of trading space, as well as having a successful online store at www.hmv.co.uk. HMV's very first store was officially opened in July 1921 by the celebrated British composer, Sir Edward Elgar on London's Oxford Street. Since that time, the company have become better and more popular with the public. HMV is dedicated to offering its customers access to the widest possible range of recorded music titles, DVD's and computer games across all formats. Current problem with the company The main problem with the company currently is that most of their business is done by paperwork. This can lead to the staffs becoming very busy and not having time to do other work. It is also space consuming because the company will have to buy files and filing cabinets which may get full quickly and they may have to pay more in order to get extra space for the files and records. Other then these two problems because of it, there is also the fact that it is time consuming as well and will be difficult to find the information they require quickly. This can prove to be a big problem for the company since they are a big business with lots of customers and employees etc. So if they do not organise their filing system properly then it may lead to them losing customers and therefore losing profit and sales. Data Requirements The database will be based on a list of entities and their attributes like; order number, product name, product ID, supplier name, supplier address, customer ID, employee first name, second name, employee ID, employee birth date, employee address and phone number. ...read more.


I clicked Next because I didn't need any so it took me to the next page which was allowing me to sort records in either ascending or descending order. Next I was asked how I want the layout of my report to look. I selected Columnar and clicked on Next. After this I was asked what style I would like to use. I selected Corporate and clicked Next again. Finally I was asked to give the report a name. I named it Invoice and clicked Finish. This is what the Invoice Report looked like once I had finished. Forms Once all of this was done, I began creating my forms. I made my Main Menu page first so that I know what will be going where. I started by clicking on Forms, then I clicked on Create form in Design view Once I clicked on this it took me to this page, where I was able to edit it and add what ever button etc. I wanted by using the Toolbox I turned the background to pink so that it goes well with the HMV logo I added Since I had started this, I had to begin creating the rest of the forms that will be linked to the buttons created here. I started with the Customer Details form. To do this I had to click on Create form by using wizard which took me to this window I added all the available fields in the order required into the selected fields section and clicked Next. I was then taken to a screen like this Here I can choose what kind of layout I would like to use for my form. There are six different types of layouts, but I chose Columnar for mine. After this window I was asked what style I will like for he form, I selected the style I wanted and clicked Next The final step was to give my form a title, which I named 'Customer Details' then clicked ...read more.


Once you have finished on this form you may exit the page by clicking on the 'Stop' button at the bottom. By doing so you will return to the main menu again. Next button on the main menu screen is the Employee Details page. Once you have clicked on this button, the employee details form will appear From here you may use the bottom buttons to; find a record, add a new record, delete a record, print a record or save the form. Once you have finished you can click the 'Stop' button to exit. Next button on the main menu is the Shipper Information button. This button will take you to the following form On this form you may which to; find a shipper, add a new shipper detail, delete a shipper, save the form, or print the form from the buttons near the bottom. Click 'Stop' again and you will return to the main menu screen. After the shipper information button there is the Supplier Information form. When you click on this button you will be taken to the following form Here you may; find a supplier, add a new supplier, delete supplier information, save the form, or print the form. Then you may exit from the 'Stop' button. Order Details is next on the list, from there you will be able to find a specific order, add a new order information, delete an order, print an order, save the form, or view the invoice report. Press 'Stop' to return to the main menu again. Product Details is the last button on the form. It takes you to the page with details about the products. Here you may; find a new product, add a product, delete a product, save the form, or print the form. Once you have finished you may click the 'Stop' button to return to the main menu again. Once you have finished using the whole database system, you may wish to exit it completely by clicking on the 'Exit' button on the bottom of the main menu screen. ?? ?? ?? ?? 2 ...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. Analysis of market, environmental forces, competitors, marketing mix and consumer implementation.

    5 Alternative strategies 5.1 Sony The launch of PSX2 has meant a significant fall in demand for the PSX leading to the fall in prices of PSX software. This has already begun with many games now priced at £30 or under.

  2. Home Office LTD company. Database

    Along with the code, there is a description of the product, the price and the quantity remaining. The sheet allows the user to keep track of what products the company sell, as all of the products available would be listed.

  1. Designing a booking system for an Estate Agent.

    So what kind of interaction do you have when using computers? Well, aside from doing our usual tasks whilst on the job to communicate with other employees, branches and the head office we often use email to send reports, presentations and other documents.

  2. Background and investigation for designing a database for a DVD rental shop.

    Her main role consists of dealing with customers and making rentals. She will be adding and editing members, DVDs and rental in the proposed system. The final user of the system will be Jason Bradshaw, Mr Bradshaw's son. He currently works on a part time basis, as he will not

  1. Video World Database as ICT project.

    Database Design The Database contains FOUR entities: * Staff * Videos * Members * Rentals These are related as shown below (in normalised form illustrating many to one relationship from rentals table to the other three). These relationships will be confirmed in the database relationship facility.

  2. ICT Security Report

    Then he logged on numerous times over a period of weeks and transferred approximately $3.7 million through wire transfers to various accounts his group controlled in the United States, Finland, the Netherlands, Germany, and Israel. Levin and his accomplices can be again as malicious hackers but this time as those

  1. A relative of mine works for a corporate firm on CRM (Customer Relationship Management) ...

    them to put projects without immediate and obvious returns on investments on the back burner; and though many companies have begun implementing CRM solutions, they are still losing customers in droves, begging the question of whether CRM implementations were worthwhile in the first place.

  2. Design a computer system for a video hire shop.

    Vinny will be able to keep customer information lists, detailing contact information, stats on the customers videos, lists of regular jobs that need to be performed i.e. check who has videos out; in order that notices can be sent using mail merge.

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