subject
Business, 15.10.2020 14:01 jarteria0

Consider a mail order business in which employees take orders or parts from customers. Create a conceptual using the following information. a. The mail order company has employees, each identified by a unique employee number, first and last name, and Zip Code.
b. Each customer of the company is identified by a unique customer number, first and last name, and Zip Code.
c. Each part sold by the company is identified by a unique part number, a part name, price and quantity in stock.
d. Each order placed by a customer is taken by an employee and is give a unique order number. Each order contains specified quantities of one or more parts. Each order has a date of receipt as well as an expected ship date. The actual ship date is also recorded.

Required:
Design an ER (Entity-Relationship) diagram for the mail order database and build the design using a data modeling tool such as ERwin or Rational Rose.

ansver
Answers: 2

Another question on Business

question
Business, 22.06.2019 07:00
Bridgeport company began operations at the beginning of 2018. the following information pertains to this company. 1. pretax financial income for 2018 is $115,000. 2. the tax rate enacted for 2018 and future years is 40%. 3. differences between the 2018 income statement and tax return are listed below: (a) warranty expense accrued for financial reporting purposes amounts to $7,500. warranty deductions per the tax return amount to $2,200. (b) gross profit on construction contracts using the percentage-of-completion method per books amounts to $94,700. gross profit on construction contracts for tax purposes amounts to $67,100. (c) depreciation of property, plant, and equipment for financial reporting purposes amounts to $61,800. depreciation of these assets amounts to $75,700 for the tax return. (d) a $3,600 fine paid for violation of pollution laws was deducted in computing pretax financial income. (e) interest revenue recognized on an investment in tax-exempt municipal bonds amounts to $1,500. 4. taxable income is expected for the next few years. (assume (a) is short-term in nature; assume (b) and (c) are long-term in nature.) (a) prepare the reconciliation schedule for 2017 and future years. (b) prepare the journal entry to record income tax expense for 2017. (c) prepare the income tax expense section of the income statement beginning with “income before income taxes.” (d) determine how the deferred taxes will appear on the balance sheet at the end of 2017.
Answers: 1
question
Business, 22.06.2019 18:00
Match the different financial task to their corresponding financial life cycle phases
Answers: 3
question
Business, 22.06.2019 19:40
Lauer corporation uses the periodic inventory system and has provided the following information about one of its laptop computers: date transaction number of units cost per unit 1/1 beginning inventory 210 $ 910 5/5 purchase 310 $ 1,010 8/10 purchase 410 $ 1,110 10/15 purchase 255 $ 1,160 during the year, lauer sold 1,025 laptop computers. what was cost of goods sold using the lifo cost flow assumption?
Answers: 1
question
Business, 23.06.2019 00:40
Skathy lee berggren, a professor of oral communication at cornell university, indicates “a lot of my students re­ally [only] scratch the surface with the type of research they’re doing.” according to andy guess, at inside higher ed, “just because students walk in the door as ‘digital natives’, doesn’t mean they’re equipped to handle the heavy lifting of digital databases and proprietary search engines that comprise the bulk of modern, online re­search techniques.” students erroneously think a google search is research. as you read through the reasons that should stimulate your interest in studying research methods or evaluate the nine factors that guarantee good research, what actions do you propose to narrow the gap between students’ research competence and what’s required of a modern college graduate about to become a manage
Answers: 1
You know the right answer?
Consider a mail order business in which employees take orders or parts from customers. Create a conc...
Questions
question
History, 11.08.2021 01:00
question
Mathematics, 11.08.2021 01:00
question
Mathematics, 11.08.2021 01:00
Questions on the website: 13722360