Designing a database for a supermarket Essay Example for Free

Designing a database for a supermarket Essay 1,1 The problem and how I discovered it- I discovered the problem when I was buying in this standard supermarket and I saw that some of the products where expired and were stale. I also noticed that some of the buyers or consumers were taking this product without knowing the consequences of them on their body. This is a picture of the supermarket. 1,2 The Business- This business is of a supermarket which is located in Alejandra del Castillo in San Fernando in the south of the Island of Gran Canaria. I was doing a survey on the supermarkets as a consumer when I discovered that some of the products were stale. I told the manager about the problem they asked me for help. 1,3 The real User- The manager is the in charge of dealing with these type of problems. Although in this case Mr.Angel, the manager is not able to find the solution to this problem. In this case I have decided to help him and to provide a better service to the customer. 1,4 The current problem and inefficient- The current main problem is that the manager or the employees arent getting to know when the food is going stale or is running out of date. Im being asked to create or to find some kind of solution to solve this major problem. There are many problems with the method that the employees are using now which is to go around checking each and every product for there date of expiry. They have been facing many problems with their method. For example: *There arent as many employees as needed for this method. *It might result a bit boring *Can produce headaches and blurry eyesight. *Different products have their expiry date stamped on a different place. This can be difficult to find. *Maybe some of the products arent visible to the employees and do not look for their expiry dates. 1,5 The manual and PC way- Manual way-This problem can be solved by making six different sections and assigning six different people to look for the expiry date. Also I would like to include that it would also make the in-charges life more easier if the products were placed in a more visible and easier accessible place so that none of the products are missed out. PC way- This method would be a lot more easier because it wouldnt include as many people as the manual way. This method consists of creating a spreadsheet using Microsoft Excel. While learning I discovered a all new way of using excel. I mean that if the company creates as spreadsheet and inputs the amount of the product, the expiry date and include a photo and a brief description of the product and where it is located exactly. This would only involve one persons effort and would be a lot more efficient and would provide better services to the customers. 1,6 Objectives- *Create a Spreadsheet to solve the problem. *Create a chart showing before and after. *Create a Spreadsheet with the bar-codes and date of expiry. The date of expiry must be warned a couple of days in advance. * Use professional language. * Auto-fit values. * Dont make any errors * Check formulas TWICE * Use less staff. ANALYSE 2,1 Hardware- In my solution I will be using a LCD(Liquid Cristal Display) as an output device and a scanner or a 12,0 megapixel digital camera as an Input device, this is because I will need high resolution pictures or Photos to provide the company with the solution, i will also use a baar-code scanner to introduce the products bar-code. 2,2 Software- I am going to use Windows XP professional because its easier to use that the Windows vista and more complex than the Windows 2000 Operating System. I will be using OO(Open Office) Package so that I can provide or accomplish my solution correctly, I chose this becuse it has the same functions and options as the Microsoft Office but its free and can be downloaded easily An Anti-Virus will be required in case of any viruses are introduced into the computer Via Internet, I will choose the Kaspesky Anti-Virus because its more advanced and quicker, 2,3 Data Input- Data Type Collection Input Validation Bar-code Information Product Bar-code reader Not negative Photographs Image Internet Digital camera Not negative Graph Information Spreadsheet ToolbarTools Not negative Excel formulas Formulas User Keyboard Not negative 2,4 Data processing- 2,6 back up and security- As the Document we are doing is very important we must always remember to save it, this could save us a lot of typing because if there is a power cut documents wont get erased. We should remember to save our document every 5-10 minutes ,also we need to save it when we change or insert something manually. You should save it on your PCs desktop or in My Documents also it would be intelligent to save documents on two other or externel hard disks or send it to your own e-mail. The size of the file depends on the type, for example if it is done in excel, word or powerpoint , it would also effect the size of the document if there is facy coloured writing, outstanding writing or lots of pictures. Normally a word document of 10 -12 pages with three to four coloured pictures would weigh 294 KB (302.026 bytes), this means you would be able to save three thousand more files like this on a one gigabyte pendrive. Yes, I will set up passwords to my document incase a hacker or spammer brakes in and steals my data, this way I will be sure to have a unique solution to the problem. I can set passwords to documents by going on ToolsOptionsSecurity and set up the password. The Data Protection Act means the right to protect your own data, this is a part of legislation. We might use this because we need to consider the rights we have to protect our own typed data. IMPLEMENTATION 4,1 3 to 5 printouts with errors- -Error 1- The first error committed was that some of the pictures of the products are missing. This could lead to confusion and would seem difficult to identify the product. -Error 2- The second error was that some of the dates arent in the correct format. The Dash to separate the day from the month and year are missing. -Error 3- The last error made was that the currency wasnt in a correct format, some of the values were in euros and others were in pesetas. 4,2 Screenshots I will be creating 2 graphs, one to represent the number of products expired and the number of products close to expiry. It will look like this It will be a pie chart on the top left corner with a 3D look and the key on the left. This graph will tell the user the number of products close to expiry, this will warn the staff to put the product close to expiry in the front in order to sell it soon and it wont expire. The second graph in the spreadsheet will present the number of products expired. The bars will be in pyramid shape and with a 3D look, it will be on the left hand corner. The key will be on the right and the pyramids will be dark blue. It will be from A1 to D25.They will be dark blue. This is a new and a very effective method as it shows that lots of products are expiring and it warns the user to take a step forward in order to prevent the cheese expiring. The spreadsheet will have a main, the first one is to link to sheet two and the other one to sheet three. I have added the company logo. It will have a title in bold and underlined and an attractive backgound. I have included images to identify the product correctly. This could help the staff to find the product which is close to its expiry. I have added a button to change colour to red. This is a macro. 4,3 Test Results I have checked all spellings so that no mistakes or errors are made. Also it makes the spreadsheet look more professional and gives a good impression. It gives a high influence on reader and gives a professional feeling, I have included images of the product and i have also compared them to the original product in the supermarket so that the products look and are the same and this way if the name is typed incorrectly at least the employee can look for it and correct its name. I will be including the bar-code because it will de easier lo identify the product and also a mobile phone or a cordless bar-code reader can read it easily. This would make work a lot faster because more employees can scan the products at once. The number of products has been counted and double checked. Also there is a column showing how many articles there are and the days left for their expiry. An IF formula has been created to warn the incharge if there is a product with less than 2 days left for 4,4 Objectives I have created a spreadsheet to deal with the problem I have created a chart showing the before and after. I have included dates of expiry. EVALUATION 5,1 Objectives accomplished- à ¯Ã‚ ¿Ã‚ ½Use fewer employees à ¯Ã‚ ¿Ã‚ ½Create a graph showing the number of products expired before and after the method. à ¯Ã‚ ¿Ã‚ ½Create a spreadsheet à ¯Ã‚ ¿Ã‚ ½Create at least to graphs with examples showing products expired on the spreadsheet. à ¯Ã‚ ¿Ã‚ ½ Use spell-check to check spellings. à ¯Ã‚ ¿Ã‚ ½ Create a main menu to graphs on the spreadsheet. à ¯Ã‚ ¿Ã‚ ½Include product images à ¯Ã‚ ¿Ã‚ ½ Include dates of expiry and days left. I did use fewer employees because this method used to deal with the problem only needs employee to type in the data and possible two others to re-check dates of expiry. I did not create a graph showing the number of products expired before and after the method used to deal with the problem but instead I created a table showing this data because it is easier to find information. I confirm that I have created a spreadsheet to deal with this problem. I have created two graphs, one showing the number of products expired and the days left for expiry and the second one showing the name of the product and the number of them expired. I have used spell-check in my solution my gathering all data and pressing F7. This function uses the dictionary on the computer and corrects any errors. My spreadsheet has a main menu linking to graphs on other sheets. I did this by the hyperlink option under the insert option. I have included product images but they have been collected from the internet and arent accurate and therefore not reliable. 5,2 Test- 1. Do you think the objective number 1 has been accomplished properly? vv 2.Is the solution correct? 3.Is the layout or format correct? 4.Do you think the objectives could be improved? Or if others could be added and which? 5. Is the idea of the images correct? 6.Would it be a good idea to highlight formulas? 7.Which of the objectives do you think are invalid? 8. Which of the methods used to accomplish objectives could be improved? 9.Do you accept that it would be a better idea to create a graph rather than a table showing the products expired? 10. Do you think that the images should be taken of the actual product and not the internet? 5,3 I could improve I think that if I took the actual photo of the product it would be more reliable as it is taken of the actual article and maybe the internet gives the incorrect picture which could lead to confusion and problems. It would also be better if I check the spelling using a dictionary rather that the computers dictionary as word feed into it might be incorrect and mean something else.

