Database Design

Authors Avatar


UNIT 6 Database Design


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

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.


Customer Table:

Employee Table:

Order Table:

Product Table:

Supplier Table:

Join now!

This is the list of all the data I will include in the database. There are 6 entities with different attributes. The entities are in bold below with their attributes following:

Customer: (customer ID, contact name, customer address, city, postcode, date of birth, employee telephone number)

Employee: (employee ID, employee name, address, city, postcode, employee telephone number, hire date, date of birth)

Orders: (order ID, unit price, order date, required date)

Product: (product ID, product name, product description, stock)

Shipper: (shipper ID, shipper name, shipped date, shipped via, ship address, city, postcode, country, shipper telephone number)

Supplier: (supplier ID, ...

This is a preview of the whole essay