Assessment Case Section 1

You work as a software developer for a life insurance company. The company has been using Microsoft Access to keep track of all the information relating to their customers. They want to have their own custom application for managing customer data. To accomplish this goal, you have been assigned to create a MySQL database and write the code that will manipulate the customer data in the database. You are required to use Prepared Statements in your implementation.

Deliverables:

• A MySQL database schema that will track customers and their information such as name, email, phone, address, etc.
• A working solution to add customers to the database
• Working solutions to manipulate the customer data
• Diagrams and other items as needed