ER Modeling3. You will prepare an ER diagram describing the schema of a University database.High Achievers University (HAU) would like you to design a database that tracks its adminis-trative operations, and helps them monitor their energy usage across campus. HAU consists ofdepartments, research groups, and employees. For each department, the database should recordthe department name, and the department's unique identifier. Research groups belong to exactlyone department, and the database stores the research group ID, name, and its monthly budget.Each research group has to have at least one employee working in it, and is assigned at mostone room as workspace. For each employee, the University assigns a unique employee ID, andrecords the employee's last name, first name, telephone number, address, salary, gender, dataof birth, and his/her years of service. An employee may work in zero or more research groups.An employee may be a department chair. If so, they can be the chair of exactly one department,and every department has a chair.HAU is concerned about energy usage on campus, and would like to record their energy meter(sensor) readings (e.g., water, electricity, gas consumption) for campus buildings. Each buildinghas a unique identifier, a name, the number of floors, the number of rooms, the number of metersinstalled in that building, and multiple building areas. Building areas include hallway, stairway,entrance, cafeteria, and lobby. Each building has one employee that serves as the buildingadministrator. Since HAU wants to record granular meter readings, the database must also keeptrack of all the rooms across campus. Each room has an identifier and a room number, and islocated in exactly one building. Furthermore, rooms are categorized by type, for example, aconference room, laboratory, tutorial room, office, etc. in order to better understand the activityoccurring in each room. A room is classified by exactly one type. Each room type has anidentifier and the type name.Meters record energy consumption such as water, electricity, and gas usage. Meters can alsoreport air temperature readings. There are different types of meters that record these differenttypes of energy usage. For each meter type, HAU would like to record the type of meter it is(i.e, water, electricity, gas, air temperature), its ID, and the unit of measurement. To help trackenergy costs, a list of energy rates is maintained, each with its own identifier and the cost perunit. For example, electricity usage is measured in kWh (kilowatt hour), and the rate is 0.11per kWh. A meter is installed in exactly one room or one building area, but not every roomnor building area may have a meter installed. For each installed meter, HAU is interested inrecording the meter reading (value), and the timestamp of when the meter reading was taken.

Question

Accepted Answer

ANSWER:
ER Diagram: