I was given the following scenario to construct an ER diagram from:
A travel web site is being developed. This site will allow registered members to add entries for hotels where they have stayed into an online, collaborative database.
Data held for a hotel includes the name of the hotel and full address and where possible a latitude and longitude to enable generation of an overlay for Google Earth.
Members are identified by a unique nickname and have an email address and
password. The interface allows a member to search for a hotel, create a new hotel if it is not already present, to view the comments and ratings that other members have made about a selected hotel and to add their own comment. A member's comment on a hotel includes a text comment and a rating from 1 to 5, and is dated.
A web based application is to be developed primarily to be used via browsers on personal computers and tablets but eventual use by other platforms such as mobile phones should be planned for as well.