Modelling a Database for a Garment Manufacturing Company Essay

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 Org anisation 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. Information Technology is not used much as it could be at the present time. Current procedures Customers get into contact with the company and talk about their order and the type of work required to meet their needs. This would include the design styles, materials and number of garments etc. Either the customer provide their own materials or they set out their order to Mr Jordan so he can go to his supplier. The company then makes a sample garment which is shown to the customer if they are pleased with it then production starts, if not then amendments are made. At the moment if letters need to be sent out to customers or suppliers they are created individually instead of making a template and using 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 Jordan’s customers order detail sheet. [image002.jpg] The customer detail sheet is in tabular form where records are filled in about each of the individual garments. For example data such 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, longer of any use they are disposed of. Strengths of the current system 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 system The weaknesses of the current system are: All documentation is carried out on paper. All letter to customers are created individually. The business 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 vital business documents are lost, there is no backup. There is no form of a factory outlet. Objectives for the new system Store details about the customers permanently. Store details about the suppliers permanently. Easily be able to input 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 ordered etc. Send out letters to customers using mail merge for better efficiency. Print out an update of all deadlines to be met. End-user and functional requirements Store details about the customers permanently The database will need to store details of the name of the company, its address and the telephone number. The user will sometimes want to display details of all the customers. It will be useful if the customer company names are in alphabetical order. The user might want to send the customers letters which means that the postcode will have to be stored in a separate field. Store details about the suppliers permanently The database will store details about the suppliers. 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. But the user will send letters to the suppliers concerning the orderinf of raw materials etc. Easily be able to input data concerning the ordering of materials. For example, style, material, size, colour etc. The user will easily be able to in put the data u sing 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 worker 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 button 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 quickly 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 calculations and nothing too complicated. The user can create letters for suppliers and customers by using a word processor. Mr Jordan is new to Microsoft Word but is getting the hang of it. He does not know much about the advanced features of the 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 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 co nstraint 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. 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 ab le 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 just 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 market but the two main ones are Microsoft Access and Lotus Approach. 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 Perfe ct. 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.

Definitions of Whats Ungrammatical in English

Definitions of What's 'Ungrammatical' in English In descriptive grammar, the term ungrammatical refers to an irregular word group or sentence structure that makes little apparent sense because it disregards the syntactic conventions of the language. Contrast with grammaticality. In language studies (and on this website), examples of ungrammatical constructions are usually preceded by asterisks (*). Judgments regarding ungrammatical constructions are often subject to gradience. In prescriptive grammar, ungrammatical may refer to a word group or sentence structure that fails to conform to the proper way of speaking or writing, according to the standards set by some authority. Also called grammatical error. Contrast with correctness. Examples and Observations Designating a sentence as ungrammatical simply means that native speakers tend to avoid the sentence, cringe when they hear it, and judge it as sounding odd. . . .Calling a sentence ungrammatical means that it sounds odd all things being equalthat is, in a neutral context, under its conventional meaning, and with no special circumstances in force.(Steven Pinker, The Stuff of Thought: Language as a Window Into Human Nature. Viking, 2007)Sentences . . . are simply the highest-level expressions of a language, and an ungrammatical string is a morpheme sequence which fails to constitute a meaningful expression of any kind.(Michael B. Kac, Grammars and Grammaticality. John Benjamins, 1992) Examples of Grammatical and Ungrammatical Sentences With Reflexive Pronouns Grammatical Ungrammatical(Terri L. Wells, L2 Acquisition of English Binding Domains. Morphology and Its Interfaces in Second Language Knowledge, ed. by Maria-Luise Beck. John Benjamins, 1998) The smart student thinks that the teacher likes himself.The very happy mother said that the girl dresses herself.The young child said that the pretty woman hurt herself.The man in the blue jacket said that the dog bit himself.The crying father said that the younger boy cut himself.The woman thinks that the student does not like herself.The doctor said that the old man shot himself in the foot.The lawyers think that the four policemen shot themselves.*The man thinks the boy does not like that stupid himself.*The woman said that the little girl saw yesterdays herself.*The taxi driver said that the man hit that careless himself.*The girl said that the teacher laughed at that funny herself.*The soldiers know that the generals like todays themselves.*The student said that the athlete hurt that stupid himself.*The mother wrote that the child laughed at that slow herself.*The man said that the boy was angry with the lazy himself. Distinguishing Between Descriptive and Prescriptive Grammar The sentence below is a garden-variety English sentence, which is descriptively grammatical to any English speaker . . .. I eat bacon and eggs with ketchup. We can form a question based on this sentence as follows: What do you eat bacon and eggs with? This sentence is descriptively grammatical but violates a prescriptive rule; recall that for some, ending a sentence with a preposition (in this case, with) is prescriptively ungrammatical. But now consider this sentence: I eat bacon and eggs and ketchup. When we try to form a question we get the following: *What do you eat bacon and eggs and? No English speaker would utter this sentence (hence the *), but why not? The source sentences look exactly the same; the only difference is that ketchup follows with in the first sentence, and and in the second. It turns out that with, a preposition, functions quite differently from and, a conjunction, and the distinction between the two is part of our unconscious knowledge of English. Studying this unconscious knowledge, revealed in puzzles like this one, allows us to construct a model, or theory of descriptive grammar, a model that attempts to explain why we quite naturally produce grammatical sentences such as What did you eat your bacon and eggs with? but not ungrammatical ones like What did you eat your bacon and eggs and? (Anne Lobeck and Kristin Denham, Navigating English Grammar: A Guide to Analyzing Real Language. Blackwell, 2014)

