Tata Steel Case Study Analysis Essay Example

Goodbye Steel Case Study Analysis Paper Presentation The Tata Group is an enormous gathering of organizations that command markets in India. The association has set up itself as a pioneer in business sectors, for example, the carrier business, inn, programming, speculation, and steel industry. There is a long history of corporate duty inside the gathering, and it is nothing unexpected that all Tata organizations have received a Tata Code of Conduct just as numerous worldwide principles. Goodbye Steel is one of twenty-eight significant organizations inside the Tata Group. Established in 1907, it is the biggest private segment steel organization in India. Tasks are spread the nation over, with the steel producing unit at Jamshedpur, and other assembling and mining exercises arranged in the conditions of Jarkhand and Orissa at eight areas. The Tata Group base camp is situated in Mumbai, Maharastra. This paper gives a review and examination of the bookkeeping issues that Tata Steel is confronted with in the wake of getting an outside organization. Organization Profile Tata Steel, joined in 1907 by Shri Dorabji Tata, is Indias biggest private part steel organization having a place with the Tata Group. The organization makes completed steel, both long and level items like hot and cold moved loops and sheets, electrifies sheets, tubes, wire poles, development re-bars, rings and course. The organization advertises its items in brands like Tata Steelium, Tata Tiscon, Tata Pipes, and so forth. The organization is among the least cost makers of steel on the planet. Its fundamental plant is situated in Jamshedpur, having an assembling limit of 5 MTPA (million ton for every annum) while its handling units, hostage iron mineral and coal mineshafts are situated in the conditions of Orissa, Jharkhand, Maharashtra, Gujarat and West Bengal. We will compose a custom paper test on Tata Steel Case Study Analysis explicitly for you for just $16.38 $13.9/page Request now We will compose a custom article test on Tata Steel Case Study Analysis explicitly for you FOR ONLY $16.38 $13.9/page Recruit Writer We will compose a custom article test on Tata Steel Case Study Analysis explicitly for you FOR ONLY $16.38 $13.9/page Recruit Writer With its administrative center situated in Mumbai, the organization capacities through a system comprising of exchanging arms and activity and ventures destinations spread across nations in the landmasses of Asia, Europe and America. Aside from Steel there are six Strategic Business Units or divisions for Bearings, Ferro Alloys and Minerals, Rings and Agrico, Tata Growth Shop, Tubes, and Wires. It works in excess of 20 nations and has a business nearness in more than 50. In the previous scarcely any years, Tata Steel has put resources into Corus (UK), Millennium Steel (renamed Tata Steel Thailand) and NatSteel Asia (Singapore). With these, the organization has made an assembling and showcasing system in Europe, South East Asia and the Pacific-edge nations Problem Tata Steel Faces Tata Steel is confronted with an intense, and to some degree complex, issue. The organization has worldwide desire. I mean the organization needs to set up itself as a force and contender in the worldwide commercial center. Goodbye Group procured UK based Corus Group, a settled steel organization in its own right, by method of a $12. 1 billion arrangement. The arrangement was mostly financed with a $6. billion dollar advance that was fundamentally named in Euros. The money where the Corus Group earned the majority of its incomes was Euros. It appeared well and good for the Tata Group to support the arrangement in Euros so as to abstain from presenting the obligation to cash hazard. The issues that the Tata Group would look because of this arrangement realized an issue that the association truly didn't have a lot of involvement with managing. As a result of the money category issues with this arrangement, the Tata Steel would have an obligation of over $600 million on its monetary books. Despite the fact that, the truth is that Tata Steel has a sound and adjusted money related structure and bookkeeping rehearses. In light of global bookkeeping laws that India and the Tata Group have received, on the books it looks as though Tata Steel is convey a greater number of liabilities or obligations than it truly is. This is noteworthy in light of the fact that a speculator or investor would take a gander at the company’s financials and believe that the association isn't as monetarily steady as it truly may be. Goodbye Steel utilized Indian Generally Accepted Accounting Principles (IGAAP) to set up their fiscal reports. IGAAP converged with the worldwide bookkeeping framework known as the International Financial Reporting Standards (IFRS). The issue with this is by IFRS measures the merger, or regular fence, was not perceived. IGAAP and IFRS both commanded that outside cash advances be named in the obtaining company’s home money for bookkeeping purposes. This made a detailing issue for Tata Steel when actually there was no money related issue with the arrangement. SWOT Analysis of Tata Steel Strengths Global situation in steel industry Goodbye Steel is one of the most prosperous and beneficial steel organizations on the planet. The securing of Corus and other worldwide steel organizations have reinforced Tata’s position in the commercial center and made it one of the top steel organizations on the planet. Corporate administration Tata Steel has had a generally excellent record for corporate administration. It has set the benchmark in worldwide corporate administration standards of responsibility, straightforwardness, and value for others to follow. Goodbye Steel has been reliably accepting lofty honors at both the national and the universal field. The organization was granted the Best Governed Company Award in 2006 for corporate practices introduced by Asian Center for Corporate Governance. Brand esteem The Tata Steel brand, attributable to its profoundly moral and a communist way to deal with business, has made its name equal to trust. The obtaining of Corus made Tata Steel a much increasingly legitimate and amazing organization. Tats Steel was a notable brand even before the obtaining of Corus. The expansion of Corus makes Tata Steel one of the most notable and profitable organizations on the planet. Development of Tata Steel Goodbye Steel has the most minimal working expense for steel fabricate on the planet. Further it has shown compelling methods in receiving an eco-accommodating and supportable methodology towards the assembling of steel in this manner proactive measures are attempted to guarantee the representatives wellbeing and efficiency through ergonomically structured work stations and by shielding them from word related perils. Flexibility to the quick changing worldwide business condition Tata Steel has shown colossal deftness in the ongoing past during the worldwide budgetary emergency. Its virtuosos of different fields have received different techniques like bringing down creation and in any event, closing down steel plants because of the absence of interest, dealing with the accounting report productively and so on. The organization has 70% of its obtainment of crude materials for its activities in Asia through long haul contracts thus its edges can be protected from the subtleties of the unpredictability of the monetary markets. Supervisory group Tata Steel has a profoundly believable supervisory group who has shown their aptitudes in growing the organization through different inventive strategies. The organization has effectively gained Nat Steel of Indonesia, Millennium Steel of Thailand and all the more critically UK based Corus. The company’s virtuosos of fund have had the option to discover imaginative approaches to handle the company’s obligation and keep the primary concern in the green zone in spite of lower request and a great deal of aggregated obligation. Shortcomings Debt trouble Tata Steel has an all out obligation of $9. 8 billion USD on its books, a lot of it from the Corus securing. The organization intends to renegotiate $6. 5 billion of its drawn out obligation. It has a troublesome obligation to value proportion which implies the advantages of the organization are to a great extent financed through obligation. With the consistent increment in swelling most nations are starting to fix credit and liquidity in the currency markets. Because of swelling expands, loan fees are on the ascent also. An expansion in loan costs implies an increment in the company’s liabilities. This will additionally add to the corruption of Tata Steel’s asset report. Traditionalist bookkeeping rehearses India has preservationist bookkeeping principles. The framework works inside the nation however needs adaptability and flexibility with regards to detailing contrasts in cash. Since the Tata Group has worldwide desires, the organization must arrangement in different monetary forms while working with worldwide organizations. The issue lies in the principles overseeing the bookkeeping rehearses inside India. Every single outside money must be changed over to the nations of origin cash when providing details regarding budget summaries. Innovation Many steel organizations have actualized various advancements into their plants to make creation and profitability increasingly effective. There is another fluorescent x-beam innovation that a few organizations have received. Goodbye Steel is inadequate around there. Goodbye Steel has neglected to embrace new innovation to bring down expense, improve creation, and improve worker wellbeing gauges. Acquirement theory of its auxiliaries The biggest auxiliary of Tata Steel, Corus, has high introduction to spot costs and a higher operational equipping among the bigger European steel organizations. Subsequently it has the danger of instability related with valuing, one of the key components in deciding benefit of a product organization. Openings Serious position Tata Steel is the second biggest maker of steel in India and the 6th biggest maker on the planet. Throughout the years Tata Steel has been procuring different steel organizations around the globe, the most recent being Corus. There is a great deal of space for Tata to develop and additionally build up itself as an enduring force in the worldwide commercial center. Innovative advances Tata Steel has indicated tremendous joining capacities before. With the acquis

ZhangNing_Essay_Illinois Essay Example | Topics and Well Written Essays - 500 words

ZhangNing_Essay_Illinois - Essay Example I further fortified my assurance to seek after a profession in this field when I saw how the various budgetary elites in Shanghai have added to the success of the city and transformed the city into the money related capital of China. Planning to develop into a monetary master who can make a major commitment to the field, I have followed the direction of my uncles. As a matter of first importance, I have given a great deal of consideration to arithmetic, as it is the basic apparatus for money related investigation. Setting up great investigative and basic speculation ability from rehearsing science, I have additionally procured understanding in account by watching money related projects and perusing budgetary diaries. Being comfortable with different businesses and collecting fundamental aptitudes of breaking down corporate budgetary reports, I have proceeded to pick up hands-on understanding of money by dealing with a stock record, which was offered to me by my dad as a birthday present. Gathering data in a convenient manner and making expectations precisely, I have effectively earned cash. In spite of the fact that the absolute aggregate of cash is unimportant, the experience and certainty I have accomplished ha ve fortified my assurance of seeking after my vocation in fund. During the time spent accomplishing my objectives, I have finished an entry level position in the money related branch of Shanghai’s BaoAn Hotel. From this work understanding, I have increased an authoritative comprehension of the monetary working arrangement of an organization and began aggregating information in corporate administration bookkeeping. In spite of the fact that I believe I have taken in a great deal up until now, I am completely mindful that so as to turn into a money related master, I despite everything need to grow my viewpoint and gain further information in my undergrad instruction. In this manner, I wish to concentrate in the U.S., the main nation on the planet for money related administrations. In spite of the ongoing money related calamity, I am certain that the U.S. will endure and flourish as it has consistently done before. By concentrating in the U.S., I will figure out how Americans win

