Business, 10.06.2020 17:57 daniiltemkin20

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 customer’s 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

Answers: 2

Show answers

Another question on Business

Business, 22.06.2019 03:40

Apharmaceutical packaging company (ppc) has decided to reorganize its processes into cells. the company has four different production operations, each requiring a unique piece of equipment. the names and functions of the four pieces of equipment are sort, count, place, and package. the company packages five different families of products (a, b, c, d, and e). the tables below indicate the demand (total units/day by product family), required operations, and operation cycle times for each product family. assume that any individual piece of equipment is available to operate 16 hours/day, but 2 hours (in total) are lost each day on each piece of equipment due to breaks and meetings when operators are not available to operate the equipment. how many minutes/day are available for production

Answers: 3

Answer

Business, 22.06.2019 06:40

At april 1, 2019, the food and drug administration is in the process of investigating allegations of false marketing claims by hulkly muscle supplements. the fda has not yet proposed a penalty assessment. hulkly’s fiscal year ends on december 31, 2018. the company’s financial statements are issued in april 2019. required: for each of the following scenarios, determine the appropriate way to report the situation. 1. management feels an assessment is reasonably possible, and if an assessment is made an unfavorable settlement of $13 million is reasonably possible. 2. management feels an assessment is reasonably possible, and if an assessment is made an unfavorable settlement of $13 million is probable. 3. management feels an assessment is probable, and if an assessment is made an unfavorable settlement of $13 million is reasonably possible. 4. management feels an assessment is probable, and if an assessment is made an unfavorable settlement of $13 million is probable.

Answers: 1

Answer

Business, 22.06.2019 14:00

Which of the following is not a characteristic of a weak economy? a. a low employment rateb. a high inflation ratec. a decreased gdpd. a high unemployment rate

Answers: 1

Answer

Business, 22.06.2019 18:00

Biochemical corp. requires $600,000 in financing over the next three years. the firm can borrow the funds for three years at 10.80 percent interest per year. the ceo decides to do a forecast and predicts that if she utilizes short-term financing instead, she will pay 7.50 percent interest in the first year, 12.15 percent interest in the second year, and 8.25 percent interest in the third year. assume interest is paid in full at the end of each year. a)determine the total interest cost under each plan. a) long term fixed rate: b) short term fixed rate: b) which plan is less costly? a) long term fixed rate plan b) short term variable rate plan

Answers: 2

Answer

You know the right answer?

You have been hired to design a relational database for a convenience store which is located within...

Questions