...STRATEGY PLAN FOR DATABASE SYSTEMS DATABASE ADMINISTRATOR FOR DEPARTMENT STORE (TECHICAL PAPER) ANDREW L. PASSIE STUDENT Dr. HOSSEIN BESHARATIAN PROFESSOR CIS 515 STRAYER UNIVERSITY September 6, 2013 SUMMER Page 1 STRATEGY PLAN FOR DATABASE SYSTEMS ABSTRACT We are also going to discuss a Technical paper on Database Administrator for Department Store. We should know that a Database Administrator is the person who is responsible for planning, organizing, controlling, and monitoring the centralized and shared corporate database. The DBA is the general manager of the database administration department. We are also going to discuss the potential sales of the department store transaction within a database, evaluation of all relationships of the database solution using the Crow Foot notation, justifying that Big Data tools could be used for forecasting sales and inventory of the department store, the SQL functions to help sales predictions, implementing cloud-hosted solution for a database in the cost involved and pricing structure required, ranking...
Words: 4277 - Pages: 18
...Database Design and how it is used at Wal-Mart Benjamin Stites DBM/380 7/2/2012 University of Phoenix. What is a Database System? A database system consists of four components which are the users, the database application, the database management system, and the database itself. We will describe all four components briefly. Database: The database allows a business to store important data using a collection of related tables and other structures. Database Management System: A database management system is a computer program that is used to create, process, and administer the database. (Kroenke & Auer, 2010) Database Application: A database application is a set of one or more computer programs that serves as an intermediary between the user and the database. They read and or modify database data by sending SQL statements to the database. User: The user is the fourth component of the database system. The user employs database applications to keep track of things. They use forms to read, enter, and query data, and they also produce reports. These four components allow the database system to work properly. How does Wal-Mart use its Database System? Wal-Mart is the largest retail company in the world. It needs to keep track of employee data, sales data, inventory data, profit data, and many other types of data throughout each of its stores. In order to keep up with this information Wal-Mart has outsourced its database to NCR. This allows Wal-Mart...
Words: 616 - Pages: 3
...Swagger Distribution Microsoft Office and Visio Human computer interaction (HCI) is a study of human interactions with computer applications. The importance of HCI is that developers can design software that can be easy to use, learn, and promote the user experience. Usability is key to developers because building a software that can be used will be essential to the software success. Microsoft Word and Visio have many difference but what makes them similar is the interface for users. Microsoft pride itself on having a “fluent user experience” meaning they use similar User-Interfaces (UI) across their different platforms. Swagger employees are familiar with Microsoft Word software. The menus and ribbons are relatively similar in layout with few differences catering to the task that each software is used for. Employees that opens up Microsoft Visio will notice that the menu options and tabs listed are organized with File, Home, Insert, Design, etc. as in Microsoft Word. These will cut down time on learning, adapting, and switching between the two applications. There are differences are noteworthy to the users to understand. The importance of Microsoft Word is the ability to create documents. Microsoft Word is a word processor being able to cater to document needs of Swagger. Users can create visual graphics and charts in Microsoft Word, but the features are limited. The charts and graphics cannot be scaled and final product will be saved as a document. In Microsoft Visio, employees...
Words: 854 - Pages: 4
...Introduction a. Retail Market b. Retail in India c. Organized Retail in India d. Role of Information Technology in Retail 2. Key System Applications in the Organization a. Types of Information Systems in Retail Outlets 3. Requirement Analysis a. Operational Requirements b. Tactical Information Requirements 4. Software Requirement Specification a. Operating Systems b. Retail Man 2007 c. Languages 5. Hardware Requirements a. Three Tier Approach 6. Logical Design 7. Implementation 8. Security In Retail 9. Innovation 10. Conclusion 11. References INTRODUCTION RETAIL MARKET: A retailer can be defined as a collective term for any merchant who buys goods from a variety of wholesalers or consumers. Retailers complete the final link of the fashion/grocery chain. In the retail industry, success is dependent on the ability to withstand demand volatility and its financial risk. Flexibility, forecasting, partnership and efforts to maximize the profitability of whole supply chain include the remedy for risks. RETAIL IN INDIA: India has witnessed a tremendous growth in this sector. India’s attempt to foray in the retail industry the international way has met with some success. A tremendous opportunity exists in the Indian market and organized retail will prevail as...
Words: 4200 - Pages: 17
...Introduction Canada Post Corp. (CPC), a Canadian Crown enterprise, is Canada’s national postal service provider. It has be a world leader in providing innovative physical and electronic delivery solutions, creating value for their customers, employees and all Canadians. It not only 66000 employees, it is also the country’s fourth largest employer. It serves 30 million residential customers and more than 1 million commercial customers, delivers more than 10 billion pieces of mail annually, and maintains good relations with more than 24000 retail sales points for CPC products and services. Building and maintaining trusted relationships with employees, customers, suppliers and our shareholder is the fundamental for their business, reputation and their success. Canada Post Corp. managing in an ethical way, guided by a sense of social responsibility. Core customer issues: * With customer expectations rising and the ongoing emergence of the Internet. * Customers’ experience with CPC were often complicated and frustrating. A customer could call three or four times about the same issue and receive different responses from call center agents. * The former systems were standalone and didn’t integrate customer and call information. 1. Why is the process redesign so important for CPC’s success? CPC recognized that its future depends on having customer processes and support systems. It’s customer expectations rising and the ongoing emergence of Internet. To demonstrate...
Words: 1700 - Pages: 7
...Chapter 3 Information Systems, Organizations, and Strategy 101 I N T E R A C T I V E S E S S I O N : T E C H N O LO GY 7-ELEVEN STORES ASK THE CUSTOMER BY ASKING THE DATA There is probably a 7-Eleven store in your neighborhood, and it’s a convenient place for picking up a can of Coke or a quick ham-and-cheese sandwich. It’s the largest convenience retailer in the world and the number one convenience store chain in the United States, with 5,300 stores. This company started out about 75 years ago as an ice-dock operator. When refrigerators started replacing iceboxes, the manager of each store asked customers one-by-one what items they’d like to stock in their new appliances. By asking customers directly and stocking only the items customers most wanted, the company grew and prospered. Over time, the company moved away from its roots, losing touch with customers along the way. It had no means of knowing what sold in each store and allowed vendors to decide what to stock on its shelves. Although large vendors, such as Coca-Cola and Frito-Lay, had powerful information systems for analyzing what they sold in individual stores, other vendors didn’t have such systems. Moreover, the vendors’ systems were designed to maximize opportunities for their businesses, not for 7-Eleven. 7-Eleven stores are not all alike. What their customers want depends a great deal on the neighborhood and region of the country where they are located. What sells well in Boston may not work in Texas. Without...
Words: 3223 - Pages: 13
...customers know they are valuable to the store and persuade them to shop with greater frequency. The customer-buying model will help Kudler improve its practices and assistance to please their appreciated customers. Cost is not a main concern for Kudler customers; these customers are interested in high quality and specialized goods. Therefore, Kudler has requested a Frequent Shopper Program System with a “loyalty points program to provide customers with points that they redeem for high-end gift items, airline first-class upgrades, or other specialty foods” (ecampus.phoenix.edu, 2011). The Frequent Shopper Program System for Kudler Fine Foods will track purchase behavior of individual customers and provide high value incentives by installing a customer loyalty points program. “Point of Sale Software” (camcommerce.com, n.d.) “Retail STAR Point of Sale (POS) software provides a solution for customer tracking, managing inventory, and selling inventory via sales orders or point-of-sale transactions” (camcommerce.com, n.d.). The software program has a CRM (Customer Relationship Management) module built into Retail STAR. Retail STAR Point of Sale Software can computerize all of Kudler’s sales data and provide executive management with a balance sheet and profit and loss statement at the end of each sale day. Retail STAR will track all the vital information needed to generate marketing campaigns to have Kudler Fine Foods customers return to the stores. “The CRM module can drive increased...
Words: 908 - Pages: 4
...Assignment Cover Sheet Unit Name : Charles Darwin UN ~ VEII!. I ' Y A' ~H ta'!a I Unit Code: CMA304 Computer Based Accounti ng Systems Lectu rers Name: School of Law and Business Charles Darwin University Casuarina NT 0909 Phone: (08) 8946 6830 Kevin J CLARK Asses sment T itl e DE Ll ve ~ f1L-E IttI Lodgement Date (dd/mm/yyyy) I Applied for Extension Semester : Assign ment Two - (Systems AnalysisTerm Project) Due Date (dd/mm/yyyy) Two I ;~~2 (dd/mm/yyyy) 2110912012 2110912012 N/A NO YES-to Lodgement Locations : (refer to specific lodgement requirements as set out by the lecturer) The assignment must be lodged onli ne via the Learnline Assignment Lodgement link on the Learnline site for this unit. Ensure your file is named using a file naming convention that allows the lecturer to identify to whom it belongs. Failure to use an acceptable file naming convention may result in your assignment lodgement being rejected. Refer to the endnotes of the aSSign ment detail s for lodgement options if the Learnline Assignment Lodgement link for this unit is unavailable. o 0 0 . . DO NOT LODGE BY FAX nor EMAIL nor at LECTURER'S OFFICE KEEP A COpy Ensure you have a copy of the assignment lodged. If you have submitted assessment work electronically please make sure you have a backup copy. DECLARATION BY STUDENTS I certify that this assignment is my own work, based on my own personal study and research, and that I have acknowledged...
Words: 8082 - Pages: 33
...Bazaar Introduction Retail industry in India currently is at an all-time high. Over the last one decade, it has seen a steady growth in the market. From having a market size of $238 billion in 2004, it reached $518 billion in 2012 [IBEF, 2014]. With over 1.2 billion people in India, it has become one of the fast growing countries for retail markets to flourish in. Retailing has become one of the strong pillars of our economy as it accounts for 22 percent of India’s GDP and contributes to about 8 percent of total employment in our nation [FICCI]. Organized retail industry in India is bound to grow by leaps and bounds. This growth is driven by rapid changes in the sector, especially due to advanced technological improvements, consumers’ purchasing pattern and a market that supports healthy competition. What is MIS? Management Information Systems (MIS) is a system that utilizes the information that it gathered from both Internal and External sources of an organization. It then processes this data and supplies the information to the Management who assist them in decision making. These decisions could vary from replenishing the inventory to improving a particular product. MIS highlights the relationship between people, process, technology, and the organization. MIS plays a crucial role in the growth and development of retail industry. It assists by providing real-time and accurate information that is integrated across several databases and systems. The ulterior...
Words: 1068 - Pages: 5
...An evaluation of Apple Inc’s use of information systems through its website http://www.apple.com/ Introduction In the highly competitive world of business the ability to understand and make use of information systems can provide substantial benefits to an organization. The diversification of consumer taste and competition has put pressure on organizations to focus on customer involvement and business information systems have proven to be a versatile and useful tool in order to achieve this. Strategic information systems have the potential to allow an organization to gain a competitive advantage by accessing new markets and providing a more efficient and faster form of communication between managers. By improving communication within the organization, strategic information systems have the potential to reduce the cost of advertising, delivery, design and manufacturing. The purpose of this essay is to evaluate the use of information systems in consideration of Apple Incorporated’s website. About Apple Inc. Founded by Steve Jobs and Steve Wozniak, the company was incorporated on January 3, 1977, under the company name Apple Computers. Initially the multinational company predominantly dealt as a manufacturer of personal computers, however in 2001 following the successful release of the iPod, the company established itself as a credible competitor within the consumer electronics industry. By 2010 Apple Inc had surpassed Microsoft in terms of market capitalization to become...
Words: 2396 - Pages: 10
...gear, sporting goods, and clothes in 122 retail stores in 29 states, Recreational Equipment Inc. (REI) opens four to six new stores each year. REI's sales exceeded 1.8 billion in 2011. With four to six new stores opening each year and wireless technologies becoming the standard in the business industry, the team at REI is ready to move forward and maintain its position as one of the industry leaders in outdoor enthusiast gear sales. Proposal: As technology has progressed REI has fallen behind. Large retail companies have followed the wireless technology trend to stay ahead of the curve. REI’s goal is to increase sales, improve inventory management, and customer service through an increased use of technology. Studies have shown that if needs are not met quickly, one in ten customers will abandon a line while waiting. This might cause the customer to leave the store, making them less likely to return in the future. Mobile point of sales (POS) systems can be integrated, using handheld computers, scanners, and printers with integrated credit card readers. During the holidays and high volume periods, sales personnel can be strategically placed throughout the store with these mobile devices. The whole transaction can be completed for customers paying by credit card with receipt printed or emailed, all with never having to stand in a line. A major expense for retailers like REI is management of inventory in the warehouse and on the retail floor. Inventory must be tracked when it...
Words: 650 - Pages: 3
...to a customer, and payment of these products is received. Although the point of sale system is vary in different situation, but the final outcome of the system remain the same. (Malcolm Tatum, 2010) Point of sale (POS) is a type of software that a store uses to calculate their sales record and operate the cash drawer; it’s a computerized cash drawer. POS system calculates the prices of products and also calculates the change. Whenever any sale process is being done the POS system updates the inventory database. At minimum, POS should be able to handle sales and manage your inventory database. (Jane Harmon, 2010) Point of sales system usually found in supermarkets. The point of sale system contains a checkout counter, bar code generator and scanner, and a cash drawer. Each time whenever any product is scanned the system counts the product price, till all the items are scanned that are selected by the customer, after that system calculate the total cost of all the products that the customer would like to purchase. When customer pays cashier put the amount of money into the system. System calculates the balance that should be returned to the customer. When the payment is done, point of sale system will generate the a receipt and store the transaction history. Features of Point of Sales System There were many features in Point of Sales System. The proposed system will highlight the existing and important features. One of them is easy to learn, by using a user friendly and easy...
Words: 888 - Pages: 4
...INTRODUCTION In this age of rapidly changing business environment, many organisations and business houses faces a constant pressure to continuously adapt and redefine their business process. One of the key processes in doing business whether big or small ranging from small grocery store to a big retail chain is the supply chain process. With the increase in exposure of the companies to the global environment, liberal trade policies, business partnerships and virtual proximity between any two locations of the world, supply chain management has become one of the buzz words in this global business environment. Supply chain management is a collaborative effort of multiple channel members to design, implement and manage seamless value added processes to meet the real needs of the end customers (Fawcett & Magnan, 2002). Thus we can see that a supply chain process involves multiple stages starting from suppliers and ending to end users or customers. The entities which are involved in a normal supply chain are suppliers, manufacturers, warehouses, distributors, transporters, retailers and customers. NEED OF RFID One of the key challenges many organisations face is managing the interconnectivity and collaboration between different entities of the supply chain. Seamless flow of information, tighter integration and communication between channel partners plays an important role in increasing the efficiency of any supply chain and in turn the profitability and rate of return for any business...
Words: 1825 - Pages: 8
...would have to be made soon to be ready for the spring selling season. This case provides an opportunity for students to deal with the variety of strategic and tactical issues faced by small retailers that continue to compete with the big box chains. Local and regional retailers’ marketing and media budgets are dwarfed by monies spent by Lowe’s, Home Depot, and Wal-Mart, the three top retailers of plants and garden supplies. To compete requires strong relationships with current customers and a commitment to ongoing innovation to keep existing customers and obtain new ones. Retail sales of garden products are forecasted to grow to $40.8 billion by 2009. Steady growth is expected from 2005 through 2009, with overall annual sales increasing around 5 percent a year. Seeds and plants are expected to remain the largest sector, reaching sales of $12.9 billion by 2009.[1] All garden supply stores accounted for 21 percent of sales in 2004, down from 23 percent in 2003.[2] This...
Words: 756 - Pages: 4
...Wal Mart A Proposal on How Wal-Mart Can Reduce High Employee Turnover Tiffanie Jenkins GM 591 Wal-Mart Stores, Inc. branded as Wal-Mart since 2008 and Wal-Mart before then, is an American public multinational corporation that runs chains of large discount department stores and warehouse stores. The company is the world's 18th largest public corporation, according to the Forbes Global 2000 list, and the largest public corporation when ranked by revenue. It is also the biggest private employer in the world with over 2 million employees. The company was founded by Sam Walton in 1962, incorporated on October 31, 1969, and publicly traded on the New York Stock Exchange in 1972. It is headquartered in Bentonville, Arkansas. Wal-Mart is also the largest grocery retailer in the United States. In 2009, it generated 51% of its US$258 billion sales in the U.S. from grocery business. It also owns and operates the Sam's Club retail warehouses in North America. Wal-Mart has 8,500 stores in 15 countries, under 55 different names. The company operates under its own name in the United States, including the 50 states and Puerto Rico. Walton was extremely successful in running the store in Newport, far exceeding expectations. However, when the lease came up for renewal, Walton could neither come to agreement on the existing store's lease renewal nor find a new location in Newport. Instead, he opened a new Ben Franklin franchise in Bentonville, Arkansas, but called it "Walton's Five...
Words: 6103 - Pages: 25
