• 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. Designing a booking system for an Estate Agent.

    To store their data and information they store it on a hard drive which then gets backed up into another hard drive so they have two copies. 1.6 Requirements of the client. The client has a few requirements that they wish to be in place.

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

    PAY03 - R02 Users must be able to enter card details such as card number, expiry date, security code (CVS) PAY03 - R03 Users must be able to view the photos selected and the total cost of the photos being purchased.

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

    Devices Input devices will be needed to complete the jobs for the database, these are some input devices, which could be used: 1.

  1. I was hired by Mr Davies to create a website for a newly built ...

    Type in all the pages names. Pick out the same layout as used on the home page Have navigation page on the website. Overview of the situation Sam Purvis, Hailey's husband, has started a new business in the local town. It is called `Making Your Name` (MYN).

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

    A paper based system has been implemented for the majority of the time the shop has been running, a computer based solution was trialed for a few months but Mr. Bradshaw didn't take a shine to it. Mr Bradshaw is the client because he is the individual who asked me

  1. ICT Security Report

    This type of hacking can be seen as malicious but of a vandalising nature as he did not use it for fraudulent or theft purposes. Another example of extreme hacking is was during 1994, when the security of Citibank, the fifth largest bank in the world was breached.

  2. Home Office LTD company. Database

    This is a screenshot of the Visual Basic macro, which takes the user from the main menu to the order form sheet. This screenshot shows the macro that takes the user to the yearly review sheet from the main menu.

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