Changing the system of a video library Essay Example for Free

Changing the system of a video library Essay The current system is a hand written and hand handled by Mr Roberts. It is a paper database where all details of the members, transaction and return details are stored. Mr Roberts currently operates all the system by himself and he does this to keep a record of all the bookings out of the videos, he does this by pen. He finds the page in the book allocated to the member, writes when the person needs to bring it back in, takes the payment then gives the video to the member. When a new member joins Mr Roberts takes all the details down in his book, then gives the new member a member number. Mr Roberts has to check every night for overdue videos. When a members page is full, then Mr Roberts has to get a new page, this just adds to the ever-growing file of Mr Roberts. There are lots of problems with the system, it is very slow, it would wear down with over use, he cannot cope with the growing number of customers, He has to check every night to see which videos are overdue and hand type each letter and send them off the same night. This would be increasingly difficult when lots of members join. Another problem is that the videos all have to be numbered and when a video is taken out a card is put in the original case giving the video number and return date. The new system would have to display all the details of the members on one screen and show when last rental and return was. It should be able to show all overdue videos on one screen. It should be very fast and speed up all aspects of the shop. If the database is faster and easier to manage then the number of members will increase and therefore so will the profit. Jonny Sharpe Possible solutions Mr Roberts could solve all his problems by using a filing cabinet. This would solve all his problems with information handling. The advantages of this would be that a filing cabinet is easier to cope than a filing book, the disadvantages are that it is still based on paper and they could easily be damaged or lost. Another problem is that it is still time consuming and would not be any faster, if anything slower than before. Another way to cope with this problem is putting all the files onto a computer. The computer would store all the information easily. The advantages of this are that it would significantly improve the speed and ease of running the video shop. The disadvantages are that it may cost a lot of money and all staff may not be trained in how to use a computer A computer program could be writ but expertise would be needed for this and this expertise I do not have. The next best alternative is that you could use a already existing program such as Microsoft Access. The information would be stored on multiple spread sheets, the information would consist of all the members details and the video details as well. These would be good because they can handle lots of multiplications and can search through information Mark foster System Choice Microsoft office xp professional edition. Pcworld: i 519 Inc vat Any computer could be chosen as long as it has Microsoft access and a printer for printing reports. Software Justification Justify choice of software: Word: The program needs to handle numbers but word is very good at typing letters. Excel: This program would be ok for the video shop but there would have to be 1 sheet for the videos and 1 sheet for the members details. This program would not be able to type letters up and print the letters off. Access: This program is excellent, this is because you can merge the video details and the members details together to give records of loans. This program can also produce reports in letter form and print them off. Data needed 1. This database is for the videos, it should show the number code, name. 2. Members details should be shown on this page, name, address, membership number, telephone number, current video rented and the date it is due back. Design section This shows that I have made two tables to store information, one for the members details and one for the video details. I have entered 50 videos and 5o members into the tables. I have designed the system to alert me when there are overdue videos and to be able to book out videos and book in videos with ease. I linked the two together by making a link between the membership number and the video number as shown below. These next pictures are of my queries. They are update queries which update booking in and booking out of videos. They are linked between the two tables and display the videos booked out and the membership number of the person along with some details. This is my form design. The form is for a member to fill in to automatically add his details to the members table. This is my report. This is basically to inform members that they are in possession of a overdue video and they need to return it. Members have their own membership no and each video has its own video number. This way members and videos dont get mixed up. This is an application form for the video shop, members are asked to fill out basic details. Analysis 1) What do I need from my database. I want it to store information about my members, including their name, address, telephone number, membership number, date of birth. Also in each members record will be stored the video they have rented (its code, not its title to speed things up) and also the date it is due back. Customers can only rent one video per day and it must be returned the next day. I also want the database to store information about the videos, including its code, title, price, certificate and category, eg horror, action, comedy etc. I want a system that will let me book videos in and out very quickly, just by entering the members number and the video code. I also want a system to check which videos havent been returned and create a letter that could be sent out if it hasnt been returned after 1 week. Sometimes people forget they have it so this should be a polite reminder. If they havent returned it after 2 days, then I usually phone them, so I would need it to produce a list of names and telephone numbers. I will answer the other questions at a later time as there are customers in the shop. Regards. Mr Roberts 2) To collect data from new members I have a form that they fill out. They write on it their name, address, tel. number, and date of birth. I write their new membership number on it. 3) Each member has a membership number. It is a four-digit number, starting at 1000. 4) I dont use credit card details as there is too much security needed. 5) For new members I need two forms of identification, one with their name and address, i. e. a bank statement or gas bill for example and one with their photo on, i. e. theirs drivers licence or passport. 6) I havent got a password system. If you think I should have one let me know how you think it would work. The problem is that customers would have to tell me their password and other customers could overhear it so it wouldnt be that secure. Evaluation I think the final product meets the standards set by Mr. Roberts. The only mistakes I have made is that I have given the example members, membership numbers starting at 200 and they are only 3 digit. The final product can do everything specified in the design requirements made by Mr. Roberts. The opinions of the users would be on the questionnaire I made. The only improvements that could be made to my database is that I could maybe produce an automatic report displaying all the information of the member on a report whos video is late, instead of just having a basic template.

