Functional Dependence

In: Computers and Technology

Submitted By kokanemc
Words 286
Pages 2
Here is some clarification on functional dependencies.

A functional dependency - if you know X, you can reasonably assume you know Y.
X->Y
X determines Y.
Y is dependent on X

For example: In the database in the Social Security Administration, your SSN relates to your first name and last name.
SSN->Name, Address

For Q11, select logical fields were a functional dependency may exist and create tables In Q11, the studentnum is probably unique.

1. Determine the FDs by selecting the fields in the table and one field may be dependent on another. For example, The studentname is probably functionally dependent on studentnum. Studentnum ( StudentName. Identify dependencies for each field in the problem. 2. Create table based on the dependencies. Remember, you need a primary key for each table. The primary key is represented by the field being underlined.

Functional Dependencies
StudentNum ( StudentName,NumCredits, AdvisorNum, AdvisorName, DeptNum, DeptName
AdvisorNum ( AdvisorName
DeptNum ( AdvisorName
StudentNum, CourseNum ( Term, Grade
CourseNum ( Description

Complete the last two table representations to complete the problem.

Tables
Student (Studentnum, Studentname, NumCredits, Advisornum, DeptNum)
Advisor (Advisorname, Advisornum)
Dept (Deptnum, Deptname)
StudentNum(etc)
CourseNum(etc)

http://faculty.juniata.edu/rhodes/dbms/funcdep.htm

Q12, When you see multivalued dependencies, think of it as an individual may have dependencies to many other tables.
A(B
A(C
A(D

This has to been reflected in your FDs and in your conversion to 4NF.

StudentNum(StudentName
StudentNum(ActivityNum
StudentNum(CourseNum
CourseNum(Description
ActivityNum(ActivityName
Reflect your FDs in the tables listed below.

Complete the last three table representations to complete the problem

Student (StudentNum, StudentName)
Activity…...

Similar Documents

Our Dependence on Computers Is Detrimental

...Modern Computer Systems are Detrimental to our Human Instincts Lenny Miller Post University Dependence on Modern Computer Systems is Detrimental to our Human Instincts With every year that passes, we are becoming increasingly dependent on computers. From the first punch card readers to the iphone 5, computers have had a profound and sustaining effect on humanity. Since computers were first used in the medical field in the early 1960’s, specifically in bio-engineering, the lifespan of the average American has gone up 9.6 years. Computers have essentially shrunk the size of the earth as we know it by aiding us in travel, navigation, communication, and networking. Long gone are the days of months-long voyages and correspondence by pen and paper, taken by ship or horseback. The amount of information made available by computers is vast and practically unending. For these reasons and more, it’s hard to discount the positive impact computers have had on society. However, over-looked in all the praise of computers is the fact that they have eroded our ability to function independently. From math abilities to social skills and the ability to navigate from point A to point B, the negative aspects of computers are starting to outweigh the benefits. Our dependence on modern computer systems is detrimental to our human instincts. How many times in your adult life have you been faced with a fairly simple mathematical equation, such as figuring out a 20% tip on a $50......

Words: 959 - Pages: 4

Addiction and Dependence

...less often and with a more restricted meaning, "dependence" has taken its place in many official formulations. Addiction is a condition that results when a person ingests a substance which may include opiates, alcohol or cocaine or engages in an activity such as gambling that can be pleasurable but the continued use of which becomes compulsive and interferes with ordinary life responsibilities, such as work or relationships, even health. Users may not be aware that their behavior is out of control and causing problems for themselves and others. In 1969 WHO's Expert Committee on Drug Dependence defined it as follows: "A state, psychic and sometimes also physical, resulting from the interaction between a living organism and a drug, characterised by behavioral and other responses that always include a compulsion to take the drug on a continuous or periodic basis in order to experience its psychic effects, and sometimes to avoid the discomfort of its absence. Tolerance may or may not be present" (World Health Organization 1969, p. 61). In 1993 ‘dependence’ was defined in even vaguer terms: ‘A cluster of physiological, behavioural and cognitive phenomena of variable intensity, in which the use of a psychoactive drug (or drugs) takes on a high priority. The necessary descriptive characteristics are a preoccupation with a desire to obtain and take the drug and persistent drug-seeking behaviour .The existence of a state of dependence is not necessarily a generic term of......

Words: 443 - Pages: 2

Functional Assessment

...Comprehensive geriatric assessment is defined as a multidisciplinary diagnostic and treatment process that identifies medical. Psychological and functional limitations of a frail older person in order to develop a coordinated medical management of illness. It requires evaluation of multiple issues including physical, cognitive, affective, social, financial, environmental and spiritual components that influences an older persons by a team of health professionals may identify a variety of treatable health problems and lead to a better outcome. However, it is initiated through the primary care clinician or by a clinician caring for a patient in the hospital setting. The content of assessment varies depending on the settings of care. CGA is not available in all settings due to issues related to the tie required for evaluation, need for coordination of multidisciplinary specialties and lack of reimbursement for some components. Overall elements of comprehensive geriatric assessment includes: Physical Health-This focuses on medication use and the risk for malnutrition, falling, incontinence and immobility. The physical examination seeks to identify specific diseases or conditions for which curative, restorative, palliative or preventive treatment may be available. Special attention is directed towards visual or hearing impairment, nutritional status and conditions that may contribute to frailty and falling or difficulty in ambulation. Mental Health-Cognitive, behavioral and......

Words: 623 - Pages: 3

The Dependence of Persuasion and Leadership in Communication

...MGMT535 Mod 9 – Final Capstone Report The Dependence of Persuasion and Leadership in Communication Michael Mangan Embry Riddle Aeronautical University 3/7/2012 Abstract This Research paper will describe the dependence of theories of persuasion and leadership in the context of successful communication. The three main points of this paper will be an explanation of the theory of persuasion thru a variety of perspectives from resources in the journal community, aspects of the theory of leadership in communication, and then how the two are interdependent upon each other. The outcome of this paper will leave the trainer well informed with an extensive understanding that many theories of communication are separate entities is some aspects but also interdependent on each other to be effectively applied in real world experiences and when instructing communication practices to any audience. Intro In all communication instruction many different professionals have compiled theories that would best organize and apply ways to best communicate to a variety of audiences and situations. Many of these scholars take separate routes when their research shows them a new impact of a strategy that would best suite the application of the new theory they have developed. There are many different theories of communication and all are well derived from the different situations and applications. What many researchers don’t do is to step back and look at the big picture with all......

Words: 1984 - Pages: 8

Functional Organization

...communication, product understanding, profitability management and account planning.” (The Results Companies, 2011) The organizational structures that companies use are The Functional Organization, The Divisional Organization, The Matrix Organization, and The Network Organization. The Results Companies use The Functional Organization. They have used this since they started growing, because of the duties and the departments they can be monitored more efficiently, the lines of communication and decision making are clear. They do not have too many lines of departments where everyone is out of the loop on what other departments are doing. The Organization chart starts with the Site Director at the top, the Training Professional, Program Manager, Recruiter, Human Resources, Sales Manager, Local Resource Planner, and Site IT report to the Site Director. The next level down, which is Team Leaders and Grad School Dean, report to the Program Manager. The LRP Mentor reports to Local Resource Planner, and the IT Mentor reports to the Site IT. The next level is the Mentors, and each Mentor reports to a Team Leader, which they have three Team Leaders, so there is three Mentors. Another Mentor reports to the Grad School Dean. As the company has grown it has changed a little bit of who reports to whom, but they have always used the functional organization. The way this company works so well together is that they keep each department in the know of things to expect and how to do their job.......

Words: 796 - Pages: 4

Ob - Dependence as a Trait

...Dependence Contents 1. Introduction 3 2. Conceptual Framework 3 3. Review of Literature 3 4. Study of the subject and deductions and their extrapolation to a generic case 4 5. Contributions to OB 8 6. Conclusion 8 7. Bibliography 9 Introduction “Like the body that is made up of different limbs and organs, all moral creatures must depend on each other to exist.” – Proverb Quotes Dependence is one of the cornerstones of individual, interpersonal, organizational interactions. It is one of the most important bases on which relationships and bonding are created and nurtured. The son depends on the mother for sustenance and love and many other things. The boss depends on his workforce to give him profits, whereas the workforce depends on him for their salary. Dependence permeates all strata of society and is evident everywhere. The following write up will introspect the various aspects of this trait and come up with relevant inferences. Conceptual Framework Dependence - Relying on or requiring a person or thing for support, supply, or what is needed[1] As the definition clearly states, the quality of dependence is innately interpersonal and hence is evident on every level. The concept finds application in any binary, tertiary or multiple interaction bases...

Words: 2794 - Pages: 12

Alcohol Dependence

...Alcohol Dependence Ashley Nicole Stringer PSY/650 Psychopathology July 14, 2014 Mary Mc Greevy Alcohol Dependence Alcohol dependence is a material associated illness in which a person is hooked to alcohol either mentally or physically, and persists in utilizing alcohol regardless of considerable parts of dysfunction, proof of physical dependence, and an associated difficulty. The word alcohol dependence has substituted alcoholism as a word in turn that people do not suppress the thought of cure and illness, but could consider alcohol as a chemical they might be contingent upon deal with environmental stresses. In order to comprehend this disorder one must first understand just what alcohol dependence is. Then one needs to theorize alcohol dependence employing the biopsychosocial model. And finally it is important to talk about the treatments or interventions that are known to be the most successful for alcohol dependence and why. Once all of this is understood then alcohol dependence can be a little clearer. Alcohol dependence is a growing problem in world and further research is being done to hopefully get this problem under control (Butcher, Mineka, & Hooley, 2013). Description of Alcohol Dependence Around twelve percent of American grown-ups have had an alcohol dependence issue during their lifetime. The word alcohol dependence has substituted alcoholism as a word in turn that people do not suppress the thought of cure and illness, but could......

Words: 1896 - Pages: 8

Alcohol Abuse and Dependence

...Alcohol Abuse and Dependence Correlated with Age, Gender, Ethnicity, and Religion [Name of Writer] [Name of Institute] Abstract This research paper entails the correlation of alcohol abuse with age, gender, ethnicity, and religion. This paper also explains in detail the implication that can be undertaken for the substance abuse. Alcohol is one of the factors that are creating the majority of the health problems in the United States, creating negative impacts on the life of an abuser’s family and children. Alcohol abuse has direct relation to the age, gender, race and religion. Table of Content Abstract 2 Introduction 3 Discussion 4 Age 4 Gender 5 Race 6 Religion 6 Strategies for Prevention of Alcohol Abuse 7 Conclusion 7 References 8 Alcohol Abuse and Dependence Correlated with Age, Gender, Ethnicity, and Religion Introduction In the United States substance abuse is one of the most common health problem that touches life of every individual in the family, child, community, and congregation. In contrast to the popular perception, the problem of substance abuse in the United States not only results in illegal drug usage like crack cocaine, but also in the form of the recreation known as soft drinks such as marijuana, along with the usage of extra medicine use prescribed by the doctors. The influence of substance abuse and alcohol abuse on families, children, and communities are dreadful in a manner like: negligence of family,......

Words: 1498 - Pages: 6

Dependence on Tecnology

...of this research is to persuade and to inform the general public interested in technological impacts and the negative effects it has brought to those who over use it and also to catch, as a desired audience, that part of society blind to such gravity. Even though these new inventions have indeed given us the ease to have almost everything one click or touch away, a dependence on these advances has been developed by their take over, and therefore a harmlessness and ignorance to the possibility of living without it affecting social communication, education, and society’s behavior. SOCIAL COMMUNICATION Just a couple of decades ago, meeting a friend at a café or asking another person for a dance, were two of the most common ways to socialize and to get to know others. In the present, it does not usually happen. Social networks, apps, and date-finding websites have substituted that habit, and now we communicate through machines. In her article, “An Ugly Toll of Technology: Impatience and Forgetfulness”, from The New York Times Digital Edition, author Tara Parker wrote that “Typically the concern about our dependence on technology is that it distracts from our time with family and friends in the real world” (2) because some might pay more attention to their cellphones or other devices than to the actual people around. Text messaging has become a trend, but can people express real emotions through typed conversations, or how are those receiving the message able to interpret......

Words: 1568 - Pages: 7

Man's Dependence on Oil Outline

...Man’s Dependence on Oil: Are Alternative Energies the Answer? Tiffany P. Marin Sci 207: Dependence of Man on the Environment Professor Cynthia Collins February 18, 2013 Introduction The subject of our dependence upon oil has been a topic for debate for some time now. We use it for transportation fuels, heating fuels, and it is the base ingredient for countless products and items, such as asphalt and plastics. The question is whether or not we can completely overcome our dependence upon oil. While alternative energy sources may be able to replace oil in some areas, it will be next to impossible to replace it in all areas. Paragraph One In paragraph one, I intend to discuss the process of refining crude oil and its various purposes. There are many products and items that have oil as a base ingredient. Many are items that most people don’t even realize contain oil. Paragraph Two Paragraph two will include various alternative energy sources that can be used for various purposes, like transportation fuels, heating, etc. Paragraph Three Paragraph 3 will have information on various reasons that alternative energies should be used to replace our dependence upon oil and the products created from it Paragraph Four Paragraph four will be a look at the opposing side of the issue, a rebuttal of sorts. I will explore the reasons that it will not be possible to completely replace oil. Paragraph Five In paragraph five, I am going to explore the middle ground, so......

Words: 373 - Pages: 2

The Effects of the Dependence of Technology on Teens

...The effects of the dependence of technology on teens Cindy Marczak American Intercontinental University April 19, 2015 The Effects of the Dependence of Technology on Teens When it comes to technology we live in a world that has technology everywhere. It can be as simple as someone listening to an mp3 player to listen to music to complex as using a machine to help diagnose illness in the medical world. So growing up with all this technology can cause a lot of teens think that it is normal part of everyday life. So because of this a lot of teens take it for granted and in doing so have lost certain social and academic skills. One of the problems that these teens face is that they lose major academic skills such as knowing how to look up information without a phone or computer. One of the main points of using technology is to help make things easier which it does. But while doing so most kids used to go to the library to study by reading and researching in books. Now it’s totally different with technology you can just type in what you want to find in any search engine and bam there is all your information you could ever need. When there is no internet or signal to use this technology most teens don’t have these research skills that they need. It’s great to do be able to find all this information at once. But a lot of the time they want to find the information and expect it that fast. They have to get everything instant......

Words: 611 - Pages: 3

Does Loyalty Equal Dependence?

...Loyalty = Dependence? In business, marketing has the tightest relationship with customers, the driving force of business. The relationship is based on consumer’s values and satisfaction, making the aim of marketing to identify needs of customers and provide them successfully. Successful marketing campaign results in gaining loyal, satisfied customers, which makes marketing an art of retention and development. Companies strive to maximize profit, which can be achieved by retaining loyal customers. Oxford Dictionary describes loyalty as strong commitment or allegiance. Additionally, in marketing, it means that the customer is not willing to switch to alternatives despite the marketing efforts of the competitors (Keller & Kotler, 2012). Companies need strategies to sustain loyal customers. Many believe that the amount of truth consumers place in companies might be abused, as loyalty sometimes equals strong dependence on suppliers. However, government’s role is to protect their citizens and prevent any actions that might violate ethics, but otherwise, the economy will be better off without intervention, referring to the belief of “Laissez-Faire” (Frank & Cartwright, 2013). The essay will aim to prove that loyalty does not cause overly-dependence if it does not influence ethics, and that consumers will seek for better option for themselves. The rational choice theory, which is the base of the microeconomic studies, states that individuals act rationally and choose the option...

Words: 864 - Pages: 4

Dependence on Technology

...STEVEN WIDO AC1404278 SP180 PRINCIPLES OF PUBLIC SPEAKING ASSIGNMENT 06 Increased dependence on technology in the U.S. A. B. C. II. The technology which surrounds almost everyone in the modern society, affects both work and leisure activities. Technology contains information that many would rather it did not have. It influences minds in good and bad ways, and it allows people to share information which they would otherwise not be able to attain. Even if a person does not own a computer or have credit cards, there is information on a computer somewhere about everyone. The technology which is just now beginning to be manipulated and harnessed is affecting the minds of small children and adolescents in ways that could be harmful. It is affecting our immediate future. It also gives another form of communication and exchange of information which was not available before, information that is both good and bad. Technology is one of the principal driving forces of the future; it is transforming our lives and shaping our future at rates unprecedented in history, with profound implications which we can't even begin to see or understand. Many different elements affect how satisfied we are with our lives. The impact of technology on these elements can change how safe, healthy and happy people feel. Throughout history, people have looked for better ways to meet their needs and to satisfy their expectations. Technology has improved the way people feed, clothe and shelter themselves.......

Words: 341 - Pages: 2

Physical and Psychological Dependence

...Define physical and psychological dependence. Physical Dependency refers to a state of chronic Dependence on a medication or drug resulting from prolonged abuse. The state is characteristically defined by an increase in Tolerance and Dependence in which negative consequences occur despite continued use. It is additionally defined by symptoms of withdrawal when cessation of the drug takes place. Physical Dependence can occur from prolonged use of sedatives, pain killers, or stimulants, but is defined by similar sets of consequences. Psychological Dependence is an emotional need for a drug or substance that has no underlying physical need. For example, people who stop smoking recover physically in a short time. The emotional need for nicotine, however, is much more difficult to overcome. They continually think they need the nicotine to stay calm even though there is no physical need. The drug for the addict is similar to what a security blanket would be for a child (or some adults). Name two type of synthetic opiates and describe how they are typically used. The opium poppy seed plant contains natural pain relieving substances known as alkaloids, according to Princeton University. Natural opiate drugs come from natural opium alkaloids, which include – * Demerol- Demerol is a drug used to control pain and Demerol is also known as meperidine. Demerol is the brand name for meperidine which is a member of the opioids drug class. Other Opioids that are similar to......

Words: 727 - Pages: 3

Functional

...Functional Health Pattern Assessment (FHP) | Pattern of Health Perception and Health Management: * How does the person describe current health? * What does the person do to maintain health? * What does person know about links between lifestyle and health? * How big a problem is financing health care for this person? * Can this person report his/her medications and the reason for taking them? * If this person has allergies, what does he/she do to prevent/manage them? * What does the person know about medical problems in his/her family? * Have there been any important illnesses/injuries in this person’s life? | Nutritional-Metabolic Pattern: * Is this person well-nourished? * How does this person’s food intake compare with recommended food intake? * Does this person have any disease that affects nutritional/metabolic function? | Pattern of Elimination: * Are the person’s excretory functions within normal range? * Does the person have any disease of the digestive system, urinary system, or skin? | Pattern of Activity and Exercise: * How does this person describe his/her weekly pattern of: Activity/Leisure?--Exercise/Recreation? * Does this person have any disease that affects his/her: Cardio/Respiratory System?--Musculoskeletal System? | Cognitive/Perceptual Pattern: * Does this person have any sensory deficits? If yes, are they corrected? * Can this person express himself/herself clearly and logically? * What is......

Words: 455 - Pages: 2