• 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. Business blue print document for the implementation of SAP R/3 (4.6B) payroll at Mastek ...

    A wage type classifies personnel expenses according to tax, insurance, labour legislation, pay scales and other operational characteristics. In Payroll, wage types are also used for saving additional information in the payroll results, for example, in the form of cumulation wage types (total gross amount or gross tax amount), or

  2. Computing Project

    members who have not yet returned their DVD back to the shop. 7. Security and Integrity Plan I will try to keep the data as accurate as possible by using validation check and input masks.. I will implement a security feature on the Login Form which requires the correct username and password to prevent unauthorised access to the system.

  1. ICT Sample Work Welcome Centre Requirements

    Costs per Delegate o Total Food Costs o The Net Amount, VAT Amount and Gross Amount on the Quotation. * On different data entry forms, automatically look-up and display details previously entered, without having to re-enter * Ensure all booking information should only be entered once, and the quotation must

  2. Smart Card System

    If any of the data is not matched the data in server database, the user would not be able to log in the system. III. Change User Name and Password In this feature, there will be a change password system that allow the user connect to the server to change their username and password.

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

    I also did a customer questionnaire to find out the views of the public and customers. I got many people to fill my customer questionnaire in and left a copy inside my folder to show an example of what it looked like after a member of the public filled it in.

  2. Computing Project

    Availability (AvailableSlots, NextLessonBooked) RECORD STRUCTURE Instructor Field name Data type Size format Description AvailableSlots Date/time, Date time Shows what dates and times are available NextLessonBooked Date/time, Date time Name of student and the day, date and time of their next lesson Student Field name Data type Size/format Description Student name

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

    Visa or Switch. If Mr Hull can have a credit card payment system set up before the implementation date of Easter he would stop receiving cheques and cash which will speed up orders again as he does not have

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

    Fig 1. On both company sites users need to be able to share peripheral devices such as printers and scanners for this reason a star topology will be implemented in both offices Star Topology: A star topology is when each device is connected to a central routing device for example a switch, which would then forward the data to the appropriate device.

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