You have been hired to design a relational database for a convenience store which is located within an apartment complex. The goal of the database is to keep track of the inventory sold in hopes of using the data to better meet the customer's convenience store needs. Up until your arrival, the store kept track of each customers purchases using a flat database log, as shown in the following table. Using the information provided, build a relational database that will allow for querying things such as products sold, customer purchases, total apartment purchases, and total spent per apartment. Include any created tables and identify the keys and key types that are used. Identify all relationships, labeling them 1:1, 1:N, or M:N.

Name	Apt #	Products	Price	Quantity
Joseph Anthony	1125	Orange Juice	4.59	1
Joseph Anthony	1125	Bread Loaf	2.29	1
Yolanda Burns	3221	Milk	3.67	1
Yolanda Burns	3221	Candy Bar	1.19	3
Francis Jordan	1138	Gum	0.99	2
Steve Miller	2221	Gum	0.99	1
Cho Lin	2239	Bread Loaf	2.29	1