Question: Read the case study and answer the questions CASE: Walmart Groceries Walmart Walmart is the world's largest company by revenue, with US$514.405 billion, according to

Read the case study and answer the questions

Read the case study and answer the questions

Read the case study and answer the questionsRead the case study and answer the questions

Read the case study and answer the questions

Read the case study and answer the questions

CASE: Walmart Groceries Walmart Walmart is the world's largest company by revenue, with US$514.405 billion, according to the Fortune Global 500 list in 2019. It is also the largest private employer in the world with 2.2 million employees. It is a publicly traded family-owned business, as the company is controlled by the Walton family. Walmart Groceries (WG) is a division of Walmart that takes care of supplying and providing groceries to the stores. One of the main points of pride for WG is the people it employs. Namely, all WG staff are Walmart employees. Naturally, not all employees are WG staff. Some WG staff are specialized delivery, others are specialized in cooling the produce. Some are in charge of disposing the old/ruined products. All WG staff take periodic training courses to stay current in their areas of expertise. Walmart tracks all vacation taken by each staff-start date, end date, Vacation type (vacations can be regular off time, sick date, lieu time, jury time), and description. Walmart also keeps a history of the employment of all WG staff. The history includes the date hired, date promoted, date terminated, and so on. (Note: The "and so on" component is, of course, not a real-world requirement. Instead, it has been used here to limit the number of attributes you will show in your design.) Walmart uses a high-end DBMS system to store the data about its employees. You are tasked with analyzing data management practices and designing a data model for this system. Q1: The case states that Walmart uses a high-end DBMS to store its corporate data. Define DBMS and explain why a regular spreadsheet software cannot perform all functions that AC might need to perform on its employee data. se states that Walmart uses a high-end DBMS to store its corporate data. Define DE ay a regular spreadsheet software cannot perform all functions that AC might need nits employee data. Q5: Draw a ERD for Walmart's database based on the information you can collect from the case. Use the Chen's notation for your data modeling and show PKs, FK, and the corresponding attributes for each entity. (You should provide no less than 4 entities) To do this you can use the draw.io there is a list of shapes under the Entity Relation group. When you finish your drawing there you can save a copy as an image and include it here

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!