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