E/R Diagram Question:

bar-beer-drinker scheme:

Beers(name, manf)

Bars(name, addr, license)

Drinkers(name, addr, phone)

Likes(drinker, beer)

Sells(bar, beer, price)

Frequents(drinker, bar)

We will extend the bar-beer-drinker scheme, with information about specific transactions by customers (drinkers). We will store all bills of all drinkers, who may also order food items (bar food etc). For each bill we will store the details of the transaction what items were purchased (may be beer, may be food, soft drinks etc), time when the bill was issued, name of the drinker and the transaction id. Each transaction will also total amount paid which will be sum of prices of all items on the bill plus 7% tax. There may also be a tip.

Please draw an E/R diagram of the extended bar-beer-drinker scheme described above.