Chapter 2 Exercise 19

19. Corner Med needs more information about insurance companies. Each company requires claims to be submitted to a specific location. Today, much of the data can be submitted electronically, so there will be an electronic address as well as a physical address. There will also be an account number and password, as well as a phone number and contact person. Add these elements to the class diagram.

Possible tables:
InsuranceCompany(CompanyID, Name, Phone, ClaimsEMail, AccountNumber, Password)
Contacts(PersonID, CompanyID, LastName, FirstName, Phone, Address, City, State,ZIP)
Be sure to encrypt the password.