Literal Meanings and Pedantic Precision

Literal Meanings and Pedantic Precision Literal Meanings and Pedantic Precision Literal Meanings and Pedantic Precision By Mark Nichol Earlier this year, the Merriam-Webster website, which, along with its paper-and-ink version, is notorious for its laissez-faire approach to word usage, expressed an intriguing argument in one of its Usage Notes: Chill out about preserving the â€Å"original† meaning of words. If one were to insist that words be used only in their initial sense, one would discourage me from writing â€Å"Chill out,† because I am not alluding to temperature, and the literal meaning of the verb chill is not â€Å"calm down,† but â€Å"make colder.† That’s the point of the post, which argues that, for example, aggravate shouldn’t be required to apply only to making something worse- it’s fine to use it when describing mere irritation. The argument goes that if the restriction is to be taken to its logical conclusion, aggravate should mean only â€Å"weigh down,† because that is its original sense. (The grav in aggravate, you see, is the same as the grav in gravity.) By the same token, the lackluster utterance of â€Å"Awesome† in response to, well, virtually any pronouncement- no exclamation point is necessary, because the comment was likely nothing like an exclamation- is acceptable. Apparently, the interest of some in preserving that term to describe something truly remarkable is invalid; after all, the original meaning was â€Å"inspiring awe,† and to employ the word for something merely spectacular demonstrates disloyalty to its etymological origins. (Awful would also have the same restriction, because it literally means â€Å"full of awe.†) I see the point, but I also feel that indiscriminate dilution of a word’s distinct meaning paints writers into a corner. Once awesome, indiscriminately mumbled in response to myriad comments undeserving of such a potentially powerful reply, is devalued, what is left to describe something that is, well, truly awesome? On the one hand, this weakening of a word challenges the writer to find- or even craft- a suitable synonym, but it might not be long before the replacement is in turn drained of its strength. That’s why I never write (or say) anxious when I mean eager; the former term patently alludes to anxiety, not anticipation. But I admit inconsistency- using the last word in the previous sentence reminds me that anticipation literally means not â€Å"the state of looking forward to something† but, rather, â€Å"the act of foreseeing.† (Anticipere, the Latin verb from which it is derived, means â€Å"take before.†) Nevertheless, I try to use precise, unambiguous words and will continue to preserve distinctions when possible, and I encourage careful writers to do so as well. Want to improve your English in five minutes a day? Get a subscription and start receiving our writing tips and exercises daily! Keep learning! Browse the Writing Basics category, check our popular posts, or choose a related post below:20 Computer Terms You Should Know50 Nautical Terms in General Use20 Movies Based on Shakespeare Plays

History of Adhesives and Glue

History of Adhesives and Glue Archeologists excavating burial sites from 4000 BC have discovered clay pots repaired with glue made from tree sap. We know that the ancient Greeks developed adhesives for use in carpentry, and created recipes for glue that included the following items as ingredients: egg whites, blood, bones, milk, cheese, vegetables, and grains. Tar and beeswax were used by the Romans for glue. Around 1750, the first glue or adhesive patent was issued in Britain. The glue was made from fish. Patents were then rapidly issued for adhesives using natural rubber, animal bones, fish, starch, milk protein or casein. Superglue - Synthetic Glue Superglue or Krazy Glue is a substance called cyanoacrylate that was discovered by Dr. Harry Coover while working for Kodak Research Laboratories to develop an optically clear plastic for gunsights in 1942. Coover rejected cyanoacrylate because it was too sticky. In 1951, cyanoacrylate was rediscovered by Coover and Dr. Fred Joyner. Coover was now supervising research at the Eastman Company in Tennessee. Coover and Joyner were researching a heat-resistant acrylate polymer for jet canopies when Joyner spread a film of ethyl cyanoacrylate between refractometer prisms and discovered that the prisms were glued together. Coover finally realized that cyanoacrylate was a useful product and in 1958 the Eastman compound #910 was marketed and later packaged as superglue. Hot Glue - Thermoplastic Glue Hot glue or hot melt adhesives are thermoplastics that are applied hot (often using glue guns) and then harden as they cool. Hot glue and glue guns are commonly used for arts and crafts because of the wide range of materials that hot glue can stick together. Procter Gamble chemical and packaging engineer, Paul Cope invented thermoplastic glue around 1940 as an improvement to water-based adhesives that were failing in humid climates. This to That A nifty site that tells you what to use to glue anything to anything else. Read the trivia section for historical information. According to the â€Å"This to That† website, the famous cow used as the trademark on all Elmer’s glue products is actually named Elsie, and she is the spouse of Elmer, the bull (male cow) who the company is named after.

Storage Area Network of Carlson Companies Assignment - 1

Storage Area Network of Carlson Companies - Assignment Example This paper illustrates that the effective way to implement a SAN requires computing different or all the existing servers by deploying multiple servers thereby allowing them to organize automatically by creating unconnected information islands. However, in the case of Carlson SAN approach, each of these created islands will be accessible to only one computer; therefore, if computer B needs to use information created by computer A, then computer B needs to copy such information from computer A. In this case, the computer A and B are not connected to a central server, but to independent servers. However, the current implementation of SAN requires a mode of operation or computation where the sourcing of information is from a central point, but accessing such information must be with a high degree of security. Moreover, the Carlson SAN approach mode of implementation requires backup, inter-process communication, and data transfer between different data source; however, the today’s implementation will not require backup since that data or the computing information will be in the cloud. Cloud computing does not require backup or interruption of systems or the flow of information during such implementations as such data or inhumation will be readily available to both the organization’s management and customers in the cloud. Cloud computing allows server Virtualization that does not require physical servers that reducing the interference of worker at some point of network maintenance or advancement.

Pre-Socratic and Aristotles Philosophy Essay Example | Topics and Well Written Essays - 500 words - 1

Pre-Socratic and Aristotles Philosophy - Essay Example The philosophers favored a logical or analytical approach in their explanation of occurrences (Sproul, 2000). Consequently, Plato’s philosophy was not based on Greek mythology. In addition, pre-Socratic philosophers were inquisitive about the essence of things. For instance, existence, source, and plurality of things were fundamental pre-Socratic questions. Ideally, Plato’s philosophy attempts or responds to these questions. In conclusions, Plato’s philosophy is a refinement of the pre-Socratic philosophy. Plato’s philosophy supports an ontological dualism, which proposes the existence of two forms of realities/worlds. In this sense, things exist as either ideas or tangibles. Each of this existence represents unique worlds namely intelligible or the sensible world. The intelligible world represents the universals and invisible realities (forms). Under this existence, things cannot change their state or appearance since they are neither material nor tempora l (Sproul, 2000). Thus, the intelligible world preserves eidos and particulars. Indeed, Plato believed that the abstracts are the foundations of the sensible world and that it is only through them that people acquire genuine knowledge. Aristotle’s philosophy was established natural science for thousand years. Key to his science is the nature of change and motion. In his philosophy, Aristotle discovered the fundamental principle of change that direct natural bodies. The principle holds in both the celestial and terrestrial, living and the inanimate. Under the Aristotelian physics, terrestrial objects move towards different part of the universe according to their composition. For instance, earth being the heaviest material, moved towards the center of the universe. On the contrary, ‘fire’ the lightest element tends to move away from the center of the universe.  

Social Networks Research Paper Example | Topics and Well Written Essays - 1750 words

Social Networks - Research Paper Example It has by and large bridged the gap between willing buyers and sellers hence distance has proved to be no longer a challenge in transaction because it has enhanced communication between parties involved. Besides, the internet has proved to be man’s greatest innovative achievement and a popular instrument used in the performance of numeric functions and to enhance communication in the banking sector. Far from this, the internet which is synonymous to cyberspace has even dominated the health sector. It facilitates the distribution of power, enforcement of law and even delivers or retains very confidential information. However, since it is a public utility, the internet has caused much havoc to mankind because sometimes it has not been used for purposes for which it was intended. Some cyberspace users have abused the internet and have thus rendered it a vulnerable social, political and economic tool. Cyber threat has remained a top concern in most nations because of security conc erns. Research and study have found out that cyber security has continued to increase in intensity and sophistication with time. Its gravity has been witnessed everywhere hence this calls for great security concern in the entire world. As we can see, the ever-growing need to use internet services in our everyday life places individual users and even the government and organizations into a task of combating risk factors associated with fraud and sabotage of important information and sometimes the security threat to a person (Yar, 2006). Cyber space hackers have more than often hacked and tampered with confidential government and corporate information, which they use to cause security threats targeting not only government officials but also the common man. Cases of terrorism have continued to increase with time. This is alarming since massive loss of people and properties have been witnessed. The terrorists have routinely targeted business hubs and top government institutions. Victims of cyber attacks have reported that they have also lost massive investments in the process of cyber attacks. This is a matter of concern since no measures placed have proved reliable to curb this scam. According to a report by the National Academy of Sciences (2010), it has been noted that not even the renowned tech-savvy individuals and organizations have managed to stay immune to cyber attacks. Victims of cyber attacks have included important service providers like telecommunication companies, Google, travelling industries, defense and even the banking sectors. This shows that nobody is immune to threats caused by cyber attacks. However, some of the experts causing cyber threats have tried to justify their actions as not being in any way related to threat in the cyber. Some of the terms used to refer to these techs savvy that have sometimes used the internet for purposes other than what is intended have tried to create a distinction between themselves and real criminals. For inst ance, terms which have always confused computer users are hackers and crackers. As far as computer security is concerned, programmers have tried to bring out their argument that someone who tries to break into other computers is better termed as cracker because they use it for ill intentions. According to such experts, computer crackers are like criminals because they use the internet to cause security concerns to other internet users hence are sometimes called black hats. They cause security