Culture and Transmission of Culture Socialization

Culture and Transmission of Culture Socialization Social interaction does not come naturally. The article Culture begins by stating â€Å"A primary reason for the complexity of social interaction is that our species has no instinctive patterns of behavior.† With that being said, we realize that we are not programmed to know how to act, what to value, morals, ethics, and so on. Clearly, our behavior is shaped by the culture we reside in. However, we are born into our culture, which means we must follow what our surrounding environment tells us to do and how to act. Our behavior is greatly influenced by the environment we are surrounded by throughout childhood. For instance, a child growing up in a bad environment involving†¦show more content†¦The difference between a regular doctor and a snake oil salesmen is good drugs that are safe to be prescribed compared to marijuana which is someone who is not permitted to prescribe medicine. The first time this issue became in focus was in 1930 dealing with the American Medical Association. Currently, towards the end of the 20th century doctors would be given the ultimatum of keeping their job if prescribing marijuana to patients. It is questioned that this topic is only brought up to legalize marijuana in general, not solely for medicinal reasons. Chapkis and Webb explain â€Å"the most striking difference between marijuana and â€Å"real medicine† is not the physical but the social effects the plant has on users and healers alike.† The biggest concern is the social effects meaning depressive attitude, and non-social behavior. Every medicine created has its own list of side effects, but why is it illegal to prescribe a medicine with one concern? There aren’t many other objections considering it isn’t addictive and is rather therapeutic. The reader must question why marijuana is so bad considering there is no relevance to urban crime rates. Culture ties into the medical marijuana scene as well. Mexican immigrants were the first to smoke marijuana in the United States in the 1920’s. Since they introduced the bad practice to the U.S. they received a badShow MoreRelatedImpact of School Socialization Institution Essay611 Words   |  3 PagesImpact of School Socialization Institution Socialization is the complex process by which individuals learn skills, attitudes, values, and patterns of behaviour that enable them to function within a particular culture. (Hukamdad, Shahzad , Ali, Qadeer, Ansia, 2011). According to Hukamdad et al, (2011) Socialization enables members of a society to interact with one another and so pass on skills, values, beliefs, knowledge, and modes of behavior pertaining to that society. The Websters II NewRead Moreculture and socialization Essay1533 Words   |  7 Pages Socialization can be defined as the process by which people learn to become members of a society (Tepperman Curtis, 2011, p.58). Thus, the socialization process of an individual starts from birth and continues throughout life. The period of socialization helps an individual to develop feelings, perceptions, learn the basics of social interaction and also learn to recognize and respond socially to parents and other important people in their lives (Tepperman Curtis, 2011, p.58). AccordingRead MoreDescribe and Assess the Evidence That Socialisation Plays a Major Part in Determining Human Behaviour.1735 Words   |  7 PagesSocialisation refers to the process of learning one’s culture and how to live within it. The process of socialisation involves the transmission of culture from one generation to the next. It is during socialisation that individuals learn the values and norms that play such an important part in shaping human behaviour. Socialisation provides the sk ills and habits necessary for acting and participating within one’s society. Charles Cooley divided socialisation into two stages – primary and secondaryRead MoreThe Role the Education System Has as an Agent of Socialization from the Conflict Perspective.1737 Words   |  7 Pagesinteraction in the work place and the social relationships of the education system.† The education system in today’s society is considered one of the most important agents of socialization apart from one’s family. The education system is defined by the socialsciencedictionary.com (2008) as â€Å"the system of formalized transmission of knowledge and values operating within a given society.† It is stated that the purpose of the education system â€Å"is to transmit values and norms and teaching students to respectRead MoreHeritage Assessment Essay1346 Words   |  6 Pagesreligious affiliation, heritage, family orientation and socialization and most importantly how one prioritizes their cultural uniqueness to their life. In comparison of three families from different cultural backgrounds consisting of Greek, Italian and Hispanic, differences and similarities were found on cultural approaches to health maintenance. One similarity is that culture is central to their health habits. Health Maintenance for all three cultures is very similar based on the extreme importanceRead MoreSocialisation And Its Impact On Children s Learning And Development2834 Words   |  12 PagesAbstract In all over the world children are adapted into different cultures and we know that the cultures differ from place to place. Throughout a person’s phase of life, the reactions of others influence and modify their behaviour at all times. As a child grows, they advance in different areas and different manners. Each parent socializes their child into their own patterns and instils their own values thus beginning the socialization cycle. In this essay there will be discussions on socialisationRead Moreâ€Å"What Are the Most Important Agents of Socialization and How Are They Being Accounted for in Children Lives1423 Words   |  6 PagesIMPORTANT AGENTS OF SOCIALIZATION AND HOW ARE THEY BEING ACCOUNTED FOR IN CHILDREN LIVES† Parents are important agents of socialization but they are not the only source of socialization when it comes to kids. In my paper I will be discussing the important factors of socialization and what we perceive to be a turning point in our children lives. Believe it or not but parents, family, educational institutions, and media are socializing agents who carry out the process of socialization. The familyRead MoreSocial Role of Women in Society1675 Words   |  7 Pagesconflict does not occur. Socialization â€Å"Socialization refers to the way in which we absorb the rules of behaviour which are common in our society† (Abbott 1998:10) Socialization sets out how we should live in accord to our society and its expectations. (McDonald, Bernadette 2006) It is also the process of development of the human being in a social context. Human behaviour is learned primarily through the process of socialization which involves the transmission of culture by language and gesture andRead MorePolice Department, Beliefs, Attitudes, And Behaviors1678 Words   |  7 PagesIn every police department, beliefs, attitudes, and behaviors are strongly influenced by its culture. This culture is primarily developed through a process of socialization, or beliefs, attitudes, and behaviors learned in interactions with peers and on the job experiences. Socialization has led to both an executive and police officer culture, each with its own perspective of the dilemma of means and ends. Police executives mus t, by necessity, be as concerned with the means of getting the jobRead MoreCross Cultural Psychology And Social Psychology1723 Words   |  7 Pagesof relationships between cultural context and human behavior (Berry, Poortinga, Breugelmans, Chasiotis and Sam, 2011, p. 2). Research in the area of cross-cultural psychology is aimed at comparing specific covert and overt behaviors of two or more cultures. More specifically, cross-cultural psychology examines the â€Å"†¦similarities and differences in psychological functioning in various cultural and ethnocultural groups†¦Ã¢â‚¬  (p. 5). Henceforth, cross-cultural psychology offers a viable paradigm for the

