1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
ycow [4]
3 years ago
7

Consider a mail order business in which employees take orders or parts from customers. Create a conceptual using the following i

nformation.
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.

Business
1 answer:
adelina 88 [10]3 years ago
3 0

Answer:

attached below is the Entity-Relationship diagram

Explanation:

Designing  an ER ( Entity-Relationship ) Diagram for the mail order database  using a data modelling tool

attached below is the an Entity-Relationship diagram  created using all the information provided above

You might be interested in
Radford Inc. manufactures a sugar product by a continuous process, involving three production departments-Refining, Sifting, and
nalin [4]

Answer:

Following are the solution to this question:

Explanation:

In point 1:

Date                 Title                                  post reference           Dr.               Cr.   30-sep       Method work – refining             141                  388000  

                          Materials                              131                                    385000  

In point 2:

Date                 Title                                  post reference           Dr.               Cr.   30-sep        Method work – refining                  141              141000  

                   Payable Wages                                 251                              141000

In point 3:

Date                 Title                                  post reference           Dr.               Cr.   30-sep        Method work – refining                 141               96800  

                   Factory overhead- refining            151                                96800

In part B:

Date                 Title                                  post reference           Dr.               Cr.   30-sep          Method work – Sifting               142                 625600

           (388000+141000+96800+(29800-30000))

              Method work – refining                     141                                 625600

5 0
3 years ago
Your portfolio is comprised of 30 percent of stock X, 25 percent of stock Y, and 45 percent of stock Z. Stock X has a beta of 1.
Evgesh-ka [11]

Answer:

The beta of your portfolio is 0.9045

Explanation:

Hope this help  :D

6 0
4 years ago
Research the challenges associated with payments across international borders and prepare a brief summary of your findings. Do m
NemiM [27]

Answer:

The main challenge associated with payments across international borders is the challenge of currency rates. Because currencies vary across countries, sometimes a payment can be either hugely benefitial or hugely detrimental for a company, depending on how expensive or cheap its domestic currency is compared to the foreign currency.

Another challenge is related to international legislation, banking systems, red tape, and so on. Banking laws in some countries are more favorable to firms than in others, for example, by charging less financial expenses or comissions.

6 0
3 years ago
Homestead Crafts, a distributor of handmade gifts, operates out of owner Emma Finn’s house. At the end of the current period, Em
Travka [436]

Answer: 1155

Explanation:

The solution guess thus to calculate the units in Ending Inventory:

Units of product on hand: 800 units

Add: Units in transit 180

Add: Units on consignment 200

Less: Damaged units 25

The number of units that Emma should include in her company’s period-end inventory will be:

= (800+180+200) - 25

= 1180 - 25

= 1155

3 0
3 years ago
Suppose that you were born in 1995. Also, suppose that your mother received a $100 baby shower gift at your birth. How much woul
valkas [14]

Answer:

$155.5

Explanation:

The Consumer price index indicates how prices change through time of a determined basket of goods and services. Inflation is calculated by the percentage change of this index in two periods of time. In this case, we must calculate the percentage change:

1995: 152.4

2015: 237.0

(237-152.4/152.4)*100= 0.555*100=55.5%

The inflation rate for this period is 55.5%. To buy a similar amount of goods and services in 2015 we have to pay an 55.5% extra, which means we have to pay $155.5

4 0
3 years ago
Other questions:
  • 10. Which of the following is a way developing nations are trying to raise living standards? A. Attract investment B. Return to
    10·1 answer
  • . Mortgage Affordability. Seth and Alexandra Moore of Elk Grove Village, Illinois, have an annual income of $110,000 and want to
    11·1 answer
  • Why does the free-market system bring efficiency as well as freedom?
    14·1 answer
  • Larkspur Company reported net income of $2.4 million in 2020. Depreciation for the year was $505,000, accounts receivable increa
    15·1 answer
  • Dudley Savings Bank wishes to take a position in Treasury bond futures contracts, which currently have a quote of 110 − 100. Dud
    5·1 answer
  • Tab exchanges real estate used in his business along with stock for real estate to be held for investment. The stock transferred
    10·1 answer
  • Lisa and her friends volunteer and run an initiative called FeedtheLocal. They collect foods that are donated by the community a
    6·1 answer
  • What challenges may arise if a U.S. project manager moves to a foreign country to manage a project for 5 years
    12·1 answer
  • How does your new budget help you to meet your long-term goal of saving for college?
    6·1 answer
  • Sheffield Company signed a long-term noncancelable purchase commitment with a major supplier to purchase raw materials in 2021 a
    5·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!