The State of New York certifies firefighters throughoutthe s

The State of New York certifies firefighters throughoutthe state and must keep track of all of them,as well as of the state’s fire departments. Eachfire department has a unique department number, aname that also identifies its locale (city, county, etc.),the year it was established, and its main telephonenumber. Each certified firefighter has a unique firefighternumber, a name, year of certification, hometelephone number, and a rank (firefighter, fire lieutenant,fire captain, etc.) The state wants to record thefire department for which each firefighter currentlyworks and each firefighter’s supervisor. Supervisorsare always higher-ranking certified firefighters.Construct a relational database for New York’s firedepartments and firefighters.