Modelling a Database for a Garment Manufacturing Company Essay Example for Free

Modelling a Database for a Garment Manufacturing Comp whatever testThis project leave alone contain information on the processing involved in modelling a selective informationbase for a Garment Manufacturing company. It give a like document how to create letter and fax templates that make the plump more efficient. The database lead hold stops roughly the suppliers, customers and stock etc. The enclothe style, size, how many order and dead hound dates for the garments to be finished will also be data which is stored in the t fitted. The end- exploiter Mr Jordan will be able to rec entirely information on any of his suppliers or customers. He will be able to bind 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 quested. Mr Jordan will be able to get away earn automatic every last(predicate)y to his customers and suppliers ab let on change state and orders. The database will be essential utilise Microsoft Access, the supplier and customer letters will be created in Microsoft Word and blendd 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. in that respect are nine workers, which Mr Jordan is in charge of.He takes care of every aspect of the duty himself apart(predicate) from parts of the accounts. solely of the other nine workers are arrange in a output 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. Information Technology is non utilize ofttimes as it could be at the present season. received procedures Customers get into contact with the company and talk about their order and the type of work required to relate their needs. This would include the design styles, reals and number of garments etc. Either the c ustomer provide their own materials or they practice out their order to Mr Jordan so he grass go to his supplier. The company then makes a exemplification garment which is shown to the customer if they are pleased with it then production starts, if not then amendments are make.At the moment if letters need to be sent out to customers or suppliers they are created individually preferably of making a template and exploitation mail-merge. From customer orders Mr Jordan notes down how many garments to be made, style of garment and size on paper, all of this documentation is kept in a folder. Image of Mr Jordans customers order detail sheet. image002.jpg The customer detail sheet is in tabular form where records are filled in about separately of the individual garments. For example data such(prenominal) as size, colour and style etc. would be held on the sheet. Mr Jordan takes care of all of these sheets in a folder. When they are out dated and are no, long-lasting of any use of goods and services they are disposed of. Strengths of the current ashes The strengths of the following system are All of the workers are used to the current system this means that nobody has to be trained to use any new equipment. For example none of the workers have to be trained on how to use computers. Most work is carried out by hand, this is a strength because if machines were used and any one of them broke down the production of the garments would have to be stopped. Weaknesses of the current systemThe weaknesses of the current system are All documentation is carried out on paper. All letter to customers are created individually. The bloodline does not use e-mail to communicate with its customers or suppliers. The business does not have a web site advertising its service and goods. If brisk business documents are lost, there is no backup. There is no form of a factory outlet. Objectives for the new system investment trust flesh out about the customers permanently. neckc loth details about the suppliers permanently. Easily be able to stimulation data concerning the ordering of materials. For example, style, material, size, colour etc. Be able to print out order details for the worker to use. Check his status with the suppliers. For example, material say etc. Send out letters to customers using mail merge for better efficiency. Print out an update of all deadlines to be met. End-substance abuser and functional requirements Store details about the customers permanently The database will need to store details of the spend a penny of the company, its address and the phone number. The user will some fourth dimensions want to display details of all the customers. It will be profitable if the customer company names are in alphabetical order.The user might want to send the customers letters which means that the post edict will have to be stored in a separate field. Store details about the suppliers permanently The database will store details about the s uppliers. For example the user will sometimes want to list the names in alphabetical order this means that the first name will have to be stored in a separate field to the middle and last name. If the user wants to send the customers letters to inform them about orders etc he will need to store the post code part of the address in a different field. Store details about the suppliers permanently The database will store details about the suppliers name and address. The suppliers table will be similar to the customer table. exclusively the user will send letters to the suppliers concerning the orderinf of raw materials etc. Easily be able to enter data concerning the ordering of materials. For example, style, material, size, colour etc. The user will advantageously be able to in put the data using Microsoft access instead of inputting the data on paper using a hand made table where he could be creating a more efficient table using access. Be able to print out order details for the w orker to use.The user will be able to print out details of the customers orders. For example, the number of garments, style, material etc. Check his status with the suppliers. For example, material ordered etc. The user should be able to access details about what he has ordered and what there is to pay at the touch of merelyton Send out letters to customers using mail merge for better efficiency. The user will be able to send out letters to the customers and suppliers pronto and efficiently using mail merge with Microsoft Access and Microsoft Word Print out an update of all deadlines to be met. The user will be able to print out a list of all deadlines to be met of all of the customers so the workers can work efficiently. Working Constraints End-user skill level The end-user(s) have used modern computers before based upon Windows 95. The user has used a modern computer to create letters and do calculations on Microsoft Excel. The user can only do simple-minded calculations and no thing in addition complicated. The user can create letters for suppliers and customers by using a record book processor. Mr Jordan is new to Microsoft Word but is getting the hang of it. He does not know such(prenominal) about the march on features of the computer software. Mr Jordan will need some form of support in using the advanced features. Mr Jordan can use any simple software, but will have to apply himself slightly to be able to get the hang of the advanced features. His experience with IT is very limited.The new system must be easy to fancy 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 Cann on 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 Jordans PC since in school Microsoft Office 97 is available. Time constraints The deadline for the project is to be completed for the 30th March. This gives approximately nine weeks for enlargement, 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 addresss 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 commensurate because it would me an that all of the field would have to be stored in one table. For example, supplier, customer and order fields will all be in the same table. This would then lead to there being data in the table that is not needed. For example, each time a customer made an order their name and address will have to be recorder in that record. If this type were to be used then it would take up a lot of space and hold useless data. It would also make it hard to search in the basic ways that you do. It will be hard to develop it so that the end-user will be able search for a certain supplier or customer without all of the other irrelevant details coming up. It would also make it increasingly difficult to use the mail merge facility.Concluding this we now know that a spreadsheet is not suitable for our purpose because it is skillful like a Flat-file if not nearly enough the same thing. Relational database This form of storage is much more flexible than Flat-file because it allows the data to be split up into separate tables. This is more efficient because each table contains information about a single entity. Now that information is in its individual tables, data redundancy is avoided. By linking all of the tables the whole structure will be able to be searched in a variety of ways. There are a great amount of relational database options in the marketplace but the two main ones are Microsoft Access and sacred lotus salute. These are both very suitable choices. Out of the two I will use Microsoft Access because it is more common compared with Lotus Approach and also because I am more familiar with the Microsoft environment. Overall I feel that Microsoft Access is easier to understand the instructions are clearer which makes it easier to follow.The terminology used in Access is better than that used in Lotus Approach. The form will be used to enter record of orders, suppliers and customers etc. This will make the business more organised and thus more efficient. The queries will be used to see who is ordering what and how much is owed to suppliers or owed by customers. To produce the templates for the letter I have chosen Microsoft word because it can easily be linked to Microsoft Access. It will also enable the letter to look professional as you can set any of your own preferences. For example, margin width, header and footer etc. Functions in Microsoft word such as MacroButtons, Date fields can make the end-user develop the letter template for his suitability. Other functions like AutoCorrect and AutoText will give the user an option for creating many types of customised letters for different kinds clients. My other options for word processors were Lotus WordPro, WordPad, Microsoft Publisher, Microsoft Paint and Word Perfect. These were not as suitable as Microsoft Word because some of them do not allow me carry out the advanced features that I wish to and also because most of them will not be able to link with Microsoft Access.