1.Consider the software domain grocery store, say, Kroger. All the activities to model include customers buying groceries and store manager ordering groceries from suppliers. Draw an entity-relationship (ER) diagram for this software domain. Then translate this ER diagram into a relational model, which isa collection of database tables. (20 pts) 2.Consider the scenario in a company where an employee works in a department, and a department have many employees. models. Each relational model is a collecition of tables. Now you have two sets of tables, and both sets will work. Discuss advantages and disavantages of using each set (model). (15 pts) Draw an ER diagram for it, and translate this ER diagram into two relational 1.Consider the software domain grocery store, say, Kroger. All the activities to model include customers buying groceries and store manager ordering groceries from suppliers. Draw an entity-relationship (ER) diagram for this software domain. Then translate this ER diagram into a relational model, which isa collection of database tables. (20 pts) 2.Consider the scenario in a company where an employee works in a department, and a department have many employees. models. Each relational model is a collecition of tables. Now you have two sets of tables, and both sets will work. Discuss advantages and disavantages of using each set (model). (15 pts) Draw an ER diagram for it, and translate this ER diagram into two relational