Instructions: Create an EERD model for each scenario using M…
Instructions: Create an EERD model for each scenario using MySQL Workbench. Identify tables, primary keys, foreign keys, relationships, and cardinality (crows feet). Submit a screenshot showing the entire EERD with the connections A company database needs to store information about employees (identified by id number, with salary and phone as attributes), departments (identified by dno, with dname and budget as attributes), and children of employees (with chno, chname and chage as attributes). An employee works in a department; a child must be identified uniquely by chno (a parent is an employee; assume that only one parent works for the company). We are not interested in information about a child once the parent leaves the company.
Read DetailsQ7: (12.5 points) Our classmate, Sarah Woodburn, loves to co…
Q7: (12.5 points) Our classmate, Sarah Woodburn, loves to cook in her spare time (when she is not golfing or traveling). A friend recently sent her an article from the Wall Street Journal describing how food producers now increasingly offer chicken, beef and pork raised without antibiotics. This is done in response to consumer concerns about resistant bacteria. Sarah is very interested in such antibiotics free alternatives and believe that if positioned correctly will do very well in markets around the World. We discussed two positioning strategies in class. What strategy do you think should be used to position this new brand of chicken specifically? In your answer it should be clear that you 1) understand what positioning is overall and why we rely on it and 2) what is driving the effectiveness of your chosen positioning strategy (how/why does it work?).
Read DetailsQ5: (12.5 points) Recently married (and soon to be father),…
Q5: (12.5 points) Recently married (and soon to be father), Bryan Anderson works for a small startup named Ford Motor Company :-). Having learned about this in his MKTG 510 class, Bryan is interested in Customer Relationship Management and was happy to know that Ford does a very good job of this. Given this, he has decided that this is something he needs to to get a better grasp of to better understand the company he works for. 1) Please help Bryan by explaining what Customer Relationship Management is as well as 2) outlining its key functions.
Read Details