Earthquake Engineering :: Earthquakes Earth Geology Essays

Earthquake Engineering Earthquakes are vibrations felt at the surface of the earth which are caused by disturbances of the energy in the earth's interior. These vibrations are known as seismic waves. (Skinner Robinson McVerry 1) There are different type sof seisimc waves such as Primary (P) waves, whcih travel the fastest, Secondary (S) waves which cause the earth to vibrate vertically, Surface (L) waves. P and S waves are "affected by changes in the density and the rigidity of the materials through which they pass." (Columbia Encyclopedia) Earthquakes vary in their intensity and duration. Often times they are strong enough to cause massive destriction. Tall buildings often suffer as a result of these natural disasters. In recent years this has become a larger and larger threat with both the number of large buildings, and their number of occupants increasing. In an effort to try to minimize the damage caused by earthquakes many some engineers focus primarily on designing and constructing ea rthquake resistant buildings. Earthquake engineers have gathered much of their information from analyzing past earthquakes, and learning which buildings can and can't withstand the tremors. The goals of these engineers is to design buildings that can withstand moderate earthquakes and obtain minimal damage, and that the buildings will not collapse lowering the probability of human deaths. Authorities have attempted to implement codes or regulations, but that has proved to be very difficult tasks becasue there are many variables that effect the dynamic response of buildings. One way to try to avoid disaster is to evaluate seismic risk is to look at a buildings hazards, exposure, vulnerability, and location. Hazards are, for example, landslides ad soil type. Exposure is a building's occupancy and function. Vulnerability is the expected performance of a building's system, and location is how often earthquakes occur in the area. (Lagorio) Some other things that have become evident are that geometric simplicity and symmetry are key to constructing an earthquake resistant building. Simplicity often leads to symmetry, and in turn symmetry tends to decrease the likelihood of a concentration of mass. This idea of lighter buildings being safer can be explained mathematically using the formula F=MA. To understand how this formula works it is pertinent to recognize that earthquakes alone do not cause damage because all they provide is an acceleration.

John Adams Defends the Red Coats

