In MySQL

1. Design 3 database tables that represent a person with and addresses and phone numbers. a. The three tables need to be related such that a person can have one or more addresses and a person can have one or more phone numbers. b. The person entity must have first name, last name, age, gender, and a unique ID as a primary key. c. The address entity must have street address, city, state, zip code, country, a primary address flag the person foreign key, and a unique ID as a primary key. d. The phone entity must have country code, phone number, a primary phone number flag, the person foreign key, and a unique ID as a primary key. 2. Populate your tables with 3 people that have a least two addresses and two phone numbers each. Each person must have a primary address and phone number. 3. Insert a person with a phone number but no address. 4. Insert a person with an address but no phone number. 5. Select from each of your tables individually 6. Select from your three tables using a multi-table join to return all records for all people. 7. Select from your three tables using a multi-table join to return all people and only primary addresses and primary phone numbers. 8. Turn in your table structures, insert statements, queries, and all query results. 1. Design 3 database tables that represent a person with and addresses and phone numbers. a. The three tables need to be related such that a person can have one or more addresses and a person can have one or more phone numbers. b. The person entity must have first name, last name, age, gender, and a unique ID as a primary key. c. The address entity must have street address, city, state, zip code, country, a primary address flag the person foreign key, and a unique ID as a primary key. d. The phone entity must have country code, phone number, a primary phone number flag, the person foreign key, and a unique ID as a primary key. 2. Populate your tables with 3 people that have a least two addresses and two phone numbers each. Each person must have a primary address and phone number. 3. Insert a person with a phone number but no address. 4. Insert a person with an address but no phone number. 5. Select from each of your tables individually 6. Select from your three tables using a multi-table join to return all records for all people. 7. Select from your three tables using a multi-table join to return all people and only primary addresses and primary phone numbers. 8. Turn in your table structures, insert statements, queries, and all query results