Exercise 3. 2 - In Class Exercise The ZEE Mart Data worksheet. Zee Mart has 10 stores across 5 regions . Each store has Employees assigned , and each employee has a specific job description . The ECEMart Data worksheet shows the current data . The data sheet shows for each employee their region , Store , name and job description . The business rules and tasks follow . Business Rules A Region can have many Stores but a Store is in only one Region . " Region can have no Stores , such as a new Region before & new store is built . A Store can have many Employees but an Employee can work in only one Store . " Store can have no Employees , such as when a new store is being built . A Job can be assigned to many Employees , but an Employee has only one job . A Job Description can be assigned to no Employee , such as the case when the job is newly created and has not yet been assigned to an employee . Tasks - View the ZOE Mart Data worksheet Using the software package ERDPLUS Identify the various entities . Assign relevant attributes to each entity from those shown in the worksheet Assign a unique attribute ( PK ) to each entity . Assign other attributes to each entity, that might be considered important . Lise both composite* and atomic attributes , but for the composite don't break down into atomic . Don't go overboard , just enough to show you're thinking of some necessary data we would need Determine the relationshipis ; among Entities ( parents and children; ; 1 :1 , 1: 141, MIN Add the FK attribute to each child entity using their parent entity's PK attribute* Determine the participation between related entities; mandatory' Versus optional Draw the complete ERD Of entities and attributes reflecting primary and foreign keys , as well as participation cardinality . Name the ERD FEEMart : ERD .D47 X fx Region Manager E C D H REGION STORE JOB LAST NAME FIRST NAME Region Manager Moore Alan Store Manage Mckee Robert Access Junction Assistant Manager Renselact Cary Secretary Johnissor Elizabeth North ASSOCINIE Krell Betty Region Manager Moon Alan Store Manager Wilson Mary Central Heights Assistant Manager Carson Lyle Secretary Belens Floyd Associate London Heather Region Manager Park Wind Store Manager Anderson Grayson Hot Springs Assistant Manager Liame Tilman Secretary Gamphey John ASSOCIATE Lromon David Region Manager Parks Winfield Store Manage Ratalz Banc South Dalton Comer Assistant Manage andsman Jack Secretary Washington Alan AssocInIE Whitworth Ken Region Manager Wakefield Soott Store Managg Johnsonville Becky Dublin Center Assistant Mamaer Harris Mist Secretary Dacon Gireg ASSOCINIC Dupree Sharma Region Manager Wakefield Soolt Store Manager Smith Robert East Wallace Center Ogallo Roberto Secretary Brod Tom Smith Peter Region Manager Gireenboro Lotti Store Manage Rose Pemm Alley Smith Shemy Secretary Grimaldo Jeanine West ASSOCIMIC Rosenberg Andrew Region Manager ireenborg Store Manage Mac Glenn Oaks Assistant Manage Davis Lado Secretary Heeley Lexa Associal Marks Constance Region Manager Kumperstro Jennie Store Manager Olenko How and Key Point Assistant Manager Archnald Barry Secretary Walking Lester Central ASSOCINIG Pregal Lyle Region Manager Rumperstro Store Manager Greg Patton Southem Links Assistant Manager Dyson Kari Secretary Carter Sumn ASSOCINIC Stacy Kim