How to Find the Best Custom Essay Writers

How to Find the Best Custom Essay WritersProfessional essay writers are needed for students, high school students, college students, and professional individuals. For students, a good essay is essential for making the grade. The essay helps to distinguish the student from others. Most of the high school and college students fail to create their own individual ideas or concept because they lack the experience and skills required to write a good essay.Essay writers can be found through colleges, universities, and online stores. One can find custom essay writers who can give their ideas their own uniqueness. These writers help to write essays for every occasion. An online shopping site helps in the task of finding a writer with the required expertise.In the modern days, it is mandatory to write a well-researched paper. When writing an essay, the need for skill and expertise cannot be neglected. Nowadays, the customers are expecting a quality and worth paying essay. It is therefore impor tant to select a writer according to the size and status of the project. The following sections will guide you on how to choose the best essay writers.The first step in finding the writers is to check the company website. Do not hesitate to check out the essay writers who are available. If a site does not list the writers, then one should consider looking in other places. Usually, these websites have the names of the best writers of a particular company.The next step is to visit the site of the website. There is no better way to find the work than to check out the site. It is very important to note that the writers are not being selected randomly. Most of the writers give feedbacks and reviews for the work, which has been given to them.Websites also offer the rate table for the writers. The writer who provides the work at a lower rate is not the best. So, if you want to make a fast decision, then one should look at the rate table.The next step is to look for writing tips offered by the website. There are many websites that offer the latest tips for writing an essay. Some of the essays require different types of skills and writing. Some of the essay writers can give the outline of the essay.Some of the writers provide their samples on their website and can be purchased on online stores. If you are not comfortable about reading and listening to samples, then one can look for testimonials about the work of the writers. By checking the testimonials, one can know about the reliability of the writers.

Analysis Of The Poem The Hound Of Heaven - 1167 Words

