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

Other questions on the subject: Business

Business, 21.06.2019 21:00, yasmineeee96371

Jurvin enterprises is a manufacturing company that had no beginning inventories. a subset of the transactions that it recorded during a recent month is shown below. $76,700 in raw materials were purchased for cash. $71,400 in raw materials were used in production. of this amount, $66,300 was for direct materials and the remainder was for indirect materials. total labor wages of $151,700 were incurred and paid. of this amount, $134,300 was for direct labor and the remainder was for indirect labor. additional manufacturing overhead costs of $126,300 were incurred and paid. manufacturing overhead of $126,800 was applied to production using the company's predetermined overhead rate. all of the jobs in process at the end of the month were completed. all of the completed jobs were shipped to customers. any underapplied or overapplied overhead for the period was closed to cost of goods sold. required: 1. post the above transactions to t-accounts.2. determine the cost of goods sold for the period.

Answers: 1

continue

Business, 22.06.2019 06:50, jungcoochie101

On january 1, vermont corporation had 40,000 shares of $10 par value common stock issued and outstanding. all 40,000 shares has been issued in a prior period at $20.00 per share. on february 1, vermont purchased 3,750 shares of treasury stock for $24 per share and later sold the treasury shares for $21 per share on march 1. the journal entry to record the purchase of the treasury shares on february 1 would include a credit to treasury stock for $90,000 debit to treasury stock for $90,000 credit to a gain account for $112,500 debit to a loss account for $112,500

Answers: 3

continue

Business, 22.06.2019 11:10, henryzx900

How much are you willing to pay for a zero that matures in 10 years, has a face value of $1,000 and your required rate of return is 7%? round to the nearest cent. do not include a dollar sign in your answer. (i. e. if your answer is $432.51, then type 432.51 without $ sign)

Answers: 1

continue

Business, 22.06.2019 19:50, kipper5760

Bulldog holdings is a u. s.-based consumer electronics company. it owns smaller firms in japan and taiwan where most of its cell phone technology is developed and manufactured before being released worldwide. which of the following alternatives to integration does this best illustrate? a. venture capitalism b. franchising c. joint venture d. parent-subsidiary relationship

Answers: 2

continue

You know the right answer?

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