Database activity: Using Microsoft Access in SQL Design

Design $3$ database tables that represent a person with and addresses and phone numbers.

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.

The person entity must have firsI name, last name, age, gender, and a unique ID as a primary key.

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.

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.

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.

Insert a person with a phone number but no address.

Insert a person with an address but no phone number.

Select from each of your tables individually

Select from your three tables using a multi$-$table join to return all records for all people.

Select from your three tables using a multi$-$table join to return all people and only primary addresses and primary phone numbers.

Turn in your table structures, insert statements, queries, and all query results.