'Database+Coursework Database 101\r'

'Area Film and literary Society (MLFS) provide groups and events for local people. whatsoever participants must be members (who yield an annual fee) or their guests who may attend events. Fees take off from atomic number 53 group to a nonher. In entree members may take in a drop-off in fees depending on their type of membership. For lawsuit Individual members pay 100% fees and Concessionary members pay 50%. There argon similarly Ho drillhold members and a special fellowship called Friends of the Society. The Society hosts a number of groups which go monthly. comp angiotensin-converting enzyments can join one or more groups; currently these include Film, science, cultivation and Poetry Groups. A paper immortalise is held for apiece member, an exemplar of which is given below. Member details| Event talents| Member No1022 NameJay PatelTelephone020 8888 3333AddressHigh Rd, capital of the United Kingdom Member type Individual | great power Code| Talent | | 01 Poetry 05 acquaintance| membership records| Session (twelvemonth)| Group formula| Group name| CoordNo| CoordName| Fee pay| Date paid| 2007-2008| 01 | Poetry | 102| Carol Duffy| ? 0| 19/09/07| 2008-2009| 01 | Poetry | 102| Carol Duffy| ? 60| 02/09/08| 2008-2009| 06 | breeding| 111| Jane Austen| ? 75| 03/09/08| 2009-2010| 05 | Science| 181| Marie Curie| ? 90| 03/09/09| * | * | * | * | * | * | * | bill that the group code and the capacity code are both base on the same domain of values. The latter(prenominal) represents members’ talents which the Society may make use of †this is described later. One group of a particular type ( such as Poetry) forget be run from each one year, anticipate there are nine or more members who want to join a group.Each group is run by a coordinator, who may change from one year to the next. In addition to the above, the society holds the hide and telephone number of each coordinator. allways groups, the society also holds one-off special even ts, such as lectures, films, art exhibitions and practice of medicineal evenings. Events do not relate to particular groups: they are open to all members and their guests and are arrange by one of the coordinators. Events leave alone be led by an outside vocalizer, or sometimes a member (who have special talents as shown in the example record above) will act as the sayer.Each event will have single one speaker (whether an outside speaker or a member speaker), only if a speaker may speak at a number of events. enlarge will be held of the event name, the date, and venue and outside speakers (name and telephone number). The Society will keep records of members who attended events and the number of guests for each member per event. 1a) Entity-relationship homunculus mapped to a relative database If you need to revise this topic, see text edition Book Chapter 3. Produce an Entity-Relationship Model development UML notation for the above incident.Convert to a relational mode l by peging the primary and unconnected marks, mapping either one-to-one relationships into relations, and decomposing any many-to-many relationships. This is the Relation diagram and the diagram which you should submit. name that there is no need to include the type of each attribute. State any assumptions that you may need to make oddly about optional and mandatory relationships. Note that assumptions are about how you have interpreted the scenario, not about the E-R modelling process. The ERD is not trivial †it involves at least 10 entities.I suggest you start by each member of your group concentrating on contrary parts of the ERD and then coming unneurotic to discuss. Remember: * databases hold historical information, not just details of current records * to bend out cardinality of relationship use ‘ two sentences each starting with the word one’ * check all attributes; they should be atomic (single-valued) * check primary/foreign key links (remember t he foreign key goes on the ‘many side’) * decompose any m:n relationships 1b) bear out the model Checking for connection trapsExamine your model and identify one potential trap (fan trap or chasm trap) †if present. Consider whether this may cause a problem to your model and re-draw if necessary, arguing your case either way. Supporting the functional requirements Validate the model to check it can pay the following functional requirement i. e. specify the access path by itemization the appropriate relations (taking into account the condemn relationships) from your diagram: ‘List all members by name who have ever belonged to the Science group, who have a talent for music and have attended an event with Goldie as the outside speaker. ’\r\n'