DBS201 Assignment 2 Due Friday‚ April 04th by midnight 10% of final mark Your group must consist of 2 or 3 people You will develop a logical database design for the following description shown later (Page 3 etc). Submissions done by a single person will receive a 20% penalty. Required for submission: One: (60 marks) Printed 3NF solution for each user view in this assignment
Premium Database normalization Relational model
BENTONVILLE‚ Ark. — In corporate America‚ there is nothing like Wal-Mart. In just 40 years‚ it has become the nation’s biggest company and the world’s largest retailer. In the United States alone‚ it owns 3‚300 stores and employs more than one million workers. And not one of them is a union member. In fact‚ unions have made only one successful effort at organizing at a Wal-Mart in the United States — in a butcher’s department in a Texas store. Two weeks later the company disbanded that department
Premium Trade union Employment
used for relatively inexpensive goods Perpetual Inventory * keeps a running computerized record of inventory S5.2 Analyzing purchase transactions – perpetual inventory Suppose Kmart buys $185‚800 worth of MegoBlock toys on credit terms of 2/10‚n/30. Some of all the goods are damaged in shipment‚ so Kmart returns $18530 of the goods to MegoBlock. All amounts are inclusive of GST. a. after the discount period cost = 185800 returns = 18530 owing = 167270 Outside Discount
Premium Revenue Cost of goods sold Generally Accepted Accounting Principles
MediaOne for $112 billion * Integration difficulties were insurmountable * Sold to Comcast for 72 billion * In a little over 10 years‚ AT&T had wasted $50 billion and destroyed even more in shareholder value * ** no idea how to merge and transition companies after acquisition CASE: CABOT CORP * Gives tires its black color through carbon * Core market hadn’t grown rapidly * Launches several aggressive growth initiatives in advanced materials by acquiring specialty
Premium Marketing Product management New product development
Growth “Though stubbornly high unemployment and continued uncertainty over the prospects for job growth will continue to dampen the outlook for industry retail sales growth in 2012‚ the retail industry will still grow at a rate faster than many other industries. This year‚ retail industry sales will rise 3.4 percent to $2.53 trillion*‚ according to the National Retail Federation – slightly lower than the pace of 2011‚ in which sales grew 4.7 percent. Many economists estimate that real U.S. GDP will
Premium Retailing Department store
industry to gain a better understanding and develop a more effective business strategy. In the discount retailing industry‚ it is important to consider the following when considering entry: Threat of New Entrants: Four major competitors‚ WalMart‚ Kmart‚ Target and Costco Wholesale dominate the discount retail industry. The threat of new entrants is low‚ as this small number of large firms has spent decades establishing their position in the market. While online retailers‚ such as Amazon.com‚ and
Premium
Speech Analytics. Speech analytics allow companies to get inside the mind of the customer to better strategize for the future (Briggs‚ 2016). Sears used a software called Hadoop‚ which allowed them to get closer to their customers. Hadoop allows Sears to create marketing campaigns for customers at a much faster rate than ever before. This is because Sears can now use 100% of the data that is collected while also being able to store their data indefinitely. Google used their own special analytic platform
Premium Data Management Business
without the effect of an industry downturn. The company has become a massive range of diversified companies.The company now has 9 divisions‚ which include coal and energy‚ home improvement and office supplies‚ industrial and safety‚ insurance‚ Coles‚ Kmart‚ and Target. Wesfarmers has moved dramatically‚ to diversify through an aggressive acquisition strategy since becoming a prominent company. However‚ there are some challenges for Wesfarmers due to its sizable investment‚ sustainable development and
Premium Exchange rate Strategic management Foreign exchange market
Case Study: OfficeMax 1. Introduction This assignment focuses on case study analysis‚ where we were expected to analyse and provide executable strategy for a specific corporate retailer. The 1997 case relates to OfficeMax‚ a superstore that primarily carries office equipment and supplies to small business and consumer markets. However‚ the company is seeking diversification and market share growth‚ with the prospect of a merger between the industry’s number 1 and 2 office supply
Premium Strategic management
“everyday low prices”. This is attractive to all consumers because it is the lowest price but yet‚ comparable to some of its competitors. Wal-Mart has guaranteed that it is the lowest price because weekly it checks out its competitors as well such as Kmart and Target. This is one of the biggest factors when it comes to Wal-Mart because people shop when it is not only super cheap‚ but super convenient as well. Being able to have a department store with everything you could need while later on adding a
Premium Wal-Mart Target Corporation Hypermarket