A$.$ ERD $/$ Database Design $(50$ points$)($NO Answers go on this page$)$ Design a database for the following scenario. You should have $3$ files saved to your Dropbox folder named "final.mwb$",$ "final.png$"$ and "final.sq$!".$ Insert the data as provided. Make sure the sql file contains the insert statements for the data you have entered. Car Dealership A customer comes into the dealership to purchase a new or used vehicle. A salesperson may sell many vehicles, but each vehicle is sold by only one salesperson. A customer may buy many vehicles over the years, and a vehicle can be co$-$owned. The purchase of the vehicle includes the vehicle, the salesperson and the customer. At the time of sale, the salesperson may take a trade$-$in of another vehicle. The salesperson may also sell one of three different Warranties $($Platinum$,$ Gold, Silver, Bronze$).$ The customer can pay cash or finance the vehicle. Enter the following sample data as "inserts" in the ERD: Customer: Jill Jones, $100$ Amber Street, Some City, TX $79000$ Date: $12/12/20$ Purchase new car: $2023$ Ford Expedition, $$43,000,$ TTL $($Tax$,$ Title, License$)$ $$500,$ Sold by: Jane Smith Warranty purchased: Platinum Down payment: $$10,000$ Finance with Ford Finance, $4\mathrm{.}3\%$ interest, $60$ months, $$600/$ month Make sure to finalize all the participation $($mandatory$/$optional$)$ and required fields as you feel they should be set. draw the database.