A Hosts Hospitality Essay -- Sir Gawain and the Green Knight Essays

A Host's Hospitality In Sir Gawain and the Green Knight, an epic written in fourteenth century by a contemporary of Geoffrey Chaucer, we learn about a knight and his quest. Sir Gawain, sworn to seek the Green Knight as part of a deal, first finds himself in an enchanted and beautiful forest and then ushered into a beautiful castle of Bercilak, its host. Bercilak's court seems so like Arthur's that it appears to offer Gawain a familiar refuge in alien territory. The orderliness and beauty of the forest and the castle recall the civilized world of Arthur's court. Gawain is welcomed as warmly as if he has arrived at Camelot. The abundant hospitality and congeniality of the host and servants are clear in this scene, and they put Gawain at ease. First, the porter at Bercilak's castle assures Gawain that "a noble knight such as he will not want for a welcome"(SGGK l. 814). Next, the host welcomes him whole-heartedly and lays all that he owns at Gawain's disposal. He also sends a servant to see to Gawain's need s, makes sure he slips into something more comfortable, rests and eats. To...

Google Case: Ethical Principle

It is rather difficult to talk about ethics as it involves different point of view based on different moral standards one has and based on different ethical principles one uses. This Google China-cases mostly talks about the ethical dilemma faced by the company, whether it should obey the local law or put its global ethical standards as its best interest. Obeying the local law will push them to do self-censoring, which then raise many criticism internationally. Based on ‘cultural relativism’, it is said that ethics are nothing more than the reflection of a culture – all ethics are culturally determined, so that each firm should adopt the ethics of the culture in which it is operating. It has been explained before that China has an totalitarian political system contrasts with the Western culture which supports civil rights and liberties. So, based on this theory, doing self-censoring may be considered as ethical. However, this pragmatic view won’t be very suitable for justifying an action. The restriction from the Chinese government regarding some sensitive political themes may be recognized by some international people as denying the human rights. Here, based on the rights theories, human beings have fundamental rights which establish a minimum level of morally acceptable behavior. Because of the censoring, Chinese people lose their freedom of speech, especially less freedom in receiving information. However, it is part of their law and political system, which should be accepted by every company who wants to conduct business in China. Some Chinese people have accustomed with the censorship, not consider it as violating human rights, and support it for the sake of the nation. By self-censoring their website, Google is complicit with the Chinese government’s effort to restrict the freedom of speech. According to ‘Kantian ethics’, it is wrong toward treating people as means, since people should be treated as ends and never as means to the ends of others. When deciding that the benefits of operating in China outweighed the costs, Google used the ‘utilitarian approaches’. It holds that the moral worth of actions is determined by their consequences. An action will be judged as ethical and desirable if the balance of best consequences are over the bad consequences. What are the benefits and the costs should be measured carefully by Google. Google claimed that ‘Google. cn’ would provide better internet service to its customers in China while making more profit for the company. It also raised ethical awareness by making its users aware that some results were omitted, thus also put pressure on the other companies to do the same. In addition, it is better to give Chinese users access to information, than to none at all. Those practical and ethical benefits combined with the increasing profit has been considered by Google as outweighing the negative effects of censorship. The negative effects for the company might be criticism for the inconsistence with the ‘Don’t be Evil’ motto. For Chinese people, I think, there will be no significant net negative effects as the Chinese users will still get the censored search results, since the government would block the contents using the â€Å"Great Firewall†. After months criticism, Google shut down its Google. cn. It tried to regain its integrity and to protests implicitly the censorship in China. The reasons might come because it realized it couldn’t give better services to Chinese users due to many problems, it had denied the human rights, and also it gained the lower market share and profit rather than expected. It made greater harm for the company. In my opinion, China has different culture and law that should be considered before a company conduct business there. Each company should obey the rules in which it is operating. Censoring is considered as denying human rights in many parts of the world – especially USA, but in China it should be done in order to gain greater advantages for the whole nation. The problem here is because Google has basic ethical principle of ‘Don’t be Evil’ which contradict this kind of action. Moreover, it won’t influence much to Chinese users whether Google stays there or not, as it has better local search engine – Baidu. That is why, considering the condition and all the consequences, it is better for Google to leave China. Next, we can analyze this case based on Kantian perspective called ‘Universalizability’. It means that the companies have the duty to commit only those actions which could be universally applied. It can be demonstrated by the question: â€Å"What if every company agreed to self-censor in order to gain access to China? †. The answer is there will be unbeatable suppression of rights of freedom of speech and information. On the opposite question, the multinational corporations may influence the societal change and perhaps will improve the level of freedom of speech in China.

