You have been asked by your local Swimming club to create a database to keep their records in. The club consists of members who actively compete in competitions and coaches, each of whom coaches one or more of the members. Competitions are held every second Thursday and the club records who competes in each race and their placing in each race. Competitions may occur at one of three venues (Hyde Park Pool 8 lanes, Beatty Park Pool 10 Lanes, The Super drome 12 Lanes). All members have a unique membership number, Name, Address, DOB and other standard contact details. Competitions have a unique name and notes are kept on the temperature and wind speed and direction. Some further assumptions are: A member is only ever assigned one coach There are 10-15 races per competition Races have a race number which is unique only within each competition On the basis of the above description, draw a suitable logical and a physical Entity-Relationship (ER) diagram. Identify entities and their attributes, relationships and their types, and show clearly the primary/foreign key attributes.