Create a fully expanded ERD based on the information in the following narrative.
Aussie Wine Tours (AWT) conduct tours of the wineries of Victoria's Yarra Valley wine
region. Each tour is run on a single day. Currently, there are several wine tours including
The White Wine tour, The Red Wine tour and The Sparkling Wine tour. The Red Win
Tour is a very popular tour and has often run 3 or 4 times in a single month. The tour
schedule depends upon the availability of the wineries, the availability of the tour leaders
and the public interest.
Each tour takes usually takes around 6 hours to complete and is led by one or more of
AWT's well-renowned wine experts.
Each tour has a 'current price'. However, due to various market forces, prices have been
rising over the past couple of years. For example, last year the Red Wine Tour was $170
but now it's the current price is $200.
No two events for the same tour can occur on the same day. (e.g. The Red Wine Tour
cannot be conducted twice on the same day).
AWT have many satisfied customers, many of whom have attended multiple wine tours
over the years. Each customer has a customer id, name, address and contact phone
Tyson Iron Works is about to go public. It currently has aftertax earnings of $5,500,000, and 3,700,000 shares are owned by the present stockholders. The new public issue...May 24 2020
Do not round intermediate calculations. Give your final answer(s) to three significant figures. Each of the four vertical links has an 9 x 38-mm uniform rectangular cross...May 16 2020
Using specific examples from the readings, with particular attention to empirical research, discuss the extent to which particular processes of development may be culture-boundMar 14 2020
Inflation is forecast to be at an annual rate of 3% for the next year. a.) What will the real rate of interest be if the forecast holds true, and the stated effective rat...Dec 04 2019
Emergency rescue vehicle use. An emergency rescue vehicle is used an average of 1.3 times daily. Use the Poisson distribution to finda. The probability that the vehicle w...Aug 07 2020
What is Organizational management? >Jul 23 2020
Classify each of the following accounting practices as conservative or aggressive:Increase the allowance for uncollectible accounts.When costs are rising, change from FIF...Jan 27 2020
If the liabilities of a business increased $75,000 during a period of time and the equity in the business decreased $30,000 during the same period, the assets of the busi...Jan 28 2020
One of the problems facing Leukemia and Lymphoma Society is the retention of donors and participants. what are some new ideas LLS could use to address this problem?Aug 26 2020
The following information comes from the General Fund trial balance of West Chester County as ofDecember 31, 2012. Prepare the countyAc€?cs General Fund statement of reve...Jun 24 2020
Welcome to MyCourseHelp Services, World's leading Academic solutions provider with Millions of Happy Students.