Although John Adams defended the British redcoats at the end of 1770, the Boston Massacre actually happened March 5, 1770. Furthermore, events that led to the culmination of that night dated back to 1767 (Timeline). Many factors went into the decision, by John Adams, to defend the British soldiers. The atmosphere of the times dictated much of that evening and of that trial. For the time it was a radical thing for a man such as John Adams to defend the British troops, however his respect of the law led to his defense of the British troops.John Adams was right in defending the redcoat in the Boston Massacre trial because he saw the actions of the redcoats as nothing more than men defending their lives. In 1767, with the passing of the Townshend Acts, the civilians began their resentment towards the British Parliament as well as the British troops stationed in Boston. The Townshend Acts were a series of Acts passed by congress on June 29, 1767 to increase taxes of commonly imported prod ucts on the Colonies.Having new taxes imposed by the British as well as their military presence in Boston angered the civilians. During this time John Adams was a local lawyer in Boston working case to case (Miller Center). In late 1768 more British troops came to reestablish order in Boston per order of the Crown. The climate of this time was a hostile one on the part of the civilians. â€Å"The civilians reacted to the redcoats like they were invaders by taunting them through name calling, spitting, and fighting† (Timeline). By the time March 5, 1770 occurred, an incident had been bound to happen.With the distress of the townspeople and the presence of British soldiers, a disaster like this was waiting to happen. When the dust settled, and the day was done, 5 civilians were killed at the hands of the redcoats. John Adams, a local lawyer in the Boston area and graduate of Harvard, defended in court the men accused of the Boston Massacre. With all of the social pressure, livi ng in Boston, it would have been easy to give up but John Adams saw the law for what the law was. He did not look at it as redcoat against Boston, but as man against man.In his closing argument for the defense of the British soldiers he questioned the jury; â€Å"Would it have been a prudent resolution in them, or in any body in their situation, to have stood still, to see if the sailors would knock their brains out, or not? † (Miss, 5). As a defense lawyer it is their responsibility to make a case for the accused party as reasonable doubt. With that quote John Adams did just that. He posed a question to the jury basically saying â€Å"what were they supposed to do, roll over and die? † He saw the redcoats’ behavior as defense.The entire time the British troops had been stationed in Boston they had not once had an incident such as the Boston Massacre; the only time they opened fire on the Bostonians was when the civilians came at them in a combative manner. John Adams had every right to defend the redcoats with the plausible â€Å"it was in self defense† defense. He was a Harvard Law graduate with a law firm to run and clients he believed were only acting in self defense. His action to defend the redcoats was the just thing to do. The British soldiers were put in a position where there were either going to die or they were going to fight back.The redcoats’ job was to be soldiers for the Crown. The Crown implemented more troops in Boston on October 1, 1768 to reestablish order in that area of the country. At that time the people of Boston were growing increasingly hostile and combative. By the time the Boston Massacre had occurred there was much history between the redcoats and the civilians of Boston. John Adams knew that history and did not choose sides based on loyalty. He interpreted the situation as a â€Å"do or die† situation on the part of the soldiers and defended them as such. He used his knowledge of the law in his closing statement for the defense of the redcoats.Ultimately his position on the Boston Massacre impacted the lives of the British soldiers in a positive way. His actions were noble because he pushed aside his personal history with the city and defended his clients according to the law rather than letting the atmosphere of Boston dictate his defense and his closing argument. Works Cited â€Å"American President: A Reference Resource. † Miller Center. University of Virginia. Web. 30 Oct 2012. . â€Å"Historic Timeline. † Boston Massacre Historical Society. Boston Massacre Historical Society, n. d. Web. 30 Oct 2012. . Miss, Angela. Boston Massacre Defense. Boston: Bedford/St. Martin's, 2012. 4-5. Print.

Marketing Audit of Diesel - 1555 Words

