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

Modelling a database for a Garment Manufacturing company.

Extracts from this document...


Modelling a database for a Garment Manufacturing company. Task Outline This project will contain information on the processing involved in modelling a database for a Garment Manufacturing company. It will also document how to create letter and fax templates that make the work more efficient. The database will hold details about the suppliers, customers and stock etc. The garment style, size, how many ordered and deadline dates for the garments to be finished will also be data which is stored in the table. The end-user Mr Jordan will be able to recall information on any of his suppliers or customers. He will be able to link what the customer orders to what he has to order from his suppliers or if the customers provides their own supplies he will see the amount needed. Mr Jordan will be able to send letters automatically to his customers and suppliers about work and orders. The database will be developed using Microsoft Access, the supplier and customer letters will be created in Microsoft Word and merged with data from Microsoft Access. Background to Organisation The Garment Manufacturing Company is called Air Ltd, it is located in Stratford and is owned by Mr Jordan. There are nine workers, which Mr Jordan is in charge of. He takes care of every aspect of the business himself apart from parts of the accounts. All of the other nine workers are arrange in a production line around the work place. Mr Jordan deals with the customer enquiries, orders and suppliers etc. At the moment letters are created from scratch in Microsoft Word. ...read more.


His experience with IT is very limited. The new system must be easy to understand so that the vital functions can be successfully carried out. No errors should occur, everything should be clear. Availability of hardware and software The previous software that Mr Jordan was using is called Lotus Word Pro96 but has recently purchased a new PC with Microsoft Office 2000 on it. This new computer is manufactured by Compaq and has the following specification: � 900Mhz processor � 64Mb RAM � 13Gigabytes HDD � 17 inch VDU � Cannon Bubble Jet printer BJC4200 � Microsoft Office 2000 Mr Jordan has an ideal specification if not too good for the functional requirements. The software in the school will easily correspond with Mr Jordan's PC since in school Microsoft Office 97 is available. Time constraints The deadline for the project is to be completed for the 30^th March. This gives approximately nine weeks for development, testing and documentation. Documentation will take up a great deal of the time this means that time will be a major constraint upon the completed system. Initial time plan Consideration of solutions Data such as company names and address's will need to be stored along with ordering details etc. this means that a database must be used. A word processor will also be needed because letters have to be created for the customers. Mail merge could be used. There are two choices for the type of database: relational or Flat-file. Flat-file A Flat-file database will not be suitable because it would mean that all of the field would have to be stored in one table. ...read more.


Enter date Self-Validating and Presence Check Time Given Enter amount of time given Profit Available Currency Enter amount Self-Validating and Presence Check Order Table Field Name Data Type Comments Validation CustomerID AutoNumber Automatically generated Primary Key Self-Validating Style Text (size 50) Enter company name - maximum 50 characters Presence check Material Text (size 50) Enter company name - maximum 50 characters Presence check Colour Text (size 40) Enter company name - maximum 40 characters Presence check Size Number Number Presence check Fittings Text (size 70) Enter company name - maximum 70 characters Presence check Supplier Table Field Name Data Type Comments Validation SupplierID AutoNumber Automatically generated Primary Key Self-Validating Supplier Name Text (size 40) Enter company name - maximum 40 characters Presence check Contact Name Text (Size 60) Enter company name - maximum 60 characters Presence check Address 1 Text (Size 30) Property number and road name Presence check Address 2 Text (Size 20) Town Presence check Address 3 Text (Size 20) Region Presence check Post Code Text (Size 6) Enter Post Code Format Telephone Number (Size 14) Enter the land line phone number Format Fax Number (Size 14) Enter the land line phone number Format E-mail Text (size 50) Enter the e-mail address Presence Check Account Number Number (Size 8) Enter number (8 digits) Format and Presence Check Queries Query Name Type Tables Used Action Payment Overdue Select Forms General Properties All of the forms will contain the following features: Background - Transparent Titles - font = Times New Roman; Size 18 Labels - font = MS Sans Serif; Size 8; Type plain Text Boxes - Style = sunken / raised; Backstyle = flat; sizes 3 or 4cm Buttons - Width = 2.3; Height = 0. ...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 Computer Science 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 Computer Science essays

  1. Computing Project

    The validation check will be performed into the 'Login' button on the login form so that the validity of the username and password can be checked. This will limit the chance of invalid access to the system. So if an incorrect username or password has been entered an error message

  2. Business blue print document for the implementation of SAP R/3 (4.6B) payroll at Mastek ...

    * Financial Accounting (FI) * General Ledger Accounting (FI-GL) * Accounts Payable (FI-AP) * Accounts Receivable (FI-AR) * Special Ledger (FI-SL) * Controlling (CO) INTEGRATION OF THE COMPONENTS IN POSTING TO ACCOUNTING Payroll (HR) The principal organizational concept in Payroll is the wage type.

  1. System I designed in order to produce a promotion package for her newly formed ...

    I will show this by doing the following: - * Do printouts to show an exploration of data in a computer database to obtain specific information. * Do printouts that I have thoroughly checked and edited the databases. (I.e., correct errors, add and delete records, fields).

  2. Infernowear is a new company run by a self-employed creative designer aiming to producing ...

    Table names: Customers: The customer's table will have the following fields: * Customer ID (this will be an auto number) * Contact first name (text form) * Contact last name (text form) * House number (numerical) * Street name (text form)

  1. The purpose of this coursework is to design a network for a small to ...

    equipment will increase data rates which will require better cables and replacing cabling under floor or inside walls will be a difficult task and could cost the company more money in the long run. To connect the two floors in the main office building the category 6 Gigabit cable will be used.

  2. AS ICT Corsework - Mr Brookes K-Fit Ltd

    The beauty of a website is that you can have the ability to incorporate a huge number of ideas into one place therefore if anything you feel is not right, all it takes is a little bit of tweaking and setting it right.

  1. ICT Sample Work Welcome Centre Requirements

    What are the problems that ICT could help to solve? One of the key problems is that a manual booking system is used, whereby booking information is recorded in a paper-based diary. The information is therefore not easily sharable and handwriting will become messy as bookings are amended or cancelled.

  2. ICT Sample Work India Red

    * Search which allows the entered data to be automatically displayed, which will reduce time looking for previous orders and stops the user from flicking between screen. * Automatically calculate and display information in specific fields below to reduce data input therefore reducing time and also mistakes.

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