Reference no: EM131182394
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
|
|
Impact greenhouse gases found in the atmosphere
: 1. How does human activity impact greenhouse gases found in the atmosphere? 2. What are some simple changes humans can do to help keep the Earth cooler in the future? 3. What are you doing to help?
|
|
What is the momentum of the ball
: A 10g ball is thrown, at a 25oangle above the horizontal, with a speed of 20m/s. What is the momentum of the ball?
|
|
Describe the risks and benefits with leading
: There are two aspects to this assignment. First, describe the risks and benefits with leading, meeting, and lagging the market in overall compensation and benefits
|
|
Develop criteria to assist in selecting the vendor to use
: Develop criteria to assist in selecting the vendor to use for the training. Determine the topics that should be covered in the seminar. Support your selection of the topics.
|
|
Build relational database that will allow for querying thing
: Build a relational database that will allow for querying things such as products sold, customer purchases, total apartment purchases, and total spent per apartment.
|
|
Ntify the specific relevant stakeholder for the subject firm
: ntify the specific relevant stakeholders for the subject firm. For each stakeholder, identify the key satisfaction attributes for each stakeholder.
|
|
What is the efficiency of engine
: What is the efficiency of this engine? What is the maximum possible efficiency of this engine?
|
|
Could we take a walk that crosses all the bridges
: If we built a new bridge in K¨onigsberg between the Island and the top and bottom banks of the river, could we take a walk that crosses all the bridges and uses none twice? Either explain where could we start and end in that case or why we couldn'..
|
|
Significant different costs
: Waterway debris can be removed by two methods which carry significant different costs, either by land based equipment or by water based equipment. Would you consider breaking the line items down to account for these different operations
|