• 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 is a method of managing managers rather than the workforce at large. This is how Cadbury is managed. There are three basic elements in Management that Cadbury uses by objectives: > The identification of agreed goals by a

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

    language � How to finish a conversation appropriately � How to gather record information � How to establish and meet customers needs. If Asda did not use these skills appropriately, then the customers would think that the staffs are being very impolite and leave and shop elsewhere.

  1. ICT Coursework Two - Database Project

    The advantage of using barcode reading is that is not time consuming and the information is 100% accurate. The disadvantage of using barcode is that it is an extra cost and it will take time for the store to program the details to the barcode readings or to pay the

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

    and size of the business o Improve the standard of goods in order to improve customer satisfaction o To be the number one retailer in the world o To have a bigger slice of the market than the competition o To expand the business in all sectors of the business

  1. Analysing various company bills.

    It makes it look very professional if it is printed of in colour. Also certain backgrounds in this document would also be in colour. * The majority of the bill is left aligned, but some of the prices and bills to be paid are right aligned.

  2. Creating a Database

    also be about 3 search functions, one where customer details can be searched for, using their name or surname, the other search function can be used to search for orders and printing them, the orders should be searched for using an order number or customer surname, and the last search

  1. Entity Relationship Diagram

    Whenever the name of an item is entered instead of its ID, an application automatically translates the name into its Item_ID according to a list of known names of each item. (This table wasn't shown in the E-R Diagram to reduce the complexity.)

  2. Design Brief of solution to orders at a fitness club.

    The customer can just type what they preferred in the lines that are created for them. Also a good feature of word processing is that it can add logos underneath the writing, the company's logo can be merged into the form and this would be show the logo easily without wasting space.

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