Experience Level: Intermediate
I need a MySQL database buuilt. It needs four tables. Customers, Dealers, Status and Account Executive. The Status table needs to be linked to teh customer, the customer table needs to be linked to the dealer table and the dealer table needs to be linked to the Account Executive table. There will be only 6 status; Approved, Declined, Conditioned, Processing, Booked, and Funded. The database needs the ability to have multiple user logins, but only the admin login needs to be able to add dealers and Account Executives. The database needs to have the ability to upload multiple new customers from a .csv file (see example .csv file attached) and it needs to have the ability to bulk update customer status' sorted by dealer. Finally, I need the database to automatically generate a staus report update for each dealer and email the status update report to the designated email at 12 AM eastern Standard Time. as also do the same for Account Executives, the only difference is that the Account Executive Report include all customers for each of their assigned dealers, Any questions please feel free to ask
David P.100% (86)
31 Jul 2021
Login to your account and send a proposal now to get this project.Log in
Clarification Board Ask a Question
There are no clarification messages.