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

    Cadbury has already reduced their carbon emissions by nearly 15% between 2000 and 2005. On July 2nd 2007 Cadbury Schweppes pledged a 50% reduction of net absolute carbon emissions by 2020 with a minimum of 30% from in-company actions and by aiming to reduce not just the relative energy intensity

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

    It is an attitude which should run through the whole organization from the managing director to the most junior sales assistant. The 21st century customers have increasingly high expectations, so customer service is going beyond these expectations and not simply meeting them.

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

  2. Investigate Coca Cola Company.

    to the general 'public', therefore this form of company is usually associated with family run businesses. Whilst the Public Limited Company can sell its shares to the general public on the Stock Exchange, providing the potential for far greater finances to be raised.

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

    This is a good idea but it means that Tesco managers aren't in as much contact with the shops as they were before. Also as Tesco's sells so many different things it would be very complicated organising all of there things.

  2. E-Commerce Overview.

    I researched many e-commerce related web sites along with some companies that conduct statistical studies. Some of the e-commerce web sites that I looked into are E-Commerce Times, eRetail, and eMarketer. The statistical research firms that I researched are Forrester Research and Jupiter Communication.

  1. Analysing various company bills.

    There is also a line spacing between each paragraph in the information at the side of the bill. * The addresses and telephone numbers are positioned at the top of the bill. The main information is then positioned in the centre of the bill and then the information about the future is positioned at the side of the bill.

  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