Reference no: EM13221864
Consider a real-world organization such as Walmart orKroger. (You should feel free to engage in additional research to gather relevant information to supplement this case description.)
The organization generally operatesmultiple linesof business. (For instance,Walmart has different lines of stores including Supercenter, Neighborhood Market,Express, DiscountStore, and Sams Club.)Each line of business has many retailstores in differentregions of the United States. Each store has several employees in different roles such as associate, supervisor, and manager. Each employee is assignedto a specific department within the store, which generally changes every other week or so. Each line of businessmay have different departments such as grocery,home goods, toys, electronics, and pharmacy within its stores.The departments may differ between the lines of business. Each department carries differentlines of productssuch as apparel, snacks, phones, cookware, and jewelry.The lines of productsmay be sold by different units of measure such as pieces or pounds.The products may be subjectdifferent levelsof sales tax includingno sales tax. The sales taxes are imposedby the local governments in the regions in which the stores are operated. The storescater to individual consumers as well as corporate customers. The organization necessarily maintains information about corporate customers since they may be billed periodically or later for their purchases. Information about individual consumers may or may not be gathered depending on whetherthey opt to sign up for loyalty programs. Customersmay complete many salestransactions at any of the storesand each sales transaction may containany number of items. The organization periodically replenishes the inventory at its many stores from the inventory it holds in its many warehouses. The decision to replenish is based on predefined reorder levels.The organization manages many trucks to ship the replenishment inventory to its many stores.The trucks are generally affiliated with specific warehouses and take specificroutes and cater to specific stores. When inventory at the warehouses run low, the organization generates purchase orders to different suppliers. Each purchase order may be used to order multiple types of products.Each supplier generally supplies a predefined set of productsfor the organization, which are sent to the warehouses that generatedthe purchase orders.
Answer the following questionsbased on the case description above as well as any additional information you may have gathered.Be sure to state your assumptions. Provide justification for any solutionchoices and includeany necessary description of your solution stepsand your final solution. (In other words, an E-R diagramalone is not sufficient for the deliverable; you should demonstrate your knowledgeof data modeling.)
1) Identify the entities.Be sure to considerstrong and weak entitiesas well as supertypes and subtypes.
2) Identify the attributes for each entity.Be sure to consider multivalued and derived attributes. Be sure to identify primary and foreign keys.
3) Identify the relationships between entities, including multiplicity constraints. Be sure to consider binary,ternary, and recursive relationships.
4) Develop a single E-R model that combinesall entities, attributes, and relationships you identified in your responses above.Be sure to developthe E-R diagram in Visio.
Describe the advantages and limitations of your E-R model.Reflect on the extent to which your E-R model is consistent with businessrequirements.