I did not proceed to the ingress of the seminary gingerly. Indeed, at first, I nonchalantly thought of it a pursuing a doctorate in Christian Apologetics. Those first videos of this course resonated in me staunchly. I can bellow in respect to my pursuit of a doctorate, however, the pivotal word, seminary blares like a trumpet straightaway. I have apperceived that God called me to do this for some time. However, I ascribe to the sentiment of Jonah. I supplicate to God to elect someone else. I rationalized I could consign to oblivion this invitation. I would just persevere in my path and he would forget about me. Considerably, God has a droll sense of humor. I would circumnavigate back to the same crossroads again and again and again. I reminded of the Francis Thompson’s fateful poem of The Hound of Heaven where the Lord never ceases in His hunt for him. The last parry commenced when on the television I heard a man named, Ravi Zacharias. His intellectual approach to defending Christianity inspired me to read many books on the subject of Christian Apologetics. It included taking a course from Ravi Zacharias Ministries on Christian Apologetics. However, other factors worked simultaneously on my person. Firstly, I educated some home schooled children in the subject of Biology from the Christian perspective. One of the three degrees that I hold is in Biology. I discerned the must to instruct the children to defend against the false teachings of evolution andShow MoreRelatedE.E. Cummings and his Life as a Poet Essay1967 Words   |  8 Pages This research paper is going to be about E.E. Cummings his life as a poet. How he wrote his poems the grammar he used in his poems. The rewards that E.E. Cummings got before his death. There is going to be three poems that are going to be a critical analyzed for the literary devices used and the type of poem in the three poems. Biography His early experiments in poetry whilst still a child were encouraged by liberal parents to whom Cummings remained close (â€Å"E.E. Cummings†). After an unsuccessfulRead MoreFall from Grace: Satan as a Spiritually Corrupt Hero in Miltons Paradise Lost2859 Words   |  12 PagesMiltons Paradise Lost Can Satan -- a being, so evil that even as an Ethereal being of Heaven, who was cast out of Gods grace - be a hero? John Miltons Satan in Paradise Lost is very much a romanticized character within the epic poem, and there has been much debate since the poems publishing in 1667 over Miltons sentiments and whether Satan is the protagonist or a hero. As an angel in God the Fathers Heaven, Satan rose up with a group of following of one-third of all of Heavens angels and triedRead MoreUnderstanding The Consciousness Of The People Of London At The Time Essay2581 Words   |  11 Pageslines regarding the new modern woman. He asks â€Å"Are you really under the impression that English girls are so ridiculously demure? Why, an English girl of the highest type is the best, the most beautiful, the bravest, and the brightest creature that Heaven has conferred upon this world of ours. She is frank, open-hearted, and fearless, and never shows in so favourable a light as when she gives her own blameless impulses full play!† Mr. Goldbury now begins his song in which he outlines a perfect EnglishRead More Comparing the Love of Romeo and Juliet, Twelfth Night and the Bible4838 Words   |  20 Pagesnecessary, of course, to begin by explaining what the Biblical evaluation of love is. Of all the references to love in the Bible, and there are many, three sources apply best to this discussion. In the Old Testament, Song of Songs, a descriptive love poem between a woman and her true love, has many parallels to love in Romeo and Juliet. St. Johns first epistle provides a profound insight into the nature of love. He states that there is no fear in love; perfect love drives out all fear. (I John 4:18)Read MoreHAMLET AND ORESTES10421 Words   |  42 Pageswith character, though in the course of the comparison I shall of course consider the situations in which my heroes are placed, and the other persons with whom they are associated. Orestes in Greek occurs in poem is very clearly a traditional character. He after poem, in tragedy after tragedy, varying slightly in each one but always true to type. He is, I think, the most central and typical tragic hero on the Greek stage; and he ^eight if we occurs in no less thanRead MoreStephen P. Robbins Timothy A. Judge (2011) Organizational Behaviour 15th Edition New Jersey: Prentice Hall393164 Words   |  1573 Pagesof systematic study. Identify the major behavioral science disciplines that contribute to OB. Demonstrate why few absolutes apply to OB. Identify the challenges and opportunities managers have in applying OB concepts. Compare the three levels of analysis in this book’s OB model. MyManagementLab Access a host of interactive learning aids to help strengthen your understanding of the chapter concepts at www.mymanagementlab.com cott Nicholson sits alone in his parents’ house in suburban BostonRead MoreBhopal Gas Disaster84210 Words   |  337 Pagesto receive any money. Efforts to extradite Warren Anderson, the chief executive of Union Carbide at the time, from the United States continue, though apparently with little energy behind them. Advocates for those who live near the site continue to hound the company and their government. They chain themselves to the prime minister s residence one day and dog shareholder meetings on another, refusing to let Bhopal become the tragedy that India forgot. They insist that Dow Chemical Company, which

Pros And Cons Of Artificial Intelligence - 1439 Words

To progress as a society, we must first look back at all the hardships faced throughout the years. We must look at the world leaders who were able to convince entire countries to eliminate millions of people different than themselves. We must understand the groups of extremists spreading terror and fear across the globe, and we must control people in power abusing their positions to benefit themselves and their agendas. Instead of ignoring these human mistakes, we must break them down and figure out how they could happen. Artificial Intelligence relies on our abilities to learn from our mistakes and mold our future in a way that will be beneficial and equal to all people. This paper will present the many benefits that A.I. will give†¦show more content†¦Life with A.I. will be easier if used properly. Many tasks that people face today will become much simpler and less time-consuming allowing for time to be spent more productively. Tasks such as shopping and transportation wil l become automated for you. The average person will be able to spend more time doing what they please rather than the tasks plagued with us today. The key to all this however is ensuring that this new time be spent bettering society rather than becoming lazy and unproductive such as what the movie Wall-E predicts happening. In Wall-E the ordinary citizen spends their time in front of a monitor watching shows while technology does everything for them. This too can happen in our future. A.I. must be developed to benefit all types of people. The problem with creating such an effective machine is that one machine will be able to do the jobs of several humans. As humans, we need to stay ahead of the game and prepare ourselves to work in different fields in years to come. Jobs such as watering, fast food restaurants, golf caddies, and many other simple yet required tasks will be overtaken by robots. These jobs will take away a lot of work for the lower class, which is why it will become v ital to attend colleges and universities to better oneself and the skills one has in order to always be needed by society. The push for A.I. should go hand in hand with the push for humanShow MoreRelatedPros And Cons Of Artificial Intelligence1704 Words   |  7 PagesArtificial Intelligence Artificial Intelligence (AI) is a topic of major controversy in today’s world. When people first hear about this, they may quickly jump to conclusions that can be either positive or negative. On one end of the spectrum, some may think that it could mean the end of humanity. That AI systems might surpass human intelligence, and come to the conclusion that humans are inferior to them, which has several implications on its own. On the other end, some may think that it could beRead MoreThe Pros And Cons Of Artificial Intelligence1245 Words   |  5 Pagescontain computers. It is for this reason that computers and their software should become more intelligent to make our lives easier. Artificial Intelligence systems can and will benefit us all, however many have constantly warned that making computers too intelligent can be to our downfall. Artificial Intelligence has been around for years, but what is artificial intelligence? It is an artifact to perform the same kinds of functions that characterize human thought processes. The possibility of developingRead MoreThe Pros And Cons Of Artificial Intelligence1405 Words   |  6 Pagesbreakthroughs. Although it represents a huge technological advancement, the use of artificial intelligence is a tool that should be used with caution and must not be too heavily relied upon. True autonomy means free will, meaning machines would be able to determine right from wrong, and something that operates on pure logic should not make such critical decisions for human beings. Artificial intelligence, or AI, is defined as intelligence exhibited by machines. AI research is the study of any device that perceivesRead MoreThe Controversy of Artificial Intelligence1476 Words   |  6 PagesThroughout its history, artificial intelligence has always been a topic with much controversy. Should human intelligence be mimicked? If so, are there ethical bounds on what computers should be programmed to do? These are a couple of question that surround the artificial intelligence controversy. This paper will discuss the pros and cons of artificial intelligence so that you will be able to make an educated decision on the issue. What is Artificial Intelligence? The first step in getting anywhereRead MoreThe Age Of Artificial Intelligence1418 Words   |  6 PagesJennie Nguyen Ms.Decker Honors English IV 24 Sept. 2015 The Age of Artificial Intelligence â€Å"Intelligence is described as the ability to adapt to new environments and situations and being able to understand consequences and effects that your actions cause. This is something that all living creatures have in some way or another. Animals can adapt to their environments and react to interference, and plants do the same. Human intelligence, however, is in an entirely different ball park. With the upriseRead MoreArtificial Intelligence Is The Most Controversial Field877 Words   |  4 Pagesinformation scientists know about artificial intelligence has increased to levels never reached before. In 1968, the first computer controlled walking machine was created and today, robots are replacing humans in the work industry (History 5). By the year 2029, it is predicted that robots will be able to outsmart their makers (Khomami 1). More knowledge about artificial intelligence is being acquired by scientists. There are several advantages that come with artificial intelligence in robots, but coupled withRead MoreThe Invention Of Artificial Intelligence1668 Words   |  7 PagesIn our lives today, we all use some form of Artificial Intelligence daily. Some of these activities include: using cellular apps (Google Maps, Siri, Cortana), playing video games, and listening to music. Although the use of Artificial Intelligence has made human life more efficient and effective, it has also insinuated reliance and unsuspecting ignorance into our minds as well, and we do not even see it coming. The history of Artificial Intelligence dates back to the 1950s. Approximately fourteenRead MoreThreads Of Artificial Intelligence On Society And Economy Essay990 Words   |  4 Pagesâ€Å"Threads of Artificial intelligence on Society and economy†, written by Lee, chairman, chief executive of Sinovation Ventures and the president of its Artificial Intelligence Institute. This article addresses questions about the future challenges and impacts of artificial intelligence on society and economy. In short, people will start to lose jobs, and there will be an imbalance due to large profit growth in companies that own artificial intelligence. When a company uses Artificial intelligence in placeRead MoreArtificial Intelligence And Human Intelligence1312 Words   |  6 PagesArtificial Intelligence Artificial intelligence is the technology that involves computers and machines displaying it’s own intelligence. The practical uses for computers making their own decisions is a very important technology to develop, because this would allow the deployment of robots in environments too harsh for humans to brave, such as other planets, or even war zones. While artificial intelligence is a very good idea, true human intelligence will be very difficult to reach. While a computerRead MoreThe Effect Of Artificial Intelligence On The Medical Industry1097 Words   |  5 PagesInfluence of Artificial Intelligence in the Medical Industry Artificial intelligence is defined as the development of computer systems to perform tasks that normally require human intelligence. In the scientific industry, artificial intelligence is used to assist surgeons in surgery, called robotic surgery and is most likely to become the most dominant form of surgery. Robot assisted surgery has been prevalent for about ten years now, and is becoming popular in many industries. From an aeronautical

The Natural Law Is Not The Sharing From Within Of The...

Aquinas defines â€Å"Natural Law† as the sharing from within of the Eternal Law. â€Å"The natural law† is just the rational person’s involvement in the eternal law. This involvement is available to all persons independently of any belief on their part in God. The natural law is observed whenever people both engage in correct practical reasoning about what is good and best for them in any given situation and when they act in accordance with that natural inclination. The natural law, according to Aquinas, has certain basic and self-evident ideas that would be known to any human with a properly functioning intellect and a little experience of the world. What St Thomas says first and foremost, is the idea that, â€Å"anything good is to be pursued and†¦show more content†¦The goodness of the will s acts depends on the goodness of its term or object. Since the will is a rational concept, inclining toward objects presented to it by reason, it makes sense t hat goodness of the will depends on reason, in the same way that it depends on its object. Thomas teaches that practical reason should be measured by its first principles. Such principles are the primary ideas of the natural law, which is the rational person’s unique way of participating in God s eternal law. God s eternal law is received in or communicated to human beings through their natural tendency and their reason. Rational people participate in God s eternal law not simply by being ruled and measured by it but also by actively measuring and ruling their own actions in accordance with its truth. People participate in the eternal law by coming to know the truths of the eternal law and expressing these as ideas of the practical reason; and there is, Thomas says, â€Å"an ordered progression in this active participation in the truths of the eternal law. For the natural law consists of an ordered series of precepts or ideas of practical reason.† (May, 1992) Thomas then lists some of these natural tendencies and the human goods to which they direct us and which reason is naturally understood as goods to be pursued and done such as the tendencies to preserve one s life, to bear and raise children, to live in society with others, and to come to a

How the Information System Can Help to Improve the Health Care System

Question: Analyze that how the information system can help to improve the health care system and provide better health services to the people. Answer: Introduction Johnston and Bate (2013) opined that use of the information technology increases the productivity as well as make the entire operation system reliable of the business firm. This helps in maximizing the customer satisfaction as well as generating high revenue or the turnover of the health care organization (Kellermann and Jones 2013). Use of Information Technology helps in both enhances the capabilities of the present system of the organization as well as the enabling the new or the dynamic capabilities of the organization (Trainor et al., 2014). This assignment describes about the impact of Information Technology (IT) in Healthcare organization. However, this study also analyzes the important of IT for business survival and the usefulness of IT application in healthcare operations. Moreover, risks in IT implementation at Healthcare also analyses through this report. 1. Requirements of IT system at Healthcare The information system in a health organization is used to reduce the diagnostic errors, cost and increase the productivity, improve the patient experience. Providing competitive advantage by the use of data warehousing and data analysis is also an advantage of health information technology. Also in todays scenario, the internet, which is a necessary part of the information technology, helps in collection and exchange of data. Like the elderly patients and the expectant mothers get reminders through the mobile devices to take the medicines on time (West 2012). The IT can help in different aspects of the health care system like human resource management, accounting, finance, operations management etc. Also as the patients expect efficiency and reliability from the health care organizations, from where they are getting the health care. Therefore this reason also promotes the use of IT in the health care organizations. As an example the Bendigo hospitals in Australia is implementing the InterSystems TrakCare unified healthcare. According to the schedule, the system will go live in the year 2017 (Rotter et al. 2014). The solution will help the hospital to accommodate the clinic with the latest design and the technology. In this way, the organization a will get a competitive advantage over the other competitive health care organizations that are not using the information system in their facility. The use of the information system will help in providing the effective efficient and consistent health services. 2. Importance of IT for Business Survival (Health care business) As the use of information, system helps in reducing the operational cost of the organization and provides quality care to the patients then the patients become loyal to that particular organization. The organization can reduce the cost for per admission when the physicians write all the details of the inpatient orders in the computer that is connected to a central medical record system. Similarly, by the use of the health care information system a organization can develop a totally paperless medical record system that can help the organization to run smoothly and d the data can be accessed by different authorized departments, physicians, and officials. All these reasons help a organizations to survive in the competitive market. 3. Requirements to deploy the IT in business Cost evaluation: Before implementing, the IT solution (like transaction processing system, decision support system, management information system) in the organization should run a formal evaluation process that can reduce the possibilities buying inadequate or unnecessary hardware or software. Planning: Before implementing any kind of IT business solutions, an organization should analyze their needs for which they are going to implement the IT solution in the organization. Otherwise, the organization will end up with the undesired result or disastrous result. An effective planning can be a way to achieve the strategic business success (Johnston and Bate 2013). Designing: Since there is an issue of individual perspectives, then something, which is meaningful to an individual, cannot be acceptable to another person. This may happen due to the level of the exposure of the person to the technology due to the reasons like age, gender, education etc. so while designing the health information system the developer must consider that it have to be usable. The developers have developed the system in such a way that it will be simple, natural, consistent, have easy interactions, able to save the context (Wheeler 2015). Equipments: The equipments those are required to implement the health information systems are mainly software and hardware related like workstations, servers, user interfaces etc. Installation: Installation of the new system is related to the changes in the business processes, job assignments, organizational structure, work relationship, determining the roll of every staff on board. Training: One of the important steps in the process of implementing IT solutions in the health organizations is the training of the staff or the employees in the organizations. Since there is resistance from the side of the employees on changing the process in which daily things are done. Therefore, there should be a proper training program for the employees (Ghosh et al., 2013). The top authorities should take care of this training program so that the program can involve as much people as possible. 4. Use of IT in Business (Healthcare) After implementing the IT solutions (like executive information system, decision support system) the organization has to use the solutions so that it can help to grow the business and reduce the previous issue that acts as the obstacles. By implementing the information technology, the health care facility can make it easier to pay the payment for its services. For a health organization, it is important to know it is important to know the patients and serve them well, on time. Use of IT in Healthcare Internally Employees The use of the information system makes it easy for the employee to complete the daily task in much lesser time. So the information system helps them to do research the about the emerging technologies and also about the competitor strategies. Therefore, we can say health information system encourages the innovation in the employees. Staffs For the staffs in the health care organization the information system provides easier way to complete the routine tasks in much lesser time Table 1: IT effects in Internal Environment at Healthcare Use of IT in Healthcare Externally Customers Use of health information system in the health organization help the customers to get the best and efficient health services from the organization. Suppliers The suppliers like the pharmaceuticals suppliers (walgreens ) can have a electronic database that help in providing all the medicines for a prescription nationwide(Kushniruk et al. 2013). Table 2: IT effects in External Environment at Healthcare 5. Advantages of implementing the IT in Healthcare Several advantages are realized by the organization. These advantages can be categorized into the storing and protecting the information, automated processes, remote working and communication. Revenue Generation: The hospitals or the health organizations spent on the health information system but when the cost benefit analysis is done on the investment then it is seen that there will be a rise in the revenue of the organization in long-term (Zalatimo 2014). Since the revenue will increase when the number of the patients will increase or the operating cost will be decreased. Remote working (Flexibility): As there are different, new technologies are emerging like cloud computing, these technologies can help the employees of the organization to work from a remote location. The employees can access the organizations electronic network and work on the go whether they are on the road or at house. In this way, the IT solutions can help in improving the productivity. Communication: In todays business scenario, it is important for the employees of a organization to be connected. The information technology can help in this issue too. Employees can be connected through the e mails, communicate with each other over the video conferencing. Therefore, we can say that there is always a way to communicate and do the business processings. Automation in the business process: The business organizations always try to do more things in lesser time, so that the revenue can be increased by increasing the amount of business. The automation offered by the IT solutions helps in to do so (Cang et al., 2014). In this way, some of the workload can be reduced from the employees, so that the employees can do other important tasks. Whereas the computer will, do the mundane tasks like running the reports, creating the queries, tracking the projects etc. Global access: As on today most of the business houses trying to reach the global market, global consumer groups by using the internet. The existence of the business on the internet makes it easier for the customer to get or order the product anytime anywhere. Consequently, that helps in expanding the business of the company. Reduce Cost: As the information system provide automation support to the health organization then it helps in reducing the cost of day-to-day operation of the health organization (Hibbard et al. 2013) 6. Risks in implementing the IT solutions in Healthcare Operations As the IT solutions implemented in an organization have advantages at the same time they have some security and risk concerns too (Alhawari et al., 2012). Technical risks like phishing, sniffing, denial of services, scanning etc. Also mishandling the system can cause a huge failure. Confidentiality: This kind of risks involves low quality business procedures, lack of policy and standards. The main reasons behind this kind of risks are the lack of trust between the business partners (Cheng et al. 2013). Security: Although the technologies like cloud storages provide organizations huge storage spaces to store its organizational and client data but there are some security issues are also involved with it. Since the cloud provider provides the storage, then it becomes a service and the ownership of the data becomes a security issue to the organization. Privacy: The use of the computerized information system has to protect the privacy of the patients data, provider data (Fernndez-Alemn et al. 2013). The system should properly address to the any unauthorized alteration in the data. Conclusion As the information, technology is being upgraded day by day then the organization has to upgrade with it. So that it can survive in the market and can have a dominating market share. Using different IT solutions like ERP solutions, information reporting system, decision support system, Groupware , executive information system , the top level authorities to take decisions, the executive level employees to determine strategies, develop plans to run the health organization smoothly and efficiently. It also provides strategic flexibility to the organization too (Cresswell et al. 2013 ). References Alhawari, S., Karadsheh, L., Talet, A.N. and Mansour, E., 2012. Knowledge-based risk management framework for information technology project. International Journal of Information Management,32(1), pp.50-65 Cheng, J.H., Chen, S.W. and Chen, F.Y., 2013. Exploring how inter-organizational relational benefits affect information sharing in supply chains.Information Technology and Management,14(4), pp.283-294. Cresswell, K.M., Bates, D.W. and Sheikh, A., 2013. Ten key considerations for the successful implementation and adoption of large-scale health information technology.Journal of the American Medical Informatics Association,20(e1), pp.e9-e13 Fernndez-Alemn, J.L., Seor, I.C., Lozoya, P..O. and Toval, A., 2013. Security and privacy in electronic health records: A systematic literature review.Journal of biomedical informatics,46(3), pp.541-562. Ghosh, B., Yoon, T. and Fustos, J., 2013. Enhancing Functional Fit with Continuous Training During the ERP Post-Implementation Phase.International Journal of Information Systems in the Service Sector (IJISSS),5(2), pp.30-45. Hibbard, J.H., Greene, J. and Overton, V., 2013. Patients with lower activation associated with higher costs; delivery systems should know their patientsscores.Health Affairs,32(2), pp.216-222. Johnston, R.E. and Bate, J.D., 2013.The power of strategy innovation: a new way of linking creativity and strategic planning to discover great business opportunities. AMACOM Div American Mgmt Assn. Kellermann, A.L. and Jones, S.S., 2013. What it will take to achieve the as-yet-unfulfilled promises of health information technology.Health Affairs,32(1), pp.63-68. Kuperman, G.J., Gardner, R.M. and Pryor, T.A., 2013.HELP: a dynamic hospital information system. Springer Science Business Media. Kushniruk, A.W., Bates, D.W., Bainbridge, M., Househ, M.S. and Borycki, E.M., 2013. National efforts to improve health information system safety in Canada, the United States of America and England.International journal of medical informatics,82(5), pp.e149-e160. Rotter, T., Machotta, A., Kinsman, L. and Champion, R., 2014. Evaluation of a clinical pathway for radical laparoscopic prostatectomy: an interrupted time series study.International Journal of Urological Nursing,8(2), pp.84-89 West, D., 2012. How mobile devices are transforming healthcare.Issues in technology innovation,18(1), pp.1-11.

The Problem Of Gender Discrimination Essay Example For Students

The Problem Of Gender Discrimination Essay Gender discrimination is one of the underlying factors in the sex-segregated labour market in Indonesia. Many male workers are accused of sexual harassment. Additionally, some companies even deny access to their finances. They lack the protection of the domestic workers. The informal economy has many policies they want to adapt. They want to end the globalized cheap-labour manufacturing sectors. They want to create opportunities for employment for females workers in more urban areas.Indonesia has a plan to merge the public and private sectors to do this. They also want to improve the conditions of work and pay. International Labour Organizations are working along with Indonesia to promote the equal opportunity. Traditional patriarchal norms have relegated women to secondary status within the household and workplace. We will write a custom essay on The Problem Of Gender Discrimination specifically for you for only $16.38 $13.9/page Order now Women are commonly married young, quickly become mothers, and are then burdened by stringent domestic and financial responsibilities. Women receive little schooling, and suffer from unfair and biased inheritance and divorce laws. Women receive little schooling, and suffer from unfair and biased inheritance and divorce laws. Organizations help to build networks among women to create financial self-help groups. They introduce ideas about microfinance, allowing women to participate in management activities. These projects have enormous potential to improve the financial and social status of indian women. So far the plan for India is to organize a change at a local level and planned action that will help to eliminate bias and stereotypes.This will generate awareness of the significant gender divide that exists within Indian society.Most Chinese men and women still believe in the saying that â€Å"men belong in public, women. . In 2015, only half of the world’s working age women are in the labor force, compared to the 77% of men. International organizations create programs to help women start and sustain their businesses. Especially in the United States, many women are not aware of their rights. According to the civil rights act of 1964, no one should be discriminated against at a workplace or during an interview. Any discrimination should be filed against. 62 million girls are denied an education all over the world. 4 out of 5 victims are human trafficking are girls. Many foundations try to raise awareness and funds for these girls and try to rescue them. Organizations like â€Å"Step up† help keep girls in school, getting them closer to the higher position. Only 30% of the world’s researchers are women. Google has a program to inspire the next generation of technology to teach innovators.

Definition-nature of the problem solved Essay Example

Definition Definition-nature of the problem solved Essay Definition-nature of the problem solved Essay Willcare is an independent car mechanic business. The business located near the owners home where there are a number garages available. It is a small service business promoted by the owner and has been running around 20 years. The owner may employ some workers for a specific job, but usually works alone on a variety of jobs. A separate outlet provides supplies when they are needed. * The main aim of the business is to provide an alternative for customers who dont like the treatment from there local dealerships. The owner feels that people would prefer a face-to-face meeting with him to discuss their problem and says he prefers talking to clients personally rather than through a system because it helps create trust. His business also aims to give an equal amount of customer satisfaction to all those using the business. Also, to make sure that the companies recognition grows, so that more people are aware of what it has to offer. * Most vehicle related services are available. These include repairs and modifications, as well as a phone service for queries or complaints. The business will offer to keep vehicles for a short period of time but only if necessary as it means insurance and liability does not have to be dealt with. Most jobs are done in under a day and they usually receive no more than 5 customers a day. * The majority of the business material e.g. dealing with finances, orders and bills is done by the owners wife and is still completely based around paper filing and written receipts. Current Method Used * All the paperwork of the business is still file based without an effective computer system. Lists, receipts and orders are produced and sent through conventional methods such as postage and delivery. * Customer information, their history with the company and their previous cars, requests and other information is kept in an alphabetic filing system. This method is fairly effective at the moment however the company is gaining recognition and eventually there will be to little resources to keep the current system working effectively. * Finding required information will involve looking through the filing system for a customer and then searching their records for any needed information. This can be much more time consuming for customers who have used the company often as there may a large amount of files to search through. Also the most recent receipts are kept close at hand in case a customer is unsatisfied and needs to prove on their return that they are legitimate. * Lists of information and data, such as clients cars are also kept in a brief date book so that the owner can at a glance see what is expected in the next few days. This helps him inform other customers of the probability of their car being seen in the near future based on the amount of work needed and also the space left available. The owner told me that he estimates space but it never poses too much of a problem because of not keeping individual vehicles longer than a day. A final list is also kept of the other companies he has bought off and how much they charge for various items. * Invoices and receipts are still produced using trace through paper copies * Calculating payments is usually done before the work based on an estimate of the time required and the resources needed. It still remains an estimate however and is worked out with a calculator. All other costs are worked out using a calculator also, e.g. suppliers pricing. * With about 3 to 5 customers a day tasks such as calculating are done while the work is taking place so there is no delay for the customer when they come to pick up the car. Usually though the owner likes to talk to the customers to discuss how the service went and get their opinion on various matters to do with the car. If, however a large number of customers are present at a similar time, which can often be the case because they may want to pick up their car after work, then there can be a delay. * It appears that tasks are performed fairly efficiently as long as it is a simplistic job. However, because different areas of the business seem to be stored separately e.g. the supplier receipts and data and those of the customer that this can often lead to confusion with payment calculations. * Lacking from the current system, according to the owner is the ability to search for the customers information while they are on the phone. He quite often has to put customers on hold while he searches for their information or for an answer to a query he doesnt know of hand. He also feels that if the business continues to grow at its current rate he would be lacking the space to keep all of the records and would have to discard any before a certain date. This could take a fair amount of time and needs so he needs to find an alternative method. I also feel the system is lacking a high enough amount of security. Currently all records are just kept in a locked filing system with no copies present to compensate for critical damages. A more secure system requiring restricted entry would be preferable in the future. * As a result of the current system being so basic there is little room for any critical errors as long as the business remains at a steady rate. It is only when increased customers bring an increase in the amount of data that the system will be prone to mistake. This is the main fault with the current system. With all processes being hand written and calculated there is a much larger margin for error than modern technology has. Any incorrect calculations will result in time consuming back tracking. Other faults are the estimation of time and space. It would be much easier to confidently inform customers of when there car can be seen, without wasting their time because of a lack of space or time. Data Flow of Current System Inefficiencies and Problems As mentioned earlier under current method used there were a number of inefficiencies present. The most important of these are listed below 1. Calculations are slow and prone to mistake. 2. Large amounts of paper-based data are susceptible to being confused or lost as a result of over crowding information. 3. Security is of a low standard and there are no copies of data being made as backups. 4. There is no fast access to customer information that may be needed for quick consultation, in situations like a phone conversation. 5. Any mistakes in calculations or mix up in customer data take a long time to correct due to lots of paperwork in a rough system. Origins and Forms of Data Data Origin Form Customer Details Signed Form Customer Records Sheet/ Receipts Problem Description Signed Form/Telephone Call Customer Records Sheet/ Receipts Car to be serviced Telephone Call/Signed Form Customer Records Sheet/ Noted Sheets/ Receipts Date/Time confirmation Job Diary Customer Records Sheet/ Noted Sheets/ Receipts Cost Estimate Predicted by owner prior to service, confirmed after. Customer Records Sheet/ Receipts Initial Problem Definition A slow customer service as a result of paper based filing systems for storing data. These cannot be accessed quickly with phone-based customers and may lead to frustration. Each customer has a single folder for their data and it is not ordered in any other way than newest entries being put at the front. Faster access to required information could be achieved under a different system. Only an estimated price and time can be calculated before a service takes place. A new system that could calculate exactly would help improve customer trust and efficiency. Mistakes are a higher probability using the current system of calculators, as they are prone to human mistake. A different system incorporating checks would improve reliability. Security is not of a good enough standard for large amounts of customer information. It is only secured in a locked draw with no insurance policy. The system requires a lot of time to create any backups. Investigation and Analysis Methods of Fact Finding Research into various methods of finding more about the current system have shown me that a one on one interview with the company owner would be the most beneficial. Three other techniques taken into consideration were a questionnaire, observation and analysis of current data regarding the company and its system. These were not preferred for the following reasons 1. Questionnaire- For a smaller organisation with fewer customers this would prove less effective. The data could not be considered as completely reliable based on the small number of participants. I also think they are less likely to know about the company information techniques. 2. Observation- With the business receiving two to three jobs a day the owner will be spending most of the day doing the actual work. It would be difficult to know when to visit to be able to see the other side of the business. Also, some customers may be opposed to there payments not being confidential. It may be possibly to get a small glimpse at the workplace following my interview. 3. Existing Data Analysis- The only data kept by the company is that regarding the individual customers and these are kept confidential as it is personal data. The interview I will prepare for is with the main manager because he will have the information most useful to me. He started the business and has been in full control ever since. Interviewing someone lower down in the business, such as a part time employee or perhaps a customer would most likely only provide me with limited knowledge. Following the interview I will try and question an employee to see how they feel about implementing a new system and how it would help them. It is important preparation takes place before an interview of this sort to make sure the correct information is gathered. Therefore here is a basic outline of the information I will hope to gather. What happens to the data the customer provides? How long are forms kept, is finding them on later occasions easy? What aspects do you feel need improving relating to the customer? What type of information do you need to get that sometimes isnt available? Are you in favour of new system displays e.g. logos, colour schemes? What paperwork would you like in a new system? Would you like an upgraded appearance for the new system logo, images and colours? Would you like shortcuts for various office jobs, would they speed up the processes? Would you or your employees need training to use a new computerised system? Is there anything else you would like the system to do? Interview Notes This interview took place on the 8th October at 4.30pm, at the owners house with himself and his wife present. I informed him of what my report would be based around and how I predicted a computer-based approach would likely be the most effective way to take the business. He agreed and said money was the main issue when it came to these improvements. Q: What happens to the data the customer gives you? The data is stored along with the customers previous records. Its a basic folder which we order by the keeping the most recent jobs at the front. Any new customers have a new folder created and are placed in alphabetical order with the other folders. If the data is something I might need to hand I record it in a journal I keep with me in the garage. Q: How long do you keep the forms for each customer and does the folder system make them harder to find? At the moment I still keep everything for each customer because often I may need to look back over previous jobs to remind me of what the customers situation is in terms of their vehicle and there history with the company. Also while the business is still small there is no issue with overcrowding of information. It doesnt really take long to find the info because its all organised properly and efficiently but it still takes time to leave a customer on hold while I sort out the data they want. Q: This problem relates to the customers, is there anything else you think the customers would like to see the business change. I think part of why this business has been as good as it has is because of the straightforward basic approach we use. Customers who dont want to talk to a mechanic through about five other people can just have face-to-face meetings to discuss the problem and make the decisions around that. Its a trust thing, I dont think they mind the paper-based approach but they would probably prefer it to be a bit more professional overall, and a computer system would probably accomplish this. Q: What type of information do you need to get relating to jobs that sometimes isnt available? If you mean things like how a certain car works and how to deal with certain problems then I usually just rely on instinct. Sometimes I consult the cars handbook but usually the problem isnt too serious to need that. Q: If a new computer based system was introduced would you like a specific display screen, featuring perhaps the company logo or a specific colour scheme? Yes, if thats possible itll just make it look a bit more professional but the company has no unique colour scheme so you would probably have to make one. Thats fine; Ill give you a rough copy to check over before I use it properly Q: What paperwork would you like to keep in a new system? Well the information the customer receives, things like receipts, bills and other notes and stuff, theyll need to be paper because most of my customers dont have access to computers. They prefer the simplistic approach so I dont want to change my approach of keeping the customer happy with little involvement. Q: Would you like shortcuts for various office jobs, would they speed up the processes? Anything thats simple enough for me to use effectively and also speeds up the process for customers would be great but it would have to be pretty simple for me to control it. Q: Would you or your employees need training to use a new computerised system? Some of the people I hire are pretty accustomed to computer systems but for me and especially my wife we would probably need a short introduction into what does what. Q: Is there anything else you would like the system to do? Well Im open to suggestions really but I wouldnt know what else would be possible. If you have other ideas just run them by me and probably approve them for this new system. 4.6 Current Data Structures Low-level DFD Booking a Job This is a low level DFD highlighting the processes required when booking a job. The owner has to consider both whether he can complete the job and also what it will cost the customer to pay for the job and any resources. The pricing list and current job notes are stored on paper as a checklist to be calculated. This process takes time so therefore numerous customers have to be called back before they know the full details about a job. All the paper-based information regarding each customer contains no specific reference that it is related to the company. Each piece is usually headed with the customers name and what the sheet will be referring to. A great deal of input into the system comes from customer word of mouth. Often times the owner will arrange a one to one meeting with a customer to discuss exactly what they want done. The interview notes are recorded and discussed with the customer afterwards to make sure they have gathered all the necessary information. 4.7 Requirements Specification Output requirements Requirement Evidence The system must provide a legitimate receipt to be given to customers to check and sign Interview with manager The system must provide a printed page containing an outline of job details to be kept with the owner during a job. Interview with manager The system must include a specific colour scheme in keeping with the business to appear on all printed documents Interview with Manager The company logo must appear on all printed documents in order to help classify information. Interview with manager The system must provide a report that lists customers who have requested a job in the last 7 days. Interview with manager The system must produce printouts regarding the requirements for a job to be given to the customer so they are fully aware of what they are paying for and also as an insurance policy. Interview with manager Input Requirements Requirement Evidence The company logo must be automatically present on every document before anything is written Interview with Manager System must be easy to operate for novice users Interview with Manager The owner must be able to secure the customer details with a login and password known only to him. Interview with Manager The system must provide quick access to customer data through a fast and efficient search engine. Interview with Manager The system must be able to link customer data to their current and past involvements with the business, through a relational database. Interview with manager Hardware and Software Requirements Requirement Evidence The system must be linked to a printer that is capable of printing out reports and receipts. Interview with Manager System must run on operating system Windows XP Interview with Manager All queries should return their results within 5 seconds on a computer with a fairly powerful modem. Interview with Manager The system must be operational through a responsive mouse as well as through the keyboard. Interview with manager The system must have various linked shortcuts to travel to different locations in the system faster. Interview with manager The system must be compatible with other storage devices in order to create backups of customer data. Interview with manager 4.8 Agreement to Requirements A copy of a letter I sent to the owner questioning whether these requirements were acceptable can be found in the Appendix. The letter contains requests for the previously listed system requirements and is signed by the owner as conformation of there agreement. 4.9 Alternate Solutions Analysis of the problems faced by this business has given me ideas for various solutions. Although a computer based approach seems a faster easier solution to the problem, other solutions must be examined to make sure the most efficient approach is used. Solution 1- with the owner feeling that the current system is still fairly efficient it maybe most effective to make subtle changes to this original system so as not to alienate employees unfamiliar with more complex methods. Remaining with the paper based system saves the need for large investments in newer software and hardware as well as the inconvenience of setting the system up. The installation process could take a fair amount of time and disrupt customer relations, which are such a high principle to the companys success. The solution would involve updating the string techniques for customer data. For example more secure folders and a quicker access system to find customer data. Each customer would be given a job identification number based on their personal data and the time when their job was ordered. This way the manager can prioritise the filing system to have the most recent jobs and best customers in a more accessible manor. Another approach to improve the current system would be to include partial computerisation. This would be a system where a search device would contain records of the locations of customer information. By using the search tool it will direct the manager to exactly where the documents they require are stored. This could be a very effective technique for when the businesss popularity starts to grow because it will mean a lot more storage places will be being utilised and customer documentation will become harder to find. If the business does start to grow this way however, the storage spaces may become limited for the amount of information it needs to keep secured and min good condition. Solution 2- with using a computer system seeming the most effective choice different solutions become available using various different programs and approaches. A possible solution would be to use a spreadsheet document and incorporate user forms. This approach has its advantages because by creating a form system they can be customized greatly to incorporate the company information and make them as simple and accessible to the customer as possible. This is very important for this business because the system must not appear confusing to customers who have chosen because they want a simple solution they cannot get elsewhere. Getting the customer more involved with the businesss processes may appeal to some customers more than others. If the customer feels they are making an input to the business and is familiar with the processes they may become more supportive and confident with the new system. One of the biggest advantages of this approach to the manager is the spreadsheets ability to perform complex calculations quickly. This is a great improvement on the conventional method of a calculator and paper workings. The downside to this is that it would require a fair amount of time-spent training before the manager could understand the formulas needed for what may become a complex system with more customers joining it all the time. Although the system could be set up by someone else leaving a simple input system, the manager still requires knowledge of the system in case any mistakes are made with the system during inputs and they need to correct it without bringing someone else in to fix it. It is important that the system does not disrupt the managers relationship with his customers. The biggest disadvantage wit this system however is that it would become very crowded and difficult to understand the more customers join the system. This is because spreadsheets do not work with a one to many relationship. Any customer who requested multiple jobs would have to have their name and their details entered into the system multiple times rather than having the jobs kept under the same name. This leads to a great deal of memory being used up by the system. With a very large amount of data the system may become slower because of the number of details being processed all at once. Solution 3- with a spreadsheet having a number of more complex inputs such as formulas and action buttons a more practical approach would be a database system. The Relational Database system I would use has a one to many relationship so it would allow each customer with their individual identification to have access to all their previous job details. The system will work by having multiple tables linked through a primary key. This primary key will be the customer ID. This ID will be present in tables containing the customers information, the job details and the pricing system. The customer table will contain their name, contact details and personal information. The job table will contain descriptions of the most recent job performed for that customer and a summary of all their previous jobs. The price table will be a list of each customers bills for their jobs. Using the ID to look a customer up the prices of each job will appear broken down into various segments so it is clear to them how a total was reached. In order to produce receipts quickly the system will also include a mail merge system linking the database to a word processor. Then through a button click the user can replicate the billing information and print it of for the customer. This method saves the time previously spent writing out receipt details such as the company name, data and job details. This information can now be saved in a word document and produced quickly in large numbers. 4.10 Limitations of Chosen Solution From the three solutions described above I have chosen to use Solution 3-a database system. This is because it provides the most efficient use of a computer and allows a customer to have various jobs under their name without overcrowding the system. The database can be set up by me and modified to fit the companies needs addressed in my one to one interview. For example the company name and a new logo will be present on the input forms as well as a constant colour scheme throughout the system. I chose it over an advancement to the current method because it is much to difficult to anticipate whether there would be enough room to store personal data if there was a sudden increase. Using the database means all the information can be kept together in a much more secure environment. The solution I have chosen is in itself not perfect. Here are some of the limitations facing the current system. * A fairly high level of instruction will be needed before the system can be implemented. With the amount of important data on the system it is vital that the manager and all his employees are fully aware of the security measures that have to be in place. * While a small amount of customisation is possible, a database application contains far less than a spreadsheet or word application making it harder to accurately represent the company logo and colour schemes. * For the database to work without any slowdown or technical problems it will need a fairly modern computer set up incorporating a high-speed modem and a large memory capacity. These specifications up the price of a computer and for a smaller business such as WillCare this larger amount of money is harder to come by without risking loosing company profits. The investment would be a risk because if business started to decline the company would be struggling to cover expenses. * The database application is unable to print what the business requires straight from the tables e.c.t. Instead a word processor must be incorporated for a proper receipt to be produced. Design Nature of the Solution 5.1.1 Objectives Input Objectives Customers personal data must have secure access through a login and password The database must be easy to use for a novice user. The system allows the user to input details of the customer on a single screen The system must be operational through a standard mouse and keyboard Process Objectives The system must recognise customer details through a unique member ID. It must calculate a job price based on a price list. It must store each customers previous job descriptions It must be possible to sort customer records in various orders such as alphabetical or by their most recent jobs. A means of backing up of all the files is provided. A simple method of recovering corrupted files has been produced. Output Objectives The display screen must present the company logo clearly The colour scheme chosen by the owner must remain constant throughout all output screens Printouts of receipts must be produced through a mail merge with the word processor When a code for an ordered item is entered, details of the item, including current stock levels is displayed on the screen Query results must be produced within 5 seconds of them being used. 5.1.2 System Structure This is a brief outline of the how the new implemented system will work. The structure will be kept as basic as possible to benefit the inexperienced workforce. A top down structure- Hierarchical Diagram Design of Forms All of the following forms and explanations are based on an outline of the system created in a spreadsheet document. By using this method I will be able to show the system to the owner of Willcare and get some feedback on what he thinks works well and what improvements he would like. All forms within the database will use this same colour scheme, as it is a professional look that will also help customers and employees recognise that they are still in the system. I felt that because the probable users will be inexperienced it would be useful to include a brief description of what functions the buttons will have in the database. The font specifications are Arial, size 10 with the table definition Menu using Berlin Sans at font size 18. The Willcare name is presented in a word art technique modified in its colour scheme and size. The contrasting colours help it show up on the system and are another way to reassure the user they are still correctly using the system. This is the customer form where the user will be able to add a new customer, search for an existing one or delete an old member. All the buttons are clearly labelled to explain their functions and I have maintained the same style of headings and logo used on the main menu. To make searching through current customers easier I have incorporated navigational arrows for quicker access and easier browsing. When considering the users abilities with computers I also decided to include a button to return to the Main Menu on each form. This will be useful because it will allow quicker access when the user wants to use a different part of the system. Each customers details will be filled in the shown boxes and various pieces of the information will be validated to make sure it is correct within the laws of the system. The most important aspect of this page will be the member ID. Each customer will be given a unique number that will be used to look him or her up through the system. The owner may feel, however that giving all his current customers a number for the system would alienate them and waste company time. Therefore I may only use member IDs for new customers and use a different look up method for existing customers e.g. their D.O.B. For the customers D.O.B entry I will use a combo box method so data input can be sped up. This form also includes a link to Add a Job. This button will allow the user, once they have entered the details to go straight to the job form so they can choose what they want done and find out the estimated price. The post code is an important way to identify customers legitimately and will contain a validation making sure it is accurately filled in. During my interview with the company owner I learned he would require the system to produce an output in the form of a receipt. To quickly produce the receipt using a mail merge technique the produce a receipt button will create the receipt for the job currently recognised in the form entry. If this is not the required job for the customer, the user can search for a different one using the view customer job button. The maintenance menu includes a link to job prices and a supplier list. These are options that are likely to be scarcely used. This influenced my decision to include them in a maintenance menu. If the user becomes confused with the system they can check this important information and hopefully save customer time. The suppliers list does not belong in parts of the system the customer views as it will confuse them and overcrowd parts of the system. A mechanics business has a very wide variety of jobs that may be required. It is therefore important that the user can add a description of a new job as well as have quick access to common ones. When a new job is entered a full description can be added or just a shorthand. The shorthand is necessary for it to be stored under the common jobs. The price remains an estimate because all jobs are different and customers may have required more or less work depending on their situation and car. The date of order and the expected completion date will both use combo boxes and the date of order will be immediately validated to display the current date automatically. The add to outstanding list will be covered under reports design as is the create receipt button. As the business grows they are likely to have numerous suppliers therefore I felt different search criteria would help speed up the process. One or both of the criteria can be entered and then searched for within the database. A supplier list will contain all the suppliers and products the company have used in the past. This is where the database will search based on the criteria. This is an example of one of the tables data will be processed from. Each Job will have a unique ID to help searching through the database faster and more efficient. Design of Reports With a growing number of customers I felt a report covering the outstanding jobs for the owner would be very useful. I decided to return to the original white background so the businesses paperwork looks professional and is always as clear as possible. The logo remains as it helps to identify the company documents against those from customers and suppliers. Including the ID means the report will be created through a single button click in the database. Keeping these reports at hand will save backtracking to the computer system to see what jobs need to be done. The button to add information to this report is located on the job form detailed earlier. The button will add the currently displayed job onto this report. The user can then decide to print the report with any amount of jobs on it. This report keeps the same fundamentals of the previous one, those being the plain background and company logo. This report will contain a list of all the customers currently on the system database. This will be useful for the manager because it will help him remember customer information while on the job. It can act as a quick reference for customer contact details so that they can be kept informed of developments in the business. This is a copy of a company receipt. It will be created in the same manner as a report but will contain a query system so that prices can be worked out without the manager needing to do anything. The font has remained constant; however I have now included bold print for the totals and to highlight problems. This will make identifying key information easier for both customer and manager. In the style of many receipts I have now included a contact number for any problems or questions. Pressing the create receipt button found on the Job form will create this receipt. The receipt must include all the details of the transaction including the individual jobs and there prices so that it is clear to the customers where the total is obtained from. This will also make any mistakes easier to identify. Design of Mail Merged Letters A standard letter required by the user is to cover jobs that are going to be overdue. The letter will be created in a word document through a mail merge button present in the database. The letter once produced will be printed and sent to customers to inform them of the delay and the expected date for the job to be finished by. This shows the customer that they are not being forgotten and the business values their custom. By pressing the mail merge button a word document will automatically open and the outline of the letter be filled with the necessary information. The information will be entered through the use of a code on the word document. You can find an attached plan of the mail merge layout in the appendix. Design of Data Capture Forms As this is a mechanic business there is no need for any data capture forms because they cover the details entry for members and employees. A data capture form is usually sent to these people to be filled in. The information gathered is then input onto the computer system. All information of this sort is obtained straight from the customer or over the phone so this technique is an unnecessary approach. Relationships ERD- Entity Relationship Diagram TRD- Table Relationship Diagram Table Designs Customer (Customer ID, First Name, Surname, Date of Birth, Address Line1, Address Line2, Telephone Number) Request (Customer ID, Job ID, First Name, Surname, Job Title) Job (Job ID, Job Title, Estimated Price, Date of Order, Expected Completion Date) Order (Job ID, Part Name, Price, Supplier Name) Part (Part Name, Supplier Name) Query Designs Generic Buttons Within the database there are various buttons that will be considered generic. This means they have a single function that remains constant throughout the whole database. The Main Menu button presented in the corner of every form will return the user to the main menu no matter where they are in the database. The Search buttons found on numerous occasions in the database will always perform the same function of searching the database for the data present on the page. As I am designing this system for a user with very limited knowledge I have included a small explanation of what various buttons will do before they are pressed. For example Produce a Receipt is written next to a button labelled Go. This helps reassure the user that they are doing what they want. Start action: The Customer option button is selected. The Customer Form Screen is displayed Start action: The Report option button is selected The Report Form Screen is displayed Start action: The Maintenance option button is selected The maintenance menu is displayed Start action: Customer details are entered into the customer entry form and the store customer button is pressed The customers details are stored in the corresponding database table- Customer_TBL Start action: A customer is selected on the customer forms and the edit details button is pressed. The form will become active and allow the details to be changed by the user Start action: A customers details are present in the customer form and the delete customer button is pressed A message box will appear asking for confirmation of the deletion. The Yes option is chosen from this message The customers details are deleted Start action: The Add a Job is pressed on the customer entry form The customer form remains open and the Job entry form appears. Start action: The button is pressed The previous record in the system is displayed Start action: The button is pressed The next record in the system is displayed Start action: The find button is pressed while a member ID is displayed on the form. The system will search for the customer details and display those corresponding to the ID If no member ID is present the user will be prompted to enter one by a pop up message. Start action: The Add to outstanding list button is pressed after a jobs details are entered. The current job will be added to a report list that can be printed of and taken away to help remember what jobs need doing when the user is away from the system. Start action: The create receipt button is pressed A receipt will be produced using a mail merge based on the currently displayed information. The receipt will appear in a word document and include company details Data Dictionary Field Name Description of Contents Data Type Length Sample Values/Range/Set Type of Validation Expected Customer ID A number classifying each customer so they can be quickly identified in the database Long Integer 4 7 No more than four characters to be entered. No duplicates. First Name Customers First Name Text 15 Roy Required. Surname Customers Surname Text 15 Knightly Required. D.O.B Customers Date of Birth Date/Time 10 07/11/1975 Required, DD/MM/YYYY, Must be Todays date Address Line 1 Customers immediate local address Text 30 26 Hemlington Road, Walmley None Address Line 2 Further customer address details Text 30 Sutton Coldfield, West Midlands None Telephone Number Customer contact number Numerical 11 0121 345 6556 Required, Maximum 11 numbers. Must be structured in traditional way e.g. 0121 333 2233 Post Code 6 character code identifying customer address Text 8 B76 1JH Required Field name Customer_TBL Location Booking Database Purpose To store customer details Size of Individual Record: 123bytes Maximum Records Stored: 60 Total Size Required for Data: 7380 Bytes Overheads (10%) 738 Bytes Total Size Required: 8416 Bytes Field name Request_TBL Location Booking Database Purpose To show what jobs customers have requested Field Name Description of Contents Data Type Length Sample Values/Range/Set Type of Validation Expected Customer ID A number classifying each customer so they can be quickly identified in the database Long Integer 4 7 No more than four characters to be entered. No duplicates. Job ID A number classifying a job identity so it can be linked to the customer ID Long Integer 4 15 No more than four characters. Must not exceed the number of available jobs. Price Estimated price for requested job(s) Numerical 6 à ¯Ã‚ ¿Ã‚ ½15.00 A maximum and minimum value. Decimal must be situated correctly. Size of Individual Record: 14bytes Maximum Records Stored: 300 Total Size Required for Data: 4200 Bytes Overheads (10%) 420 Bytes Total Size Required: 4400 Bytes Size of Individual Record: 55bytes Maximum Records Stored: 80 Total Size Required for Data: 4400 Bytes Overheads (10%) 440 Bytes Total Size Required: 4840 Bytes Field Name Job_TBL Location Booking Database Purpose To record jobs the company can complete for customers and to identify job descriptions through their Job ID Field Name Description of Contents Data Type Length Sample Values/Range/Set Type of Validation Expected Job ID A number classifying a job identity so it can be linked to the customer ID Long Integer 4 15 No more than four characters. Must not exceed the number of available jobs. Job Name The title of a job Text 20 Wheel Change None Job Description A brief description of jobs that is unclear from their name. Text 25 Replacement of side mirrors due to damage None Price Estimated price for requested job(s) Numerical 6 à ¯Ã‚ ¿Ã‚ ½15.00 A maximum and minimum value. Decimal must be situated correctly. Field Name Order_TBL Location Booking Database Purpose To show the jobs that suppliers are providing parts for. Field Name Description of Contents Data Type Length Sample Values/Range/Set Type of Validation Expected Job ID A number classifying a job identity so it can be linked to the customer ID Long Integer 4 15 No more than four characters. Must not exceed the number of available jobs. Supplier ID Unique number to distinguish between suppliers. Long Integer 4 14 No duplicates. No number higher than those of listed suppliers. Part Name Name of part to be purchased Text 20 Bonnet None Price Estimated price for requested parts(s) Numerical 6 à ¯Ã‚ ¿Ã‚ ½15.00 A maximum and minimum value. Decimal must be situated correctly. Size of Individual Record: 34bytes Maximum Records Stored: 300 Total Size Required for Data: 10200 Bytes Overheads (10%) 1020 Bytes Total Size Required: 11220 Bytes Field Name Supplier_TBL Location Booking Database Purpose To hold details of parts owned by suppliers. Field Name Description of Contents Data Type Length Sample Values/Range/Set Type of Validation Expected Supplier ID Unique number to distinguish between suppliers. Long Integer 4 14 No duplicates. No number higher than those of listed suppliers. Supplier Name Name of supplier Text 20 Kwik Fit Required Price Estimated price for requested parts(s) Numerical 6 à ¯Ã‚ ¿Ã‚ ½15.00 A maximum and minimum value. Decimal must be situated correctly. Part Name Name of part to be purchased Text 20 Bonnet None Size of Individual Record: 50bytes Maximum Records Stored: 50 Total Size Required for Data: 2500 Bytes Overheads (10%) 250 Bytes Total Size Required: 2750 Bytes System Security The system will only ever need to be used by the one manager so with a single password access method and a lock system tool the system should be as secure as it needs to be. I will advise the manager to have a fairly long password that includes both text and numbers to make guessing the password very difficult. He is also advised to change the password on a regular basis to protect the system further. Levels of security are not a big issue for Willcare because with a very small workforce everyone sends information straight to the manager or his wife to be dealt with. It is very unlikely these employees would need to use the system and on the off chance they can be shown the password for a short time before it is changed. This method also saves the lower employees from having to learn about the system, and the system can be designed exactly as the manager wants without worrying about other employees use of the system. Data that needs to be changed e.g. a suppliers part pricing or new customer details such as an address change are to be dealt with by the manager because he must approve the changes before they take place. He can therefore keep the system to his individual specifications. Object Name Access rights / View User Customer_TBL Read only Manager Job_TBL Read only Manager Request_TBL Read only Manager Order_TBL Read only Manager Part_TBL Read only Manager Object Name Access rights / View User Customer Form Read/write Manager Reports Form Read/write Manager Maintenance Form Read/write Manager Job Form Read/write Manager Supplier Form Read/write Manager Job Prices Form Read/write Manager Data Security This security is very important because the system is protecting personal customer data. If this were to be released by accident or due to lack of security the manager would face various consequences that would effectively ruin his business. Backups will be made and updated at the end of every day. The system will be stored on memory sticks and in early cases floppy disks. Backups will be made of all areas of the database that contain personal data. Therefore it is best to save the database as a complete file. This will be fine while the business remains small but as the database grows separate backups may be needed due to the size of the file. One backup will be stored with the manager at all times while a second will be kept at a separate location away from the system. It will be the managers responsibility to backup the system daily. In the event of data loss in the system the data will be backed up on a new computer system to avoid data corruption. It will remain the managers responsibility but he may decide to employ a more experienced technician to make sure all data is restored properly. Intended Benefits 1. A faster mode of access to customer data to help with negotiations over the phone. Provides a guide to the manager to help him recognise customers, their history with the company and location. Previously paper based records had to be found within a large number of files and were unclear when compared to a computer presentation. With the system in place the manager can enter the customers name and search for all the information they have on file about them. 2. A more secure way to store and protect customers personal data. Previously the data was only kept in a locked cabinet which was still susceptible to be breakage. There was no way to backup this data without a huge loss of company time and resources. The new system will allow data to be locked with the use of a password that can be updated on regular occasions. Backups will be easy to make and the customer data protected to the highest degree possible. 3. Faster and more accurate calculations come as a benefit of a computer system saving the manager the job of manually working out bills for customers and suppliers. This improves customer service and gives the business a more professional look. With a query system the calculations occur without any work involved and are constantly correct. Limits and scope The method I chose for the company is a vast improvement but still has its own limitations due to the fact that the size of a database is constantly growing and with the system the company is incorporating it may cause slight slowdown. Limitations may only become apparent as the business grows because more and more customers mean more data and a strain on the system memory. Another problem is that the system can only provide a certain amount of help to those unfamiliar with computer systems. A basic training is still needed to familiarise the new user(s) with the fundamentals of the system. There are various functions that would have been of great use if the system had used a different type of program. For example a spreadsheet-based system would have provided easier parameters for formulas such as working out a customers final job price. It would also have been easier to design various menu screens and visual aids for the user due to the compatibility of the program for designing from scratch. The requested company logo is likely to be limited to something pre designed by the computer and as such is likely to be of a slightly lower quality. This is because there is only a certain amount of pre made designs on the computer system. It would be feasible to use a scanner to include a paper-based design however this would require more equipment, a skilled artist and a longer timeframe. Due to the fact that the user does not have the required equipment it would seem a waste of finances to invest in one for a single task. Therefore the logo will have to use computer graphics and be modified as much as possible to fit the users demands. Table Name Estimate of total number of records Size Customer 123 7380 Request 14 4200 Job 55 4300 Order 34 10200 Part 50 2500 Total Record Size 28580 This table shows that when the business begins to grow substantially and the customer count reaches that shown of around a hundred then the total size of all records will reach a very high memory, in this case 28580 bytes. If the system begins to struggle with an overload of information an upgrade is likely to be required. However from gathering information about the business through my interview and gaining an overall impression of its set-up and position I feel the chosen system will work efficiently and without problem for a fairly large amount of time. Time Line Weeks Tasks 1 2 3 4 5 6 7 8 9 10 Create Tables in database Create Relationships Create Queries Develop forms Develop reports Manager Test Period System Review Create User Guide Create Technical reference Guide Software Development Input, Output and processing printouts Forms Theses are what will be visible to the user and the customer when the system is implemented. It is therefore important that I take into account the requests the user made during the interview regarding the new system. This is the main menu that will act as a base from which the other forms can be accessed. The user will be able to return to this menu at any time through a main menu button. As this is screen most likely to be seen by the customers and user I have distinguished it with a different colour scheme from that of the other forms. I made sure the colours used were meeting the specifications of the user, in that they are clear and complimentary. I have also taken into account the computer knowledge of the likely users and maintained the design I had early chosen of a brief explanation of what each button will allow the user to do. This will help the user become comfortable with the system and maintain their understanding of how it works. The owner also requested that there be the company name present on all slides and I made it sure it is clear and remains a constant design throughout all the forms. For example when a new customer is joining the user can choose the customer option and open the customer form for the customers themselves to fill in. The customer form shown here is slightly different from my original design in that it is no longer a completely blue background. I felt this design had a more professional look while still maintaining the clearness apparent on the original design. The company logo however remains the same as that from the main menu and this helps the customer realise they are still in the correct place and are safe to enter their personal details. The customer ID will automatically move onto the next number when a new customer is being entered. The Add Customer button will take the user to the next available empty form and allow them to enter new data. All of the buttons are command buttons. They allow different functions relating to forms, reports and others. The arrows will take the user either back or forward by one through the records. This fast access will allow quick searches for customers whos ID is close to that currently displayed. The Delete Customer button will clear the form of the current information it is displaying. This in turn will delete this customer from the Customer_TBL. The Store Customer will save the currently displayed customer to the system allowing the user to add another customer knowing the previous customers records are safe. To help the user and also to make the system more accessible I have included the Add a Job button. This will allow the user once they have entered the customers details to immediately fill in a job that might be being requested for the first time. It is important to do this because otherwise the job will not be present in the system and therefore cannot be linked to that customer. It saves the user the time of returning to the main menu and re-opening the Job form. If the user does need to return to the main menu for any reason they can do so by using the main menu button which will remain constant in the same position on all forms here after. All of the buttons from my original design have been recreated except for the Edit Customer button. This has been removed because the option to change the data is available to the user automatically. This is the Job Form where the user can enter details of new jobs as well as deleting uncommon ones. This form also links the customers ID to the job they want performed, therefore the Print a Receipt button can now use both these pieces of information to print a receipt I have created in a report. The report will be shown later. The arrow buttons move forward and back through the job records and the Main Menu button returns the user to the initial starting screen. This is the Part form, which allows the user to store information regarding parts they are supplied with. The same options are available with the button commands allowing them to add or delete a record as well as moving between records. The part ID is automatic like the other IDs in the database because it is an auto number. When a new record is added it automatically moves onto the next number. The Main Menu button retains its job from previous forms. This is the supplier form. It allows the user to enter and store all of their current suppliers and keep track with what parts they provide by having a Parts ID linked to its supplier. Keeping the add and delete options for these form records as well as the Main Menu button keeps the user confident whilst operating the system. The same look and design of buttons ensure there is no confusion as to functions. This is also why I chose text to label the majority of my buttons. Queries Data Structures Tables This is the Customer_TBL. It records the information listed under the field name column. Customer ID is the primary key because it is the most unique data available. It will allow records to be found easily through a search when the database is complete. The auto number data type means the number will automatically appear in a sequential order when another customer is being added. The date of birth field is classified as Date/Time under data type because this makes it easier to add the data in this field. Under the validation rule field you can see the validation that will prevent dates being entered after the current date. The validation text that will appear when an incorrect date is entered is shown here also. The text is user friendly and makes it clear what they will have to change. It prevents incorrect data being entered in the database that will jeopardise the system. Telephone Number data type is number as this makes sure no text can be accidentally entered into the database. Post Code remains a text data type because it incorporates both numerical and text entries. Details of these fields and their validations can be seen in the data dictionary on the following page. For the postcode field I have included an input mask shown on the previous screen shot. The code I have entered will only allow data to be entered when it fits in with the structure required. The code allows any number or letter to be used as long as it is positioned correctly. This is a vital validation because a postcode is a very unique piece of data and may well be used to find or identify a customer within the database. Field Name Description of Contents Data Type Type of Validation Expected Customer ID A number classifying each customer so they can be quickly identified in the database Long Integer No more than four characters to be entered. No duplicates. First Name Customers First Name Text Required. Surname Customers Surname Text Required. D.O.B Customers Date of Birth Date/Time Required, DD/MM/YYYY, Must be Todays date Address Line 1 Customers immediate local address Text None Address Line 2 Further customer address details Text None Telephone Number Customer contact number Numerical Required, Maximum 11 numbers. Must be structured in traditional way e.g. 0121 333 2233 Post Code 6 character code identifying customer address Text Required This is the Job_TBL. It contains information about all jobs the company has previously undertaken. Any new jobs that are requested and the company feels they can carry out can be added to the list through the Add a job button on the corresponding form. Job ID is now the primary key and is the data type Auto number. The date of order and expected completion date fields both have validations preventing them from carrying inaccurate data. The date of order must be either the same as or before the current date and the expected completion date must be after the date of order date. Customer ID is now classified as a number because when a customer requests a job their specific number will be entered here by the user, classifying what jobs they want completed on the system. Field Name Description of Contents Type of Validation Expected Job ID A number classifying a job identity so it can be linked to the customer ID No more than four characters. Must not exceed the number of available jobs. Job Name The title of a job None Job Description A brief description of jobs that is unclear from their name. None The Job Parts_TBL is a link table in the database. It is present because there was a many to many relationship between the Job_TBL and the Parts_TBL. This table allows the data from both of these tables to be stored together, with a one to many relationship leaving the table in both directions. This will be shown later in the Relationship Diagram. Here you can see both the Job ID and Part ID present both classified as numbers under the data type. The JobPartsID field now acts as an autonumber for this table so that the two pieces of data can be classified together. This will allow the production of receipts and other printouts to be faster and more accurate. Part_TBL This table follows the same patterns as the previous two in that the ID, in this case Part is the primary key and an auto number. The price field uses the data type currency. This will automatically fill the cell with a pound sign when data is entered. It will help in calculations within the database and provide quicker usage for the user when filling in forms. Supplier ID is present as well so that the user can see which supplier supplies them with a specific part. Supplier_TBL My final table contains information about the companys suppliers. The table contains a part name and part ID field that will link to the parts table. The data types remain similar to those in the previous tables to keep a constant style throughout the system. It helps to keep the system less complicated for the user and helps problems become apparent quickly. Field Name Description of Contents Type of Validation Expected Supplier ID Unique number to distinguish between suppliers. No duplicates. No number higher than those of listed suppliers. Supplier Name Name of supplier Required Part ID Number to classify a certain part No duplicates. Relationship Diagram Here are the five tables described above presented in their relationship format. There are only one to many relationships present because the Job Parts table has acted as a link table between the Job and Parts tables which were previously a many to many relationship.