• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

On behalf of the tee shirt manufacturing company I have been asked to create a database complete with Entity Relationship Modelling.

Extracts from this document...


ICT IN BUSINESS IC340 COURSEWORK 1 ROBERT LOCHHEAD 0304949 Contents * Introduction * Phase 1 * Phase 2 * Phase 3 * Phase 4 * Effectiveness & improvements On behalf of the tee shirt manufacturing company I have been asked to create a database complete with Entity Relationship Modelling. Below is a brief overview of the company as it stands. The company makes t-shirts and have over 100 different designs, which come in 4 different sizes. With the business currently experiencing rapid growth Cathy Harris is starting to struggle with all of the paperwork as she is doing it all manually. Since the business is growing she feels that this method may no longer be appropriate for the business. If she carries on as she is then it could end up being more bother than it should be. In my report I have made up an ERM starting off at a very easy stage. I feel that this approach will help Cathy with the running of her business. ...read more.


This is because there is many order details for every design detail and for all of the different designs there is one product. Phase 3 Customers Order Order Design Product Details Details CustomerID OrderID OrderID* DesignID ProductID CustomerID* DesignID* ProductID* In this phase we have resolved all of the relationships to one to many, which must be done in order to have an efficient relational database and to help you get quick retrieval of any information that may be required. We have also merged the payment entity into the order details entity. In the next phase the attributes will be entered that are relevant to the Tee Shirt Manufacturing Company and we will review the entities to make sure they are normalised to third normal form. This is to make sure that we don't have any attributes that are not reliant on the primary keys. Customers Order Order Design Product Details Details CustomerID OrderID OrderDetID* DesignID ProductID Name CustomerID* DesignID* ProductID* Price Address Order Date Quantity Size Colour Phone No Delivery Date Description E-mail Payment Method Deposit Paid In this ...read more.


By using this new computerised system Cathy can look up in the database to see if customers pay on time, how long they have been a customer for how many orders they make and so on, so there is no end to the benefits that this system can bring to her business. This method of checking on customers wouldn't take very long compared to the length of time it would take the previous way. Having the new system would also be good for storage, all of the information that is needed is on computer where as before it would have been stored in filling cabinets or away in drawers. Also with this system all of the information in the database is easily updated or changed and if there is any errors they can be deleted. The most obvious improvement for this database would be upgrading the database system by making it more complex therefore it would give more information at the touch of a button. ...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 ICT in Business 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 ICT in Business essays

  1. Analysis of The Cadbury company.

    It will then be easier to use this process to work cohesively towards organisational goals. Tools in this section for helping you develop a coherent strategy for your organisation include the affinity technique, force field analysis, SWOT analysis, and strategic analysis.

  2. Analysis of The Cadbury company.

    Majority of the people who participated with my questionnaire liked milk chocolate. By 2011 Cadbury's is hoping to cut the amount of employees working at their factories by 15%. These employees will be replaced by specialist machines. There will be around 7,500 jobs around the world and 10 confectionary sites will close.

  1. I have been asked in this assignment to write a report about Asda and ...

    Do not shout at them. Also hearing logs are installed within the store so that this aides hearing impaired customers. � The blind ('visually- impaired '): blind people will be used to getting about in public, so ask them if they need help.

  2. Entity Relationship Diagram

    When an employee is responsible of making an order, he/she makes decision on how many and from which supplier to order the items. A specially written application is used to suggest the cheapest supplier for a particular item as a reference according to a list of most up-to-date prices of each item provided by multiple suppliers.

  1. Investigate Coca Cola Company.

    bulk buying, cheaper borrowing The disadvantages of a public limited company are: * There are a number of legal requirements to fulfil in setting up a company * Regulations mean that a company is more expensive to set up than a sole trader or partnership, although the cost may be

  2. In this report I intend to create a detailed report of Tesco's.

    It has been a sole trader business a partnership an ltd company and now it's a plc. However there are a few types of business that Tesco's hasn't been. * A charity: this is obviously because Tesco's is a profit organisation and wouldn't want to give away all there profit.

  1. Analysing various company bills.

    Also text is used in the addresses on the bill and also to tell the receiver what they are getting charged for. * This document does not use charts * The document uses a table to present the information in.

  2. Creating a Database

    The users must be able to input the above data, and they should also be able to edit information as well, they should be able to; * Change customer details -They will be able to ADD, EDIT & DELETE; * Customer Details * Customer Order * Stock Details There should

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