Blog

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.

Q2 (12.5 points) It was recently announced that Justin Biebe…

Q2 (12.5 points) It was recently announced that Justin Bieber is financially backing a new app that allows consumers to take pictures of themselves (selfies) and post them on the company’s internal social media website or through Twitter/X (Instagram/Threads addition is planned also). Although the tech community is responding with “wait, can’t we already do that?” our classmate, and cybersecurity expert, Jim Hotaling — a true Belieber — realized that he might be able to help Justin achieve success with his app as it is all about proper segmentation.  To help Jim and his friend Justin, take us through the three steps of the segmentation process (i.e. only segmentation, not STP), explain what happens at each step, and – if possible – use his new app to give hypothetical examples of what could be the outcome at each stage.1

Q1 (12.5 points): Many of you don’t know this, but our class…

Q1 (12.5 points): Many of you don’t know this, but our classmate, Raymond Melder, when he is not busy looking up new workout or diet regimens on ChatGPT, is a huge Swifty and loves to listen to Taylor Swift. He often thinks about out class material in the context of Taylor Swift. Taylor Swift has been called a clever marketer and sells not just a lot of albums and Spotify downloads but also a lot of merchandise. Specific to her merchandise, some people have expressed concern that it is too expensive while others are more positive. Using Taylor Swift merchandise as the context, 1) please explain what we mean when we talk about creating customer value.  2) Why is it important for successful marketing? If you do not know anything about Taylor Swift, feel free to answer the question using a different context.