Be sure to normalize the data tables for both databases to 3NF Leslie’s Auto Sales has a relational database withwhich it maintains data on its salespersons, itscustomers, and the automobiles it sells. Each of thesethree entity types has a unique attribute identifier.The attributes that it stores are as follows:• SalespersonNumber (unique), SalespersonName,Salesperson Telephone, Years with Company• Customer Number (unique), Customer Name,Customer Address, Value of Last Purchase FromUs• Vehicle Identification Number (unique), Manufacturer,Model, Year, Sticker Price Leslie’s alsowants to keep track of which salesperson soldwhich car to which customer, including the dateof the sale and the negotiated price. Construct arelational database for Leslie’s Auto Sales. 2. 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.