Premium Essay

Cashier

In:

Submitted By gulammohiddin
Words 1498
Pages 6
5330: Database Systems I

Spring Semester 2015

Project 1

Name:

ID:

Optional comments related to the project submission:

Instructions You will need provide your answers in a word document and deliver via Blackboard. Also you need to return a backup of your database in the form of sql scripts. Create a zip file packaging everything together and upload this .zip file on the Blackboard. The deadline is March 4th, 2015 Each day of late delivery will cost you a penalty of -25%. You are expected to use an SQL DBMS software (preferably MySQL server) to design your database and then transfer your code in a word/latex document. This document has to be editable. Do not upload pdf files because it is not easy for us to copy-paste your contents while grading. Please also deliver, within your document, the output of the queries. For each one of the tasks there is included very detailed information about the delivery requirements, which you have to read very carefully.

START OF PROJECT DESCRIPTION “Database for the management of your books”

You are provided with a description of the following procedure:

Brief description You want to develop a database in order to organize your books. Looking at your bookshelf you notice that you have some books more than one time: there might be a book you have multiple times but each copy has been published by different publishers. Your books are of various thematic categories (history, novel, poetry, science). Each one of your books is either a hard-copy or a soft-copy. The condition of your books varies from poor to mint (poor, acceptable, good, very good, mint). Every now and then, you buy new books and you want to somehow keep track of your purchase activity. Finally, you want to collect information regarding which books you read, which books you want to read as soon as possible and the rating (one star to five

Similar Documents

Premium Essay

Um Yea

...| | Panera Bread Company | The observation and analysis of a fast food restaurant | Panera Bread Company | The observation and analysis of a fast food restaurant | Background Information Rationale I chose to observe operations at Panera Bread Company (Panera) based on two factors: 1) I like the food and overall ambiance – I think Panera uses ingredients that are fresher and of higher quality than more traditional fast food restaurants. I also like that customers can sit down to eat using proper silverware and plates rather than using plastic utensils eating off of paper wrappers and plastic forks. Many Panera locations also have a patio, for al fresco dining, a cozy fireplace, for the winter months, and a small section with upholstered chairs and sofas. 2) Panera offers free Wi-Fi – this was an important factor because I wanted to take notes during each visit without bringing attention to myself. Because Panera offers Wi-Fi, it is not unusual to see customers with laptops. Visits I visited three different Panera locations over the course of several weeks and spent approximately 2 hours at each location. Location | Date and time of visit | Order Placed | | | | 5600 Urbana Pike | April 6, 2010 | Cuban Chicken Panini with chips as a side, an unsweetened iced tea and a Toffee Nut Cookie | Frederick, MD‎ 21704 | 2:40 PM | | 136 Nassau Street | April 11, 2010 | Tuna Salad Sandwich (standard condiments replaced with Dijon mustard and...

Words: 4450 - Pages: 18

Premium Essay

Business

...company uses the periodic method. FIFO: $1,410 150 units multiplied by $8 equals $1,200 30 units multiplied by $7 equals $210 $1,200 plus $210 equals $1,410 LIFO: $1,160 100 units multiplied by $6 equals $600 80 units multiplied by $7 equals $560 $600 plus $560 equals to $1,160 Therefore, the phantom profit would be $250 if the company were to use the FIFO rather than LIFO. Question 4. Compute the lower of cost or market valuation for O'Connor's inventory. 12,500(camera)+9,000(camcorders)+12,800(DVD’s)= $34,300 Question 5. Establishment of responsibilities: Only cashiers may operate registers. Segregation of duties: The duties of receiving cash, recording cash, and having custody of cash are assigned to different individuals. Independent and internal verifications: Daily cash counts are made by cashier department supervisors. Human resource control: All cashiers are bonded Physical controls: All over-the-counter receipts are registers. Question 6. Segregation of duties: 3 Establishment of responsibilities: 1 Physical controls: 5 Independent and internal verifications: 4 Documental procedures:...

Words: 259 - Pages: 2

Premium Essay

Home Depot Case Study

...standards of hiring by reinforcing gender stereotyping; causing them to be guilty of disparate treatment. The disparate treatment in this case was due to women being treated differently in comparison to their male co-workers in regards to promotions, pay, and hiring. Female applicants who felt discriminated were mainly those who applied for jobs within Home Depots West Coast Division. They felt they were being overlooked during hiring and bypassed in connection with promotions, salary, and job assignments opportunities within the workplace. Home Depot, however, felt they did nothing wrong and stated the unfairness of what they were being accused of was due to most female job applicants having experience as cashiers, so they were placed in similar positions, such as, cashier positions, clerical duties, customer service, and so forth. In addition, their explanation for the high turnaround in percentage of male employees within the home repair, plumbing, carpentry departments, etc… were due to male applicants expressing interest in those type of skilled employment. 2. How does this case illustrate the application of new technology to solving issues that have never been tied to technology? Can you think of other ways technology might be used to address diversity/EEO/affirmative action issues? Home Depot was able to tie technology by solving issues by introducing a Job Preference Program, which provides in-store computer kiosks that allow...

Words: 310 - Pages: 2

Premium Essay

Tourism Development Feasibility Study

...CHAPTER I. INTRODUCTION A snack bar usually refers to an inexpensive food counter that is part of a permanent structure where snack foods and light meals are sold. A beach snack bar is often a small building situated high on the sand. Besides soft drinks, candies and chewing gum, some snack bars sell hot dogs, hamburgers, french fries, potato chips, corn chips and other foods. While this is usually the case, sometimes "snack bar" refers to a small café or cafeteria. Various small, casual dining establishments might be referred to as a "snack bar," including a beverage and snack counter at a movie theater and/or a small deli. Many places that have snack bars have a "No Outside Food or Drink" policy, to encourage sales. The first known use of the word "snack bar" was in 1930. A snack food or commonly called snack is seen in Western Culture as a type of food not meant to be eaten as a main meal of the day, unlike breakfast, lunch or dinner but rather a assuage/moderate a person’s hunger between these meals, providing brief supply of energy for the body. The term way also refers to a food item consumed between meals purely for the enjoyment of its taste. Snacks are terrific way to satisfy hunger and get all the vitamins and nutrients your body needs. For people who has hectic schedule on school, work, travelling and other activities, it may feel like there’s no time for healthy eating. When trying to stop eating, it’s probably tempting to go the quick...

Words: 4230 - Pages: 17

Free Essay

Cashier

...Summary  (6yrs Customer Relations, 4yrs Retail, 2yrs Hostess).Pursue a position of Host/Hostess in  which customer service orientation and interpersonal skills, along with professional attitude  towards clients, is valued and appreciated. Performing my role with full dedication, integrity  and care to make a significant contribution to the image and profits of the hospitality  organization.      PROFESSIONAL EXPERIENCE    Leftys­ Cashier/ Server/ Hostess Houston, TX                          Nov 2012­Nov 2013  ● Received and welcomed the guests with due attention; greeted them with a smile.  ● Provided highest quality of service to the customers by making seating  arrangements and room booking prior to their visit.  ● ● ● ● Presented the guests with menus and explained any special cuisines to be served.  Ensured food quality before serving, presented it in the most appetizing way.  Assisted the customers by working out their queries and grievances.  Coordinated with other staff to ensure the availability of best service for the guests.    Forever21­Cashier/ Sales Associate Gretna, LA                      Sep 2011­Nov 2012  ● Engage customers in order to provide to them what they need in terms of product  and quality services  ● Promote brands when instructed  ●  Process transactions in a time efficient manner  ● Maintain work area in terms of cleanliness and hygiene  ●  Communicate current product features and benefits to customers  ● Provide administrative assistance to marketing department ...

Words: 433 - Pages: 2

Premium Essay

Cashier

...How does purchasing activities influence the profitability of the foodservice establishment? In an organization such as the food service industry its major objective impacting the maximization of profit, one of the most vital role in an establishment striving towards success is being knowledgeable in the purchasing activities of on establishment. Conversely, the failure to properly control food costs can have a more devastating effect than overspending in most other cost categories. It is not surprising that the primary concern of many operators is their food cost. As costs increase, this concern grows. Rising food costs often force management to re-examine the operation's ordering / purchasing needs. However in the food service establishment after menu planning is completed, the Ordering / Purchasing control point is the next logical step to be addressed. In fact, the menu determines the ingredients to be purchased, the variety of products needed, and the relative amounts. One of the major objectives of Ordering / Purchasing is to obtain the right quality and quantity of items at the right price from the right supplier. The goals are to maintain quality and value, strengthen the establishment's competitive position, and also to minimize the investment in inventory. Therefore, cost avoidance in Ordering / Purchasing has potentially translated directly to the operation's bottom line of the establishment. To be successful, the buyer must possess many skills. Broadly speaking...

Words: 2485 - Pages: 10

Free Essay

Cashier

...Pr. Anna Pinkas MMP100 - Introduction to Multimedia Tutorials ! ! WEEK 9 - SIMPLE ANIMATION WITH PHOTOSHOP: HD VIDEO ! Installing the font ! 1. Double click on Righteous-Regular.ttf 2. Click on the Install Font button ! a New Document for HD video output Creating ! 1. Open Photoshop 2. File > New a. Width: 1920px b. Height: 1080px c. 72ppi d. RGB e. OK 3. File > Save As a. Name the file “hungryOwl_video” b. Set the file format to Photoshop (.psd) c. Save ! the background Creating ! 1. Rename the first layer “background” 2. Double-click on foreground color and set it to #242424 3. Select the bucket tool (G) 4. Click anywhere on the canvas to fill it with dark grey ! the text Creating ! 1. Select the type tool (T) 2. Set the font-family to Righteous, Size to 320px, Color to #4d4d4d 3. Click anywhere on the canvas and type “hungry owl” a. Click on the Check Mark in the top options bar to commit 4. To center the text on the canvas: a. Select All (Cmd + A) b. Activate the move tool c. Use the centering icons in the top option bar d. Deselect (Cmd + D) 5. Make 2 copies of the font layer (Cmd + J) 6. Rename the layers “font1”, “font2”, “font3” 7. Add noise to each layer: a. Activate the “font1” layer b. Filter > Noise > Add Noise i. OK the rasterize alert window ii. Set the amount to 20 iii. OK c. Activate the “font2” layer d. Filter > Noise > Add Noise i. OK the rasterize alert...

Words: 1947 - Pages: 8

Free Essay

Sammy the Insensitive Cashier

...ENG 102 Darren Robbins Sammy the Insensitive Cashier First person narrators have a tendency to tell us their story as they see it, whether it is believable, is for us to decide. That is exactly what happens, when John Updike, chose Sammy, a 19-year-old, cashier at the A & P to narrate the story, “A&P”. As a result, Sammy’s story becomes doubtful, because his behavior towards everyone is a bit erratic. He calls most of the patrons "sheep" or followers, making them impossible to tell apart. Therefore, they become nonessential characters, to represent an era of conformity in America. Since Updike, elected to have a first person narration from Sammy, it allows us to directly, see his hatred for traditionalism and his derogatory views of the people, in his tiny hometown. Thus, due to his lack of restraint on making immature judgments of others, and his urge to act on impulses, one cannot sympathize with Sammy. It becomes clear that Sammy is an unsympathetic narrator, when he uses hasty and most of all uncalled-for observations. As a result, we can conclude, that he judges others solely based on their looks. Apparently, Sammy has never heard the saying; don’t judge a book by its cover. As the story begins, “In walks these three girls in nothing but bathing suits” (539). Sammy standing at the register first sees them when they reach the bread. He first describes “the one in the plaid green two-piece. She was a chunky kid, with a good tan and a sweet...

Words: 1148 - Pages: 5

Free Essay

Cashier and Rude Customers

...McQuay April 11, 2013 English 301-01 Cashier Duties and Rude Customers Duties of a cashier vary from store to store. Cashiers are those who operate registers at retail or grocery stores, to those who occasionally handle money as part of a business. This means duties of a cashier will range, but there are some potential expected responsibilities including ringing up sales, taking returns, issuing receipts, counting out change, and running registers or any other equipment needed to process incoming payments. number of cashier jobs involve ringing up sales. In many grocery and retail stores this could mean using a handheld or counter scanner to scan each item so its price is accurately reflected. Sometimes items aren’t immediately available for scanning, such as food in a fast food restaurant. The duties of the a cashier might then involve hitting buttons that signify the type of food purchased, this is the case in many fast food establishments, or simply putting in the price of the items that are being purchased. In lots of mom and pop retail establishments this method may be used instead of any form of scanning method. People may also need to take returns, which could mean ringing up a sale in a backwards manner so that the cash drawer will open to give out money back. Alternately, returns don’t always result in money back, and the duties of a cashier could include filling out receipts for store credit or making exchanges. Not all cashiers are permitted to do returns, and this...

Words: 377 - Pages: 2

Premium Essay

Cashier Training Need Assessment

...Cashier Training Needs Assessment Food City Beverly Moreno Park University HR421 Corporate Training & Development Taylor, Debbie G. Cashier Training Needs Assessment Food City Food City is a fast and up and coming competitor in the retail grocery business. Established in 2009, the company’s commitment is to provide excellent customer service while providing low cost to the community. Food city wants to offer their employees the support that is needed to encourage growth, skills, knowledge, and higher performance. Food city wants to stand above the competition to obtain our business objectives by providing training support to all employees. It is the observation of the company that cashiers are the ones most likely to be in direct contact with the customers. This opens the door to communicate and perform exceptional customer service. An immediate area of focus is on the front-line implementing the opportunity to increase customer service, carry out correct codes and procedures, listening and understanding information while using appropriate vocabulary, language and tone. Since customers are our number one priority, development of curriculum is in direct response to increasing demand in the operation for training materials that will target specific application of work related skills. Corporate office has asked for input to create a training program designed for continued, up-to-date materials given the company’s business strategy for resources...

Words: 1283 - Pages: 6

Premium Essay

Jobs

...Cashier job description cash is a backbone of any company/firm etc; Cashier coordinates between company and its debtors/creditors, But when you are looking for a job as a cashier so, you are going to take a big responsibility on your shoulders. Handling cash refers to major responsibilities (ex. Cash collection, recording, safeguarding) so as to one should be really careful and mentally strong about this job. A firm/company hires someone for handling its cash although cashier has to be good at mathematical skills, computer skills, quick at billing , sound knowledge of financial software, strong in written and as well as oral communication, ability to work in a fast-paced, can take high stress environment. Cashier Job Description A Cashier Job Description includes the following duties and responsibilities, Skill sets & qualification. Related Read: Accounting Manager Job Description Duties and Responsibilities of a Cashier If one wants to be an avid cashier so he/she has to possess these responsibilities: * Cashier major responsibilities include; cash collection, maintaining records, and safeguarding, depositing of money etc. * Cashier needs to have an excellent knowledge and understanding of the modern office practices, equipment and terminology related to cashiering and reports. * Cashier of company has to be responsible to collect the fees for permit/licenses issued or documents of regarding field. * Another important work for a cashier is to assign the...

Words: 541 - Pages: 3

Premium Essay

Production Analysis Shuzworld

...Memorandum To: Cynthia Crowninsheild From: Date: 2/22/2014 Re: Production Analysis SHUZWORLD A. Distribution Pattern Shuzworld has three plants that ship units to three central warehouses. The company would like to know the lowest transportation cost monthly along with the best shipping plan to achieve the lowest cost. To analyze the cost we are using the transportation modeling tool. The optimal cost is $13,400 which would be the lowest monthly transportation costs which is shown below. Transportation modeling is the best tool to use as it finds the lowest optimal costs when shipping products from several plants to several different destinations. Our model shows three different plants of Shanghai, Shuzworld H, and Shuzworld F with three different warehouses. The individual unit costs to ship from each plant to each warehouse is entered in order to calculate the optimal cost. Also shown below is a shipping list whish details the exact amounts that should be shipped from each plant to each warehouse in order to achieve the optimal costs shown. This would be the best distribution pattern to use in order to achieve the optimal costs. The patterns show any demand constraints and also meets availability while minimizing total shipping costs. Looking at the shipping list chart the increased production from 1300 to 2800 units caused the supply to exceed the demand which is shown in the Dummy row ( dummy destination at no cost) that way the cost figures...

Words: 1088 - Pages: 5

Premium Essay

Advantages and Disadvantages of a Union

...union for a cashier at Wal-Mart. It will present some ways a union could benefit the cashiers and also ways a union could be harmful to them. Unions could protect the cashiers from the abuse of the company. On the other hand, unions could also abuse in their demands hurting all the employees. Finally, this paper will show my viewpoint on the unions as beneficial or not to cashiers at Wal-Mart. Advantages and Disadvantages of a Union The word union evokes strength. However, when people talk about labor unions, the effects can be both positive and negative. Mathis and Jackson (2011) state, “union is a formal association of workers that promotes the interest of its members through collective actions” (p. 540). Cashiers at Wal-Mart have a lot of responsibility. First of all, they work with cash, products, prices, and, the most important, they work directly with customers providing service. They have a key role in the store. The advantage of having a union at Wal-Mart for a cashier would be that the union would negotiate better pay and benefits for them. Some of the benefits for the cashiers are: 1. Cashiers have to deal with different type of customers and sometimes they encounter difficult situations. With these risks and conditions, a union can protect them from those working conditions and request to keep their work. (Not sure what you mean)Union could save them from certain customer’s complaints. 2. A way a union can be of benefit to a cashier is pay...

Words: 683 - Pages: 3

Premium Essay

Ttttttttttttttttttttttttt

...Modeled on Observation and Mystery Shoppers Environment |Cleanness |ˇ 1 mark for no rubbish, ant, insect |口 0 mark for none | | |and mosquito in the store area | | |Orderliness of merchandise display |ˇ 1 mark for all merchandise located in|口 0 mark for none | | |suitable area | | Salespeople |Activeness |口 1 mark for salespeople use a |ˇ0 mark for none | | |friendly greeting to make the customer | | | |feel welcome and important when the | | | |customer enter the store | | | |口 1 mark for salespeople say good bye |ˇ0 mark for none | | |to customers welcome customers for next| | | |time shopping when customers are | | | |leaving. ...

Words: 395 - Pages: 2

Premium Essay

Interview Protocol

...[Cashier] Job Analysis Interview Protocol Thank you for helping us with our human resource management project where we are learning about the tasks completed in a job. You may choose not to answer any of the questions or withdraw at any time. Your decision whether or not to participate will not affect your current or future relations with your company. 1. How did you choose cashier as your profession? 2. How long have you worked at Weis Market as a cashier? 3. Why did you choose Weis Market as your place of employment? 4. What kind of education do you need to become a cashier? 5. What if any professional organizations do you belong to? 6. What continuing education classes does Weis Market offer? 7. What type of orientation do you go through within the Weis Market after you are hired? 8. What type of training do you go through within the department? 9. What types of work do cashiers do? 10. Please describe a typical day as a cashier. a. What tasks do you complete daily? b. What tasks do you complete, but not on a daily basis? 11. What type of equipment do you use? 12. What are the physical demands of your job, if any? 13. Please describe any dress code or specific uniforms you are required to wear. 14. What do you like best about your job? 15. What do you like least about your job? 16. What do you find to be the most demanding aspect of your job? 17. How do you handle the stress associated with your job? 18. How are you evaluated on...

Words: 349 - Pages: 2