Retailing Data
Team activity Responses
Q.36 (a),
Customer Table
Customer Id | Customer name | Customer phone | Customer Address | Order number | Delivery person |
154 | K jones | Lll720 | 148 | 15 | Michaels |
158 | V banes | Lll103 | 369 | 47 | john |
143 | L jones | Lll142 | 741 | 19 | Paul |
117 | A Kimberly | Lll987 | 259 | 09 | Kennedy |
b)
Pizza Delivery Time Address
Customer Delivery person
- The DBA measures in maintaining customers’ data are faced with the loophole of security and accuracy. The database has no secure password, and any person can assess their customers’ data and information while their storage method does not distinguish the enormous availability of information looking alike. Therefore there is a tendency of administering the wrong drugs to different people since they share similar names, and the database does not distinguish the customers’ details.
- They need to ask themselves how secure is the data protected. How simple is the database to enable quick retrieval of information required by the customers? How is the site protected against enormous malware dysfunction to safeguard the system break down?
Don't use plagiarised sources.Get your custom essay just from $11/page
Case Questions
Q.1The decision of sears to maintain their numerous database into an individual transaction level has both benefits and disadvantages to the company. The benefit of the approach is that data becomes partitioned into facts which provide numeric transaction data and dimension which contain the reference for future analysis and study for the business, making it the dimensional business structures. Data retrieval is effortless since the structures are easy to understand. However, the approach makes it difficult to shift to a specific data storage approach, especially when the business tries to adopt a particular approach.
Q.2 The extensive use of smartphones by customers may become utilized by the retailers through incorporating the websites used in the technology such as twitter and Facebook to collect data and learn about the consumers’ tastes and preferences on a specific commodity. Also, retailers can use numerous websites and applications for advertising their business and products through online advertising using ads in the apps and websites found on phones.
Q.3 availability of historical data and price point modeling can create dynamic price changes in the airline company bringing benefits and challenges to the company as well. The initiative makes it possible for the company to maximize profits with each customer demand by making it possible for the industry to react to the real-time information in the market. The initiative is also able to transform the consumer market by the real-time demand data collected. Consequently, the use of the initiative can cause consumer alienation, which may cause the customers to run away from the company by increasing the prices. It also creates competition resulting in price wars between companies scaring customers away.