• 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. I have been asked in this assignment to write a report about Asda and ...

    product is safe and reliable � Providing information about products and being able to give advice � Providing credit facilities where appropriate (allowing the customer to pay over a period of time) � Providing after-sales service- guarantees, spare parts and help lines.

  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.

    owners can recoup their money by selling their shares to others * Directors may be brought in as experts in certain fields * Produce goods at lower unit cost * Due to their size they can benefit from economies of scale, e.g.

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

    When Tesco's was set up one of its first aims would have been:- * To survive, basically they want to breakeven so they may not make a profit but they will not be in debt. * After this is accomplished it would be to make say �1000 pounds profit.

  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.

    The rest of the information like the addresses is also left aligned. So the majority of the bill is left aligned. * The orientation of the paper is portrait. * The size of the paper is A4. * The document has no header, but it has a footer, which is the meter point reference number and abbreviations.

  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