The Red Star Case is smart phone and tablet/iPad case manufacturing company that has four factories in different cities. These factories are responsible for leading different phone and tablet cases that the company might undertake (depends on the consumer market demand). A certain factory sites might even be associated with several projects but a specific case project (for example, Samsung Galaxy S10e) is always under the control of just one factory. Employees work in these four manufacturing factories and each employee works in only one factory. A local factory could employ many employees but must have at least 300 employees. Every local factory is managed by an employee who works in the same plant; but every employee is not a factory manager nor can an employee manage more than one site. Each and every local factory must have a manager. Some employees are assigned to work on projects and in some cases might even be assigned to work on several projects simultaneously. For a new phone and tablet/iPad case project to exist, it must have at least one employee assigned to it. Projects (for example iPhone 8 and 8s) might need several employees depending on their size and scope. Some of the employees also supervise other employees but all employees need not be supervised the employees that are supervised, are supervised by just one employee. An employee can be a supervisor of several employees, but no more than 25.

Question 1: Identify entity types and their attributes for the given case. And, indicate the primary key for each entity.

Question 2: Divide story into meaningful chunks and identify relationship(s) among entity types. You would be rewriting the case in sections in small paragraphs.

Question 3: Develop the Presentation Layer ER Diagram for this case. Draw a Chen's notation ER diagram that shows the entity types and relationship types. Use Draw.io web application to develop your Presentation Layer ER Diagram. You can save your solution in JPEG format. When you done, simply select IMPORT AS (not save as ) and the click on JPEG. And, then upload in your Discussion Broad reply.