For the following description of a database to support physical plant operations, identify functional dependencies and construct normalized tables in BCNF. You are to assist physical plant personnel in managing key cards for access to buildings and rooms. The primary purpose of the database is to ensure proper accounting for all key cards:

a. A building has a unique building number, a unique name, and a location within the campus.

b. A room has a unique room number, a size (physical dimensions), a capacity, a number of entrances, and a description of equipment in the room.

c. Each room is located in exactly one building. The room number includes a building identification and followed by an integer number. For example, room GW123 identifies room 123 in the George Warren (GW) building.

d. An employee has a unique employee number, a name, a position, a unique e-mail address, a phone, and an optional room number in which the employee works.

e. Magnetically encoded key cards are designed to open one or more rooms. A key card has a unique card number, a date encoded, a list of room numbers that the key card opens, and the number of employee authorizing the key card. A room may have one or more key cards that open it. A key type must be authorized before it is created