Reference no: EM133218132

Map the following ER model to a relational DBMS schema. Only show the relational schemes for the tables (not the create table statements). In mapping the inheritance, apply alternative 1 from lecture notes (i.e., create a table for each entity type). Underline all Pkeys. B: Write ONE SQL statement that prints the name of all employees and their department numbers for all salaried employees who satisfy all of the following conditions: 1. Work on 2 projects, 2. Do not make $30000, 3. Their department manager and supervisor have the same name (Note: since name is not the pkey of employee tables, this requirement does not mean these two individuals are the same person). Note that supervisor is not the manager of the department.