Create a fully expanded ERD based on the information in the following narrative….

Part 1.

Create a fully expanded ERD based on the information in the following narrative.

Business 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



We are the Best!


275 words per page

You essay will be 275 words per page. Tell your writer how many words you need, or the pages.

12 pt Times New Roman

Unless otherwise stated, we use 12pt Arial/Times New Roman as the font for your paper.

Double line spacing

Your essay will have double spaced text. View our sample essays.

Any citation style

APA, MLA, Chicago/Turabian, Harvard, our writers are experts at formatting.

We Accept

Secure Payment
Image 3