Database+Coursework Database 101

Area Film and Literary Society (MLFS) provide groups and events for local people. All participants must be members (who pay an annual fee) or their guests who may attend events. Fees vary from one group to another. In addition members may have a reduction in fees depending on their type of membership. For example Individual members pay 100% fees and Concessionary members pay 50%. There are also Household members and a special category called Friends of the Society. The Society hosts a number of groups which meet monthly.
Members can join one or more groups; currently these include Film, Science, Reading and Poetry Groups. A paper record is held for each member, an example of which is given below. Member details| Event talents| Member No1022 NameJay PatelTelephone020 8888 3333AddressHigh Rd, London Member type Individual | Ability Code| Talent | | 01 Poetry 05 Science| membership records| Session (year)| Group code| Group name| CoordNo| CoordName| Feepaid| 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 | Reading| 111| Jane Austen| ? 75| 03/09/08| 2009-2010| 05 | Science| 181| Marie Curie| ? 90| 03/09/09| * | * | * | * | * | * | * | Note that the group code and the ability code are both based on the same domain of values. The latter represents members’ talents which the Society may make use of – this is described later. One group of a particular type (such as Poetry) will be run each year, assuming 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 address and telephone number of each coordinator. Besides groups, the society also holds one-off special events, such as lectures, films, art exhibitions and musical evenings. Events do not relate to particular groups: they are open to all members and their guests and are organised by one of the coordinators. Events will be led by an outside speaker, or sometimes a member (who have special talents as shown in the example record above) will act as the speaker.

Each event will have only one speaker (whether an outside speaker or a member speaker), but a speaker may speak at a number of events. Details 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 model mapped to a relational database If you need to revise this topic, see Text Book Chapter 3. Produce an Entity-Relationship Model using UML notation for the above case.
Convert to a relational model by specifying the primary and foreign keys, mapping any 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. Note that there is no need to include the type of each attribute. State any assumptions that you may need to make particularly 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 different parts of the ERD and then coming together to discuss. Remember: * databases hold historical information, not just details of current records * to work 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 the foreign key goes on the ‘many side’) * decompose any m:n relationships 1b) Validate the model Checking for connection traps
Examine 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 support the following functional requirement i. e. specify the access path by listing the appropriate relations (taking into account the correct 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. ’


Lexis Nexis Uk Newspaper Database Article Education Essay

This annotated bibliography will see issues associating to a male influence within a schoolroom environment and to detect whether or non it benefits kids ‘s acquisition. Why is there a deficiency of male instructors in the twenty-first century? Do male instructors deliver a better acquisition experience than female instructors?
Cardinal Footings
“ male instructors in early instruction ” “ male instructors ” “ pupil reaction to male instructors ” “ male influence in school ” “ learning males in school ” “ work forces in the schoolroom ” “ work forces in early instruction ” .

Education Resource Information Centre ( ERIC )
Sumsion, J. ( 2005, 1st One-fourth ) . Male instructors in early childhood instruction: issues and instance survey. In Diamond, K, E. Early Childhood Research Quarterly 20 ( pp.109-123 ) . USA.
Searched for “ male instructors in early instruction ” in ERIC. Full text version was non available. Full article provided by SciVerse database through a journal hunt on Strathclyde Universities SuPrimo.
This subdivision of the diary identifies positive statements for the enlisting of work forces in early instruction. The research was compiled in three bunchs of statements: benefits for society, for the instruction business and for the infant pupils.
This first statement declares that with an increased figure of males in the instruction profession that there would be an altered attitude to premises in relation to gender functions and duties. This is briefly conveyed ( Cameron & A ; Moss 1998 ) that differentiates between male and females in relation to childcare – contradictory of sensed stereotypes.
Additionally, the following bunch argues that with more male input in the profession there would be an addition in the position and of instructors ( Lyons et al. , 2003 ) and besides would better workplace kineticss and staff interrelatednesss. Besides there is grounds that supports work forces keep higher paid administrative places that could potentially be transferred to the learning profession.
The 3rd statement is that work forces can assist develop kids ‘s attitude for a diverse hereafter. By exposing kids to non-traditional buildings they can get down to go more compassionate and morally right.
Sternod, B.M. ( 2011, Issue 2 ) . Role Models or Normalizing Agents? A Genealogic Analysis of Popular Written News Media Discourse sing Male Teachers. In Thiessen, D. Curriculum Inquiry. ( pp.277-286 ) . California, USA.
Searched for “ work forces in the schoolroom ” in ERIC. Full text version was non available. Full article provided by Wiley Online Library through a journal hunt on Strathclyde Universities SuPrimo.
This diary identifies adult females as a menace to the development of immature males as they override the masculine impact that is attempted to be conveyed. Evidence supports the deficiency of male instructors in simple schools with merely 9 % being male.
Some school kids have no male influence in their lives and urgently necessitate an influential figure to larn and draw a bead on from. Male instructors besides supply concrete subject within the schoolroom but besides can understand immature male behaviorism. Males are besides, more austere doing kids more alert within the schoolroom and they besides are able to link with pupil, in bend bettering acquisition.
Michael Gurian ( Hein, 1998 ; Peterson,1998 ) claims that male childs learn through a “ masculine nurturing system ” which revolves around “ regard. Male childs can derive regard from an older/wiser male and this has to be earned. If a male child acts unsuitably the higher ranking male will loss regard for that person and it is up to the person to accomplish it back. This relationship has a inclination to be around males – therefore it would be good for male influence to be in school community.
Lack of male influence both in and out of school physiques up a inclination for Acts of the Apostless of force and other offenses. Without a powerful influence in a kid ‘s development their natural maleness is free to make what it wants. Without positive counsel immature male could easy fall in to the incorrect paths and may non hold good ethical motives and could arise against what is really good.
This diary continues to look at different facets of what makes a function theoretical account and what it has been based on.
Lexis Nexis UK Newspaper database article
Clark, L. ( 2012 ) . 1 in 5 male childs at primaries have no male instructors while some could travel through their full instruction without one. MailOnline, 16th November. Retrieved from hypertext transfer protocol: // .
Searched for “ Male instructors ” on hypertext transfer protocol: // .
This newspaper article presents an statement that there is a demand for male primary pedagogues. The article cites that there is a astonishing sum of female instructors in relation to male instructors with 360,485 male childs aged 4 – 10 holding attended a school with no qualified male presence. Within these statistics 61,060 of the pupils are having free school repasts due to low income – highlighting that the job is countrywide.
There is a deficiency of male influence within primary students taking to claims that excessively many male childs are holding small or no interaction with males before making high school. With a altering nature within places there potentially may be pupils who reach early maturity and holding no male influence – making a ‘distorted ‘ position of society. Professor John Howson at Oxford Brookes University agrees stating: “ If you ne’er acquire a opportunity to interact with one gender, so you are non acquiring a rounded instruction ” .
The article continues, speaking about how immature professionals can be persuaded to come in the instruction profession and how bad imperativeness and other influential factors can do this hard.
Internet Research Article
Koutros, M. ( 2010 ) . The Lack of Male Teachers and it ‘s Effect on Student Development. Brooklyn College: USA. Retrieved from hypertext transfer protocol: // .
Searched hypertext transfer protocol: // for “ student reaction to male instructors ” .
This article was produced by a pupil at an American University who was bring forthing an Action Research Project on the deficiency of male instructors in a schoolroom. The survey identifies that the National Education Association ( NEA ) , revealed that less than one-quarter of all instructors were male. Recent surveies show that the deficiency of male instructors is due to low wages and issues associating to gender stereotypes.
The paper is garnering research on the deficiency of a strong male function theoretical account in schoolrooms holding a harming impact on a kid ‘s sustainable development. Male instructors are viewed as function theoretical accounts ( Martino, 2008. p.192 ) . “ Recuperative Maleness Politicss ” are a agencies to change stereotypes and convey back a male influence into the schoolroom. This is significantly of import for immature male childs as they look for a function theoretical account, person to draw a bead on to.
Gender besides plays an impact on schoolroom direction techniques which differ from male and female. Males within a schoolroom have a better impact in relation to females as kids respond to bids from a male more instinctively ( Kesici, 2008 ; Bryce & A ; Blown, 2007 ) .
The article continues to detail the sum-up of the pupil ‘s research and his program of what he is traveling to make to garner relevant grounds.
Andersonian library Book
James, A.N. ( 2007 ) . Teaching the Male Brain: How male childs Think, Feel and Learn in School. ( pp. 157-159 ) . USA.
Searched “ learning males in school ” in the University of Strathclyde ‘s SuPrimo database.
This book analogies ‘ that maleness is an indispensable facet of a kid ‘s development – kids should be able to see that there are many alternate ways of seeing the universe from a gendered position. Male function theoretical accounts are critical: with many an increasing figure of one-parent households a dominantly female influence disenable male childs to specify what it means to be a male child ( Neall, 2002 ; Pollack, 1998 ) .
A job arises with a chief female influence on a immature male: what if in seeking to move like a male, a child Rebels against the influence of a female and acts the complete antonym. He may hold decided that the right behavior for work forces is ill-mannered, angry, noisy and vocal. This acts as a cardinal defect to a feminist position within a school environment ( Mac and Ghail, 1994 ) .
A male instructor can besides impact originative subjects such as art in a positive mode. By giving the kids a mechanical point of view the pupils took it in on their pace and completed a undertaking as holding thought about it alternatively of a stereotyped female originative expressional side.
The book is all about the manner boys learn and how they can be influenced and taught in different ways.
Online Library Article
Bittner, M. T. and Cooney, M. H. ( 2001 ) . Work force in Early Childhood Education: Their Emergent Issues. In Jalongo, M. R. Early Childhood Education Journal. ( pp. 77 – 82 ) . USA.
Searched “ male instructors early childhood ” on Strathclyde University ‘s SuPrimo library hunt engine.
This subdivision of the diary explores the different issues that affect work forces within a schoolroom environment. It looks at influential factors such as salary, household reaction and pre-conceptual stereotypes of being male and a member of the instruction profession.
The goes on to look at the advantages and disadvantages of holding a male influence in a schoolroom. Children can profit both straight and professionally from a skilled, good educated male instructor. There are two analogies that back this up both giving grounds that male pupils have wholly altered behavior, assurance and ability with the impact that a male presence has had on the persons. Besides experiments have revealed that pupils are more watchful and concentrate on a adult male within a category – therefore would larn more.
However, male instructors have a inclination to experience stray and uncomfortable being in a female dominant environment. This was besides apparent from one of the focal point groups the research workers carried out: one individual declared that some pupil ‘s parents were non happy with a adult male assisting their kids with toilet demands and another instructor disclosure that he feels judged when a kid harmlessly sits on his articulatio genus. To try to decide this ‘touch ‘ issue the group devised a procedure of constructing positive relationships with both pupils and parents in an effort to attest this issue.
This article concludes by placing a demand for a declaration in the manner male instructors are perceived within the schoolroom.
Sternod, B.M. ( 2011, Issue 2 ) . Role Models or Normalizing Agents? A Genealogic Analysis of Popular Written News Media Discourse sing Male Teachers. In Thiessen, D. Curriculum Inquiry. ( pp.277-286 ) . California, USA.
Bittner, M. T. and Cooney, M. H. ( 2001 ) . Work force in Early Childhood Education: Their Emergent Issues. In Jalongo, M. R. Early Childhood Education Journal. ( pp. 77 – 82 ) . USA.
Sternod and the Bittner, Cooney partnership both conducted research into what portion a male instructor dramas in the development of an early twelvemonth ‘s pupil. Sternod declares that there is a despairing demand for a male figure in the successful development of kids, particularly boys. The laterality of female staff overruling the really few male instructors highlights a defect in the instruction system with a deficiency of right gender stereotype instruction. Cooney and Bittner look at the learning profession and how it affects work forces. They besides explore the influence a male has on the schoolroom and how it can be perceived by others.
Bittner and Cooner found that work forces may experience uncomfortable and uneasy with a schoolroom when kids are trying to be fond and ‘touchy-feely ‘ – non due to the males personal edginess but by the fact that in today ‘s milieus that would be judged by others and seen as incorrect. This provides grounds in favor of female instructors as they are conveyed as loving and lovingness. This stereotype besides differs from sternods article as he argues that adult females are the 1s doing the deficiency of full development chances of kids.
Particularly, Sternod looks at male childs larning through a “ masculine nurturing system ” where regard is indispensable. Male instructors can utilize different methods of learning kids and have fluctuations in schoolroom behavior direction which differ from females. This method gives male instructors a measure up on females as they have an about point system with male pupils and that the pupils will take to affect -work harder- their male instructor. This strong personal instructor pupil relationship contradicts Cooney and Bittner as they argue that male instructors can non hold a strong relationship with pupils.
It is deserving observing that both research workers agree that there is a demand for more male ‘s instructors within the learning profession. They merely somewhat differ on the methodological analysis in which should be set in topographic point to further better male standing in the schoolroom and for the development of kids.
A male influence within the learning profession decidedly has an impact on how kids are educated, the manner kids are educated and the effectivity of schoolroom behavior direction.
Without surrogate, new methods of educating our immature people there would be a deficiency of effectual instruction manners that push and develop kids to endeavor to what they can go. A male function theoretical account is critical in guaranting that kids understand the difference between muliebrity in being a miss and maleness in being a adult male. As it is chiefly female instructors in early phases so kids develop more feminine properties and hence deficiency in maleness which is particularly refering for immature male childs.
If there was no male presence so at that place would non merely be a deficiency of confident important figures but there besides would be an underlined defect in a kid ‘s gender stereotype instruction. A adult male in a schoolroom gives kids a modern point of view that kids aspire that anyone can make anything they want – non all instructors are females, non all pilots are male.
There is grounds that supports males have a better controlled schoolroom with kids holding a inclination to hold better behavior in the pretension of a male. It could be the fact that kids are scared to how a male may respond to bad behavior or it could be due to the regard that the kids have for the pedagogue. Young boys normally behave better around older males as they are seeking to affect them and derive regard.
Personally, I think that without males in the instruction profession there would be a batch less compassionate and credence within this modern, of all time altering epoch. Male teacher partly maintain kids up-to-date with altering tendencies within society and hence do the coevals of tomorrow more diverse and accepting. Besides without the first male instructor to animate the following coevals at that place would n’t be draw a bead oning instructors such as me.