Hands-On Project:
Building a Relational Database, page 76 of Database Security by Alfred Basta, Melissa Zgola First Edition.
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 customers' convenience store needs. Up until your arrival, the store kept track of each customer's purchases using a flat database log, as shown in the follow- ing 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 relation- ships, labeling them 1:1, 1:N, or M:N.
|
Customer name
|
|
APt•
|
Product name
|
Product prim
|
Purchased
|
|
Joseph Anthony
|
|
1125
|
Orange juice
|
4.59
|
1
|
|
Joseph Anthony
|
|
1125
|
Bread loaf
|
2.29
|
1
|
|
Yolanda Burns
|
4.1
|
3221
|
Milk
|
3.67
|
1
|
|
Yolanda Burns
|
|
3221
|
Candy bar
|
1.19
|
3
|
|
Frances Jordan
|
|
1138
|
Gum
|
.99
|
2
|
|
Steve Miller
|
|
2221
|
Gum
|
99
|
1
|
|
Cho Lin
|
|
2239
|
Bread loaf
|
2.29
|
1
|