Themes Of Anne Sexton - 1069 Words

Themes from Sylvia Plath, Anne Sexton, Gwendolyn Brooks, and Robert Hayden An Evaluation of themes from Mirror, Courage, Explorer, and Douglas During the 1900’s, a series of new poets came into existence. These poets brought about new themes and perspectives that manipulated the minds of humans all across the world. The poets that are in our study are Sylvia Plath, Anne Sexton, Gwendolyn Brooks, and Robert Hayden. These four poets wrote detailed, intricate poems that are packed full of a slew of different themes and perspectives. These themes can be distilled and life lessons can be derived from them. Raymond A. Schroth states intelligently, â€Å"Perhaps the best way to define courage is to live it.† Anne Sexton’s poem Courage thrives off of†¦show more content†¦Her unique poem lays down a line of different instances of courage throughout, and describes courage in a way never thought of before. Sexton elaborately states in lines 20 and 21 of her poem, â€Å"Your courage was a small coal that you kept swallowing.† Sheâ⠂¬â„¢s explaining in this quote that courage has always been inside everyone, and when everyone is little, they bury it down and don’t let it breach the surface. However, as humans grow and experience, they become more and more open, and courage begins to flow from the souls of everyone. Maya Karsh states in her poem Courage, â€Å"Courage is not your strength, but the ungiven fighting part of you.† Brilliantly states by Karsh, courage is the driving force within all humans, capable of great things. Moreover, Sexton portrays this message thoroughly within her poem. Within Brooks Explorer, she encourages the message to never hold back on making choices. Within her poem, a man is faced with numerous choices to make as he explores his apartment. She states in line 12, â€Å"He feared most of all the choices, that cried to be taken.† Brooks is desperately trying to show her readers that one shouldn’t be afraid to make choices, or to explore, because explorat ion and more importantly choices, are crucial to human survival. Without the ability to choose, humanity would be tuck in an endless loop of pain, therefore, Brooks begs us to utilize this marvelous skillShow MoreRelated Anne Sexton: Poetry as Therapy Essay1439 Words   |  6 PagesAnne Sexton: Poetry as Therapy Many great literary and artistic geniuses have been troubled with deep depression and mental illness. Anne Sexton is an example of a poet with such problems who used her personal despair to inspire her poetic works. Not all of Sextons work is based solely on her mental health; but a good portion of her work is influenced by her constant bouts with depression. As she struggled to deal with her own marital infidelity and the problems associated with being a femaleRead MoreSylvia Plath and Anne Sexton1240 Words   |  5 Pages â€Å" Confessional Poets† Sylvia Plath (1932-1963) and Anne Sexton (1928-1974) both explored similar themes such as tone, structure, and symbolism. Many of their poems were cries for help, which resulted into metal illness, depression, and suicide. In 1958, Anne Sexton and Sylvia Plath met, and much to their surprise had a few things in common. They both were fascinated with death and suicide. Both Sexton’s and Plath’s poetryRead MoreAnalysis Of Self In 1958 By Anne Sexton1647 Words   |  7 Pages Throughout all the years of her poetry, Anne Sexton continues to make powerful connections. All things considered, Sexton was talented in using symbolism in her poems. Her analyzed poem â€Å"Self in 1958† allows people to view the multiple symbolic pieces in her work. Examples varying from a dollhouse to a plaster doll itself. Yet, when she uses these interesting pieces of symbolism, it turns out to be a much deeper concept than once thought. The doll in this poem, in turn becomes an extremely largeRead MoreAnne Sexton : An American Poet1216 Words   |  5 PagesContext: Anne Sexton was an American poet born on November 9th, 1928 in Newton, Massachusetts and raised in Weston. Her family was successful economically wise and Sexton was raised in a middle-class environment; however, Sexton’s relationship with her parents were extremely strained and perhaps abusive; her father was an alcoholic. It was suggested that Sexton may have been sexually abused by her parents and felt that they were hostile to her. As such, Sexton sought refuge in her close relationshipRead MoreEssay On Anne Sexton891 Words   |  4 PagesContext: Anne Sexton was an American poet born on November 9th, 1928 in Newton, Massachusetts and raised in Weston. Her family was successful economically wise and Sexton was raised in a middle-class environment; however, Sexton’s relationship with her parents were extremely strained and perhaps abusive; her father was an alcoholic. It was suggested that Sexton may have been sexually abused by her parents and felt that they were hostile to her. As such, Sexton sought refuge in her close relationshipRead MoreConfessional Poetry Essay1640 Words   |  7 Pages Confessional poetry was not purely autobiographical, but did often express deeply disturbing personal experience. (Academy of American Poets) Three important poets who are typically associated with the confessional poetry movement are Anne Sexton, Allen Ginsberg, and Denise Levertov. An analysis of selected works from these poets yields a deeper insight into the individual poets and the broad differences among them. Poetry rarely flourishes in a vacuum. As such, the influences and historyRead MoreThe Comparison and Contrast of Anne Sexton and Sylvia Plath Essay example1646 Words   |  7 PagesComparison and Contrast of Anne Sexton and Sylvia Plath The two poems, â€Å"And One for My Dame† by Anne Sexton and â€Å"Daddy† by Sylvia Plath, both explore similar themes through the use of literary elements such as structure, tone and symbolism. Structures in each poem are alike with length but differ with the actual form. The tone Plath conveys is negative one while Sexton’s is more neutral. The symbolism in â€Å"Daddy† was also negative with symbols of the devil but Sexton used a nursery rhyme as a symbolRead MoreMary Sexton s The Grimm Brothers And Anne Sexton948 Words   |  4 Pagesforgot to invite the twelfth wise woman. The twelfth wise woman enters the feast full of anger and cast a horrible spell on Briar Rose. This story of Briar Rose has evolved over time into two stories by different authors, the Grimm brothers and Anne Sexton. They each have different perspectives on the author’s past and the role of the father making. These differences make the fairy tale propose two different stru ggles of both social level and a broken family. Authors’ viewpoints are often shownRead MoreCinderell An Outdated, Lying, Anti Feminist Tale?925 Words   |  4 PagesCinderella: An Outdated, Lying, Anti-Feminist Tale? Anne Sexton was a junior-college dropout who, inspired by emotional distress, became a poet. She won the Pulitzer Prize as well as three honorary doctorates. Her poems usually dealt with intensely personal, often feminist, subject matter due to her tortured relationships with gender roles and the place of women in society. The movies, women’s magazines and even some women’s schools supported the notion that decent women took naturally to homemakingRead More##xiety In Courage, Gwendolyn BrooksThe Explorer, And Frederick Douglass732 Words   |  3 Pagesany single poetic or critical movement or aesthetic school.† All poetry has a different theme that it focuses on, or does it? In these four poems, there is a strong sense of social anxiety, and then the overcoming of that with courage. In Sylvia Plaths Mirror, Anne Sexton’s Courage, Gwendolyn Brooks’ The Explorer, and Robert Hayden’s Frederick Douglass there is a strongly shared theme. To start off is the theme of social anxiety in Sylvia Plath’s Mirror. This poem is about a mirror that spends most