Free Essay

Functional Dependence

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.

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
StudentNum, CourseNum ( Term, Grade
CourseNum ( Description

Complete the last two table representations to complete the problem.

Tables
Student (Studentnum, Studentname, NumCredits, Advisornum, DeptNum)
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 (etc)
Course (etc)
StudentActivity (etc)
StudentCourse (StudentNum, CourseNum)

http://www.cs.jcu.edu.au/Subjects/cp1500/1998/Lecture_Notes/normalisation/mvd.html

Similar Documents

Free Essay

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

...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

Free Essay

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

Functional Managers

...Considering the operational management framework as the business setting, the internal processes of the functional management would be inclusive of the location of the business, logistical aspects of the business and services (Chase, Jacobs and Acquilano, 2006). The administrative position associates itself with the expected actions of the manager in the diverse situational leadership conditions. The leadership position of the managerial responsibility is with the inclusion of managerial training, excellent motivational and public speaking tactics used by top performing managers as a tool to influence the performance of their employees. Most peer-reviewed scholarly journals explain that the functional managers need to ensure that the employees under their command receive accurate training and perform as expected. A decision role of the manager pertains the choices the manager makes regarding leadership given a dilemmatic situation (Daft, 2012). The decisions made impact on the amount of resources the functional manager gets for the project he/she is in-charge. Consequently, the manager has an array of decision-making authority over the other managers in the same referent category. In the practical case, the functional manager has the rule of thumb over the other managers and in some instances; his/her mentorship is be required by the other managers regarding the allocation of resources to finalize projects under their responsibility (Pitagorsky, 1998). The actions taken......

Words: 550 - Pages: 3

Free Essay

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

Free Essay

Increased Dependence on Technology in the U.S.

...Increased dependence on technology in the U.S. In United States just like in other countries of the world, people have become very dependable on technology. Weather it is a phone, or an ipod, or even a computer, people are becoming very obsessive about it. Every time, you walk outside or even drive by a neighborhood, everybody seems to always be on their phones or have their headphones in their ears. It has become an addiction for both children and adults. Young kids today they are constantly on their phones or if they are not on it, they play video games or browsing internet on their computers at home at school. In my freshmen year in college I was watching a movie in Sociology on how technology affects us. For example, in China the teachers in school teach kids how to time ménage their time on computers so once the kids grow up they wont be that dependent of it. I believe it is a very good practice that schools in America should also do. It is very important for little kids to spend less time on the computers or playing video games from childhood so that when they grow up so they will grow up healthy. According to National Safety Council there are at least 1.6 million crashes each year that involve drivers using cell phones and texting (Lane, nsc.org). People who drive feel the need to answer the call or the text because it is an automatic response. So in conclusion, dependency on technology in the U. S is still and will be a big problem. However, I believe...

Words: 328 - 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