1. Introduction Since 1950s, Jeans have become and continue to be a staple item of clothing in people’s wardrobes as a medium representing stylish identity and identification (Kramer, KR, 2006). People wear jeans for a range of occasions, from staying at home to going outside at a cinema, restaurant or even a working place. As a report from Mintel states, during the year 2006 and 2010, the percentage of adults who bought jeans had remained relatively stable with over half of them ( 51%) purchasing at least one pair in 2010 (Mintel 2010). At a time when the number of brands offering jeans has risen rapidly, Diesel, which has built an entire existence of passion, originality and creativity, emerges as a strong competitor towards the†¦show more content†¦The radical nature of all its products makes the awareness of its loyalists that Diesel is selling the view that the world is a â€Å"single, boarder-less macro-culture† and a sense of involvement in the premium, dynamic lifestyle rather than simply selling high-quality jeans. 2.1.2 Co-branding collaborations Even though Diesel is extremely successful and influential in the market of luxury and high fashion, it encounters the strong competition from Levi’s, the market leader, and pioneering companies who offer similar products like Lee and Wrangler. Unstable environments, dynamic markets, intense competition, and high costs to enter new markets force companies in various industries to adopt non-traditional, innovative branding strategies, including cobranding, in an attempt to exploit their existing brand equity (Desai Keller, 2002). In recent years, Diesel has collaborated with different range of well-established manufacturers to produce special edition items. This strategy usually provides a tool for differentiation that leverages brands through the transfer of positive associations, such as brand-quality, image, or awareness, from one brand to another (McCarthy Norris, 1999; Simonin Ruth, 1998; Washburn, Till, Priluck, 2000). Diesel did co- branding with L’Oreal to launch a series of â€Å"Fuel for Life†Show MoreRelatedEssay Marketing Research on the New Volkswagen Golf1559 Words   |  7 PagesMarketing Research on the New Volkswagen Golf Marketing research aims to take some of the risk out of marketing decisions by providing information that can form part or the entire basis of decision-making. It is applicable to all aspects of marketing-mix decisions and should be an integral part of the process of formulating marketing strategy. Marketing research by definition is the function that links the consumer, customer and public to the market through information- information used to identifyRead MoreSwot Analysis for Cheerios2843 Words   |  12 PagesMarketing Audit: Internal Audit: Brand: The brand Cheerios is co-owned by Nestle and US company General Mills, but operates under Nestle for consumer recognition purposes in the UK. Consumers associate Nestle with high quality products and worldwide recognition. Cereal Partners is the UK manufacturer name with their aim being to provide â€Å"high quality, great tasting healthy products† (Nestle, 2012). Cereal Partners UK has established itself as the second largest manufacturer in the UK, with over 25%Read MoreIntroduction of Pakistan State Oil3784 Words   |  16 PagesINTRODUCTION Pakistan State Oil (PSO) is the oil market leader in Pakistan enjoying over 78.2% share of Black Oil market and 54.3% share of White Oil market. It is engaged in import, storage, distribution and marketing of various POL products, including Mogas, Diesel, Fuel Oil, Jet Fuel, Kerosene, LPG, CNG and petro-chemicals. This blue chip company, the winner of Karachi Stock Exchange Top Companies Award and a member of World Economic Forum, has been a popular topic of case studies in PakistanRead MoreSaudi Arabias Market Audit1528 Words   |  7 PagesI. Introduction Saudi Arabia’s market audit has both external and internal influence. The external influence will be about customers’ perception, competitive, location, distribution, and economic condition. On the other hand, the internal influence which is the product, company brand, human recourse, and what marketing strategies Macy’s will apply the Saudi’s market. II. The Product There are several aspects to evaluate the product as innovation as it is perceived by the Saudi’s market. 1. RelativeRead MoreIndian Oil Corporation Ltd. an Internship Report6090 Words   |  25 Pagesmanner, which helps in the shaping and achievement of success. Firstly, I would like to express my sincere gratitude to Mr. Nilesh Nekaljay, Manager (TD) for granting me the opportunity to undertake an internship at the Indian Oil Corporation Ltd. (Marketing Division, Mumbai). I am extremely grateful to my project guide, Mr. Vigyan Kumar, Manager (Retail Sale) for his encouragement and patience throughout the duration of this project. Without his vision, guidance and support this report would not haveRead MoreAnalysis Of Ford s Board Of Directors Essay1680 Words   |  7 Pages2. Internal Audit a. The Management Team Ford’s Board of Directors consists of 15 members. The Board is lead by the Executive Chairman William Clay Ford Jr.(age 58). He is the great-grandson of Henry Ford Sr. After earning his BA from Princeton University, he began a lifetime of service in the family firm (1979), culminating in his appointment as president and CEO in 2001. As CEO, Mr. Ford improved quality, lowered costs and delivered exciting new products. During his time in that position, he tookRead MoreCorporate Social Responsibility and Apples Business Practices1711 Words   |  7 Pagesfrom the worker class in the formulation of labor unions. This allowed the world to see the situation from the workers perspective. The governmental structures began to create regulation for the wellbeing of the people. The 1950s saw changes in marketing that encouraged businesses to explore social and human factors in their respective markets. The world evolved furthermore with the advent of the Internet and globalization. Env ironmental awareness was on the increment and international standardsRead MoreAnalysis of Recruitment and Selection Process3149 Words   |  13 Pages7 Corporate Management 2.8 Organization structure of POCL 2.9 Organization structure of P amp; A Department 2.10 Functions of different departments 2.10.1 Functions of Marketing amp; Sales department of POCL 2.10.2 Functions of Operations Department 2Read MoreSkoda Case Study2118 Words   |  9 Pages To aid its decision-making, Ã…  koda UK obtained market research data from internal and external strategic audits. This enabled it to take advantage of new opportunities and respond to threats. The audit provided a summary of the business’s overall strategic position by using a SWOT analysis. This case study focuses on how Ã…  koda UK’s management built on all the areas of the strategic audit. The outcome of the SWOT analysis was a strategy for effective competition in the car industry, and allowedRead MoreSkoda Case Study2110 Words   |  9 Pages To aid its decision-making, Ã…  koda UK obtained market research data from internal and external strategic audits. This enabled it to take advantage of new opportunities and respond to threats. The audit provided a summary of the business’s overall strategic position by using a SWOT analysis. This case study focuses on how Ã…  koda UK’s management built on all the areas of the strategic audit. The outcome of the SWOT analysis was a strategy for effective competition in the car industry, and allowed