The Impact of Stress on Health Essay - 1517 Words

(AC 1) Stress is defined as the state when people are experiencing difficulties in coping with the situations they are in due to the lacking of abilities or knowledge to handle them (Anxiety UK, ND). These situations are often referred as stressors. The way how individuals are reacting to these stressors is referred as stress response. Stress does not directly causes infections or ill-health to a person. Instead, the products produced in the process of stress interfere with the usual operations of the immune system. Numerous studies have proved that stress has an immunosuppressive effect, which means the functions of the immune system is reduced when an individual is experience stress (Gross et al., 2008). Corticosteroids are initially†¦show more content†¦Major life changes such as getting married and getting pregnant due to the drastic change to the daily routines and in order to overcome these changes, the individuals might need to readjust their priorities and lifestyle. Another reason why major life changes cause stress is often these changes put individuals in situations that they might have less or no control of, for example, infertility and disabilities. Another common cause of stress is looking after relatives with long-term illnesses or disabilities. This type of stress is often chronic. If the c arers provide constant high level of care, they are more likely to become ill or even disabled according to Carers UK (2012). This is because they often do not have enough rest and they may have given up their previous lifestyle to care for their relatives, therefore, they are more likely to experience stress and this may lead to depression and emotional breakdown. (AC 3) The General Adaptation Syndrome (GAS) is a theory introduced by Hans Selye. There are behavioural, cognitive and physiological features in each stages of GAS. The physiological aspect of the individuals dominates the alarm stage. Due to the release of hormones such as adrenaline, they stimulate different changes in the body such as increase heart rate and blood pressure in preparation of the body to ‘fight or flight’ the situations. However, if the person cannot cope with the changes in their body, this could be fatal as it may cause shock orShow MoreRelatedThe Impact of Stress on Health Essay2044 Words   |  9 Pages   Ã‚  Ã‚  Ã‚   People seeking a higher education are under extreme stress and dont even realize it. They are dealing with the high cost of a college education and are being pressured to quickly get through college and into the workforce. Many students are working extra jobs to help pay for their tuition while still taking a full load of courses. They have their time and resources stretched so thin that they find it hard to manage college life. Many people attending college are suffering from poorRead MoreThe Impact of Mental Illnesses and Health Problems from Work-Related Stress on Employees in Office Jobs2507 Words   |  10 PagesThe Impact of Mental Illnesses and Health Problems from Work-Related Stress on Employees in Office Jobs Introduction Year after year a behavioral change began to impact her life; she became irritable, fatigued and gained almost fifty pounds. She was no longer fun to be around and isolated herself away from everyone. Her kids would ask if she was okay and knew something was wrong. The work-related stress and harassment she received from her bosses triggered symptoms of depression. The job tookRead MoreReflection Paper On Stress1134 Words   |  5 PagesStress is one of the leading causes of depression in the United States. If stress is not handled right away it can become distress. Many things in our daily life cause us to feel stressed such as work, school, or major change that took place in your life. Stress can impact your emotions, attitude, and health. In this paper, I will be addressing how stress has impacted my life, how stress effects the body, the signs of stress, and what strategies we can use to reduce stress in our lives. The stressRead MoreThe Relationship Between Stress And The Effect Of A College Student s Health1357 Words   |  6 PagesAbstract The following is an experimental proposal that exams the relationship between stress and the effect of a college student’s health. The following hypotheses for the study is that stress does affect an individual’s health. The study consisted of thirty college students (n=30) in total, fifteen of these students (participants) were assigned a control group while the remaining fifteen students were put in an experimental group. The researchers recorded the results of each college student’sRead MoreThe Effects Of Poverty On Childhood Development924 Words   |  4 Pagesthe relationship between poverty, lower socioeconomic status (SES), and childhood development. While poverty can be directly linked to negative developments in terms of health status it is also indirectly linked to other important factors such as; mental health, physiological wellbeing and education, all of which have major impacts on childhood development which can also be transferred into adulthood . This essay aims to evaluate the literature available on the effects of poverty on childhood developmentRead MoreAnnotated Bibliography on Stress1762 Words   |  7 Pagesdefinitions of stress and how to cope with it, known as stress management. Stress affects health in a number of ways. It is defined by James (2011) as pressure or tension that comes in many shapes and forms and furthermore the body and mind in particular reacts psychologically and even emotionally. How Stress Affects Health This can affect how an individual feels, think and behave. Signs and symptoms can include sleeping problems, loss of appetite and difficulty concentrating. Stress can usually causeRead MoreEvidence Based Intervention Essay826 Words   |  4 Pagesat the school, class-wide, and individual student-level, and are often either academic or behavioral in nature. Overall, implementation of both universal (i.e. class-wide) and targeted (i.e. student-level) interventions have demonstrated positive impacts on decreasing disruptive behaviors and increasing student academic achievement (Flower, McKenna, Bunuan, Muething, Vega, 2014; Vannest, Davis, Davis, Mason, Burke, 2010).Ross, Romer, and Horner (2012) also found that teachers in schools implementingRead MoreThe Social And Physical Environment Of College Students831 Words   |  4 Pagesor study abroad opportunities. However, most of these students do not considered how this radical change in their social and physical environment can mak e an impact on their mental health. According to the National Alliance on Mental Health (2012) â€Å"More than 40 percent of college students have felt more than an average amount of stress within the past 12 months.† College requires significantly more effort from students than high school. Students are expected to put on heavy class loads, have aRead MoreThe Social Determinants Of Health1623 Words   |  7 PagesStress has been identified as one of the social determinants of health. It has different meanings in various contexts, so a proper definition will give a good insight of the term.   Ã‚  Ã‚  Ã‚  Stress can be defined as a state of emotional or mental disturbance resulting from adverse or demanding conditions.   Ã‚  Ã‚  Ã‚  Stress can also be defined as a physical, chemical, or emotional factor that causes bodily or mental disturbance and could be a causal in disease formation. StressesRead MoreThe Impacts of Occupational Stress Essay946 Words   |  4 PagesOCCUPATIONAL STRESS AND ITS IMPACTS NAME INSTITUTION Introduction Work place or occupational stress refers to any form of restrain that is experienced when there is no match between job demands and the output of the worker. The article ‘Occupational stress’ aims at showing ways in which stress people get from their work place affect them and what causes the stress. This condition may encompass many conditions that include maladaptive behavior, psychological disorders

Morality Is The Correct Definition From Definition

Many people have many ideas of what morality is. Most of the time morality is what makes a person make good choices therefore having good morals. But what is morality really? This essay will work to define morality as the correct definition from definition.com, also defining it as what different religions think about morality. We will also see if people who execute their morals, and if it is an advantage over other people. The definition from definition.com is of, relating to, or concerned with the principles or rules of right conduct or the distinction between right and wrong; ethical:. People in this world especially in today’s age seem to lack morals. And most of the fault goes to the parents when a child is young. Parents today seem to take kids misbehaving as funny a child says a bad word and the parents there are laughing recording. We all know of a time that if someone said a bad word you were going to get it and u would not forget it next time she/he was about to cuss. When a child is young from 3-13 they tend to absorb everything they see or hear children tend to be sponges. If a child is told to do something for the vine they will do it and after that keep doing it even if the parent tells them not to anymore. But what are these most people say that it just being good but it goes more in depth than that. These are some of the ethics that go hand to hand with morals, Have integrity, H ave courage of conviction, Stand up for what is right, Do what you say you willShow MoreRelatedThe Argument On The Euthyphro Argument1554 Words   |  7 PagesOn the Euthyphro Argument SN. 35372119 It is a general belief of theistic viewpoints that morality must inevitably be tied directly to a God or gods, and that the lack of such a supernatural being results in a lack of morality. This then lends an arbitrary nature to morality, and a sense of pointlessness. If there is no supernatural being, no afterlife, no one to please, why would there be a reason to morality at all? The question can then be raised if one is moral in doing a moral act for a rewardRead MoreEssay on Staces Views on Freewill732 Words   |  3 Pages Freewill Through the Eyes of Stace I can most relate with Stace’s views on freewill. I feel that the freewill argument is more about definition and the word’s true meaning. I also agree with his statement of, â€Å"if there is no free will there can be no morality.† Stace believes that is doing what we want to do and not being constrained from doing so. Morality is a good argument of why we do what we do. Then there is the idea that we have choices and choices are made by the individual and not by outsideRead MoreThe Prevailing Message Throughout Sophocles Antigone And King s Letter From Birmingham Jail1251 Words   |  6 Pagesand King’s Letter from Birmingham Jail is that civil disobedience serves the purpose of fighting and correcting injustice in situations where systemic breaks in adherence to natural law occurs. Injustice here as used here is not to be synonymous with things that are simply unlawful or unfair, but instead takes on a deeper and more specific definition pertaining to the natural moral codes that all laws, as argued by King and Antigone, ought to be based upon. It is by this definition that both AntigoneRead MoreEuthyphro, A Dialogue Written By Plato1099 Words   |  5 Pagesseries of questions from Socrates regarding what piety is. Euthyphro’s answers continuously contradict one another, and he cannot create a definition. Euthyphro makes reference to the Gods when stating a definition, which leads to the questions, is Euthyphro a theological voluntarist? After examining the claims of Euthyphro and the definition of theological voluntarism, it will become apparent that Euthyphro is not a theological voluntarist. This paper will first explain the definition of theologicalRead MoreThe Dilemma Of The Euthyphro Dilemma1739 Words   |  7 Pagesthus God can never will anything other than what is good. The Dilemma origins from Plato’s Dialogue the Euthyphro (10a) in which Socrates poses this question to Euthyphro: â€Å"Is the pious or holy beloved by the gods because it is holy or holy because it is beloved of the gods†. In other words, â€Å"Is a good thing good because God desires it? Or does God desire it because it is good† (in reverse to original). The first horn (from original dilemma) presents God as a good-tracker; that God wills certain thingsRead MoreTorture and Ethics1604 Words   |  7 PagesTorture and Ethics Paper Alfreepha Williams AJS/532 July 21, 2013 Patricia DeAngelis Torture and Ethics There are many views or definition of the word â€Å"torture†, which is often debated by many individuals. According to â€Å"International Rehabilitation Council For Torture Victims† (2005-2012), â€Å"torture is an act by which severe pain or suffering, whether physical or mental, is intentionally inflicted on a person for such purposes as obtaining information or a confession, punishing him for anRead More Thrasymachus Perspective on Human Nature Essay1298 Words   |  6 PagesThrasymachus Perspective on Human Nature Thrasymachus perspective of human nature is that we all seek to maximize power, profit and possessions. He gives the argument that morality is not an objective truth but rather a creation of the stronger (ruling) party to serve its own advantage. Therefore definitions of just and unjust, right and wrong, moral and immoral are all dependent upon the decree of the ruling party. Thrasymachus argues that acting morally, in accordance withRead MoreAnalysis Of Wolf s The Meaning Of Lives Essay1619 Words   |  7 Pagesmeaning in one’s life. I will examine her view, then critically discuss the positive attributes and the shortcomings. Wolf does a sufficient job to outline a possible way to achieve meaning. However, I will argue that a definition for the meaningful life that does not include morality and happiness is not sufficient. Lastly, I will express the subjective and objective tension that weakens her stance. Wolf’s Argument The author brilliantly uses contrasting examples of what meaning is not to extractRead MoreGod Vs. Morality?1113 Words   |  5 PagesKalee M. Ewald Professor Mark Kelley PHIL101 18 October 2015 God vs. Morality While going over the topic I chose, other questions came to mind like: does God exist? What exactly is murder? What does Moral mean? Can morality be based on other standard than the belief in God? With that, can individuals with conflicting religious beliefs resolve a dispute over what morality is? In my assessment I will argue that morality has no specific meaning other than that it is the cultural standard or customRead MoreWhat Is Stace s Position On The Problem Of Free Will And Casual Determinism Are Compatible1258 Words   |  6 Pageswanted to prove that the hard determinist definition of â€Å"free† was incorrect. He posed that free does not mean random, but that our acts are casually determined in a particular fashion. There must be a deterministic or causal connection between our will and our actions. This allows us to take responsibility for our actions, including credit for the good and blame for the bad. First, Stace presents is that if there is no free will then there is no morality. If a person is not free to choose what they

Relational Database Implementation Report on Basketball Tournament

Question: Relational database implementationYou must implement the entity relationship model provided in the model solution to Assignment 1. The model solution will be released on the course website approximately TWO (2) weeks after the Assignment 1 due date.The recommended tool for this assignment is Microsoft Access, version 2003 or later. One reason for recommending Microsoft Access is that your course lecturer will be able to provide support in the use of this tool. If you choose to use a different DBMS, then there is no guarantee that your lecturer will be able to provide support. Note: If you choose not to use Microsoft Access, you must contact your lead lecturer as soon as possible before you start work on the assignment. The remainder of this document assumes you are using Access.In implementing the ERD provided, you must complete the following tasks: Map the ERD into a set of relations in at least Third Normal Form (3NF). You must ensure that your relations meet 3NF. There is no need to show your working. Select any two (2) of your relations from the previous step and for each of them: List all the functional dependencies present in the relation Demonstrate that the relation meets Third Normal Form (3NF), for example: STUDENT (StudentID, Name, Address, DateOfBirth)The primary key is StudentID; this is the only candidate key since Name is not guaranteed to be unique (two different students may have the same name). Address is also not guaranteed to be unique. There will be one student name per Student ID, since only one name is recorded for each student. There will be one address per Student ID; even though a student may have multiple address (e.g. a home address and a work address), the case study states that there is only a need to record the home address. There will be only one date of birth per Student ID. This means that Student ID functionally determines every other attribute in the table; therefore there are no repeating groups. There is a single simple can didate key, therefore no partial dependencies are possible. Name cannot be used to functionally determine any other attribute in the table since two different students may have the same name; likewise for address and date of birth, therefore there are no transitive dependencies in the table. Therefore it meets the requirements of first, second and third normal form. Create all the relations in a Microsoft Access database. Consider each attribute in every table and make appropriate choices regarding data types and sizes, indexes, required/not required, and validation rules. Your choices should be appropriate for each attribute and should support data integrity. (Note: see the Data Integrity section below for specific data integrity requirements.) Create relationships as appropriate. Enforce referential integrity for all appropriate relationships in the database. Explore the possibility of cascade update and/or delete options. Review the default indexes created by Access for each tabl e. You should ensure that the indexes follow the guidelines given in the set textbook. Populate the database with sample data. You must include sufficient sample data to test your queries and report(s). You should aim for at least 5 or 6 rows in every table. Please note that the expected result of query questions may depend on the actual sample data populated.Data integrityYou are required to implement integrity constraints within the database to enforce the following requirements:For the table Coach: All fields must be entered. BlueCard number must be an 6-digit number. Contact phone cant be null.For the table PlayedIn: All fields must be entered. The only valid values to indicate the match outcome must be won, lost, or draw. Score cant be null.For the table Earning: All fields must be entered. Prize must be not less than $100. Information requestsCreate queries to answer the following information requests. Note: Do not use the Access query builder (QBE) to create your queries you should type the queries manually using SQL view.Although it is optional to justify the effectiveness of your SQL statement for the request, the marking process of MS Access queries for information requests may also consider your justification of the effectiveness for your queries in the implementation report if you provide them. (Expected results using sample data for queries depend on your actual sample data populated in the database . The following results of queries are only examples. It is important that your implementation must reflect the correct business logic.)1. How many matches did each tournament have? Show the tournaments title and start date, as well as the number of matches of each tournament. Title StartDate NumOfMatch 2011 Challenge Cup 1/03/2011 2 2012 Telstra Cup 2/01/2012 2 2013 CQU Cup 5/01/2013 11 2. Which referee has umpired more than 5 matches? Show the referee name, contact phone and the number of times he/she has umpired. Q2- Query FirstNameLastName Phone NumRef Grace Duke 4908798 6 3. Which team never won any matches in the tournament titled 2013 CQU Cup? List the team name and the number of matches played. Q3- Query Team Name Num Played Glenmore 3 Helios 4 NorthStar 2 4. John would like to know the efficiency of each stadium used in the tournament held in 2013. For each stadium, show the stadium name, address, facility description and the number of matches. Order the result in ascending. Q4- Query StadiumName Street City State PostCode FacilityDes NumMatches Rocky Sport 17 Farm street Rockhampton QLD 4702 Various fields for different 2 Center sports Fun Sports Club 76 Lavdar ave. Rockhampton QLD 4700 Limited seat for viewer 2 Telstra Stadium 19 North Road Rockhampton QLD 4700 Rugby and basketball fields 3 CQ Basket 202 Harris road Rockhampton QLD 4701 Basketball field only 4 Center 5. Find out the details of the team which has won the highest prize so far. The details include the team name, founded date, the name of coach, the amount of prize and the tournament title for which the team won the highest prize. Q5- Query TeamName FoundedDate CoachName Prize Title Leopard 10/11/2002 Kim Jackson $5,000.00 2012 Telstra Cup 6. Find out the sponsor names who have sponsored the total amount more than $10,000 so far. Q6- Query SponsorName Total CQU $11,000.00 Education Queensland $11,000.00 Answer: Report on Basketball Tournament Database Functional Dependencies in two Relations Two relations Tournament and Match are being described here. Following is the structure of Tournament table- Tournament (TournamentID, Title, StartDate) Title TournamentID There is possibility that two tournaments can have same title, therefore title functionally depends upon TournamentID. StartDate TournamentID There is possibility that two tournaments start on same date, therefore StartDate functionally depends upon TournamentID. Following is the structure of Match table- Match (MatchID, StartDateTime, RefereeID, TournamentID) StartDateTime MatchID There is possibility that two matches may start at same date time at different stadium, therefore StartDateTime functionally depends upon MatchID. RefereeID MatchID There is possibility that the referee works for different matches, therefore RefereeID functionally depends upon MatchID. TournamentID MatchID There may be more matches in one tournament; therefore TournamentID functionally depends upon MatchID. (Janalta Interactive Inc. 2015) Demonstration of Normalisation in two Relations All relations in the database are in 3 NF form because all are following the rules of 3 NF form. The third normalization form is satisfied in the relations in the database by following the following rules- 1. There is not any column which is duplicate in any table.2. There are different tables related to different data.3. There is relation in all related tables.4. All the columns depend upon the primary key. The Tournament and the Match relations will demonstrate the 3 NF form The table Tournament has the primary key TournamentID and all the fields depend upon the TournamentID. It uniquely identifies the record in the relation. Every field except TournamentID cannot be unique in the Tournament table. Therefore there is only one candidate key and there is no partial dependency in the relation and the relation Match references the TournamentID of the relation Tournament. It enforces the referential integrity for the relation Tournament. The relation Match has the primary key MatchID. All the other attributes are dependent upon the MatchID. Every field except MatchID cannot be unique in the Match table. Therefore there is only one candidate key and there is no partial dependency in the relation. All the other relations are also satisfying the above 3 NF form rules as per the above two relations. (teach-ict.com n.d.) (About.com 2015) 1. SELECT Tournament. Title, Tournament. Start Date, count (MatchID) AS Num Of MatchFROM Tournament INNER JOIN [Match] ON Match. Tournament ID=Tournament. Tournament IDGROUP BY Tournament. Title, Tournament. Start Date;2. SELECT Referee.FirstName, Referee.LastName, Referee.Phone, Count(Match.MatchID) AS NumRefFROM Referee INNER JOIN [Match] ON Referee.RefereeID = Match.RefereeIDGROUP BY Referee.FirstName, Referee.LastName, Referee.PhoneHAVING Count(Match.MatchID)5;3. SELECT TeamName, count(PlayedIn.MatchID) AS NumPlayedFROM Tournament, Team INNER JOIN PlayedIn ON Team.TeamID=PlayedIn.TeamIDGROUP BY Team.TeamName, Tournament.Title, PlayedIn.OutcomeHAVING Tournament.Title='2013 CQU Cup' and PlayedIn.Outcome='lost';4. SELECT distinct StadiumName, Street, City, State, PCode, FacilityDescription, count(Stadium_Match.MatchID) AS NumMatchesFROM [Match], Stadium INNER JOIN Stadium_Match ON Stadium_Match.StadiumID=Stadium.StadiumIDGROUP BY StadiumName, Street, City, State, PCode, FacilityDesc ription, Match.StartDateTimeHAVING year(Match.StartDateTime)= 2013;5. SELECT Team.TeamName, Team.FoundedDate, Coach.FullName, Earning.Prize, Tournament.TitleFROM (Tournament INNER JOIN (Team INNER JOIN Earning ON Team.TeamID = Earning.TeamID) ON Tournament.TournamentID = Earning.TournamentID) INNER JOIN (Coach INNER JOIN Coach_Team ON Coach.CoachID = Coach_Team.CoachID) ON Team.TeamID = Coach_Team.TeamIDWHERE Earning.Prize=(select max(Prize) from Earning);6. SELECT SponsorName, Amount AS TotalFROM Sponsor INNER JOIN Sponsoring ON Sponsor.SponsorID=Sponsoring.SponsorIDWHERE Amount10000; Limitations in the Assignment Some points are missing in the assignment. For example 1. The queries of outer joins are missing in the assignment.2. There is lack of complex queries in the assignment.3. There is lack of creating the forms in the assignment. Learning during the Assignment 1. The assignment is giving the complete working knowledge about database. After completing this assignment, I learn more about the reports, queries and integrity constraints of MS Access. 2. The queries are very useful for general database. I am feeling very confident now in database. 3. There are hints given for the report in the assignment, I found the right way to create the report by the given hints. Therefore I did not go in the wrong direction to create the report. References [1] Janalta Interactive Inc. 2015, Functional Dependency, Viewed on 15th Jan 2015 https://www.techopedia.com/definition/19504/functional-dependency [2] About.com 2015, Third Normal Form (3NF), Viewed on 15th Jan 2015 https://databases.about.com/od/administration/l/bldef_3nf.htm [3] teach-ict.com n.d., Third Normal Form, Viewed on 15th Jan 2015 https://www.teach-ict.com/as_a2_ict_new/ocr/AS_G061/315_database_concepts/normalisation/miniweb/pg9.htm