Free Essay

Functional Dependence

In:

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 (etc)
Course (etc)
StudentActivity (etc)
StudentCourse (StudentNum, CourseNum)

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

Similar Documents

Premium Essay

The Roles of Hr

...have a human resource deparment. All HR deparments have roles that play for the organization regardless of the type and size. The purpose of the human deparment is to assist the human portion of the company. Its imporant that each organization has a HR deparment that is effiecient and has great quality this benefit the organization is varies ways. The functional roles of the HR deparment are very important towards the human because human are known to be very important to an organization. (Stringer) A very imporant function of the HR deparment is recruiment. The role of the recruiment function is to make sure that they recruit the right people for the job. (Stringer) They also then have made sure the each person they hired is in the correct job postions based upon their skills and abilities. This is a very important job and has a huge impact on the impact because as long as the employee do their jobs correct the organization will be a success. They also help with the interview process testing the employee abilities that they have for the job. Training the employees for the skills that are required for a job is also a functional role of the HR deparment. They have a trainging specialist that teaches the employees the learning objective and methods they need to do their job correctly. (Stringer) Most time the training is for leadership jobs such as supervisors and managers. They have to provide them with correct resources they need to evaluate an employee. They also teach them...

Words: 543 - Pages: 3

Premium Essay

Fundamentals of Organic Chemistry by Eric Simanek and John Mcmurry (2006,...

...Chapter 14 Summary A substance-related disorder is a condition (such as intoxication, harmful use/abuse, dependence, withdrawal, and psychoses or amnesia associated with the use of the substance) associated with substance abuse, often involving maladaptive behaviors over a long period of time. In order to be diagnosed with substance dependence an individual must display at least three of the following for a 12 month period: development of tolerance to the substance, withdrawal symptoms, persistent desire/unsuccessful attempts to stop using the substance, ingestion of larger amounts of substance, declined life functioning, and persistent use of substance. Substance intoxication, substance withdrawal, substance abuse and substance dependence are the four substance-related conditions that are present in the DSM-IV-TR. Substance intoxication is a type of substance-induced disorder, consisting of reversible, substance-specific, maladaptive behavioral or psychological changes directly resulting from the physiologic effects on the central nervous system of recent ingestion of or exposure to a drug of abuse, medication, or toxin. Specific cases are named on the basis of etiology, e.g., alcohol intoxication. Substance withdrawal is physiologic and psychological readjustments made during discontinuation of use of a substance previously employed to induce intoxication. Substance abuse is a patterned use of a substance (drug) in which the user consumes the substance in amounts or...

Words: 2213 - Pages: 9

Premium Essay

The Relationship Between Life Expectancy at Birth and Gdp Per Capita (Ppp)

...The relationship between Life Expectancy at birth and GDP per capita (PPP) Candidate: Teacher: Candidate number: Date of submission: Word Count: 2907 Section 1: Introduction In a given country, Life Expectancy at birth is the expected number of years of life from birth. Gross domestic product per capita is defined as the market value of all final goods and services produced within a country in one year, divided by the size of the population of that country. The main objective of the present project is to establish the existence of a statistical relation between Life Expectancy (y) at birth and GDP per capita (x). First, we will present in Section 2 the data, from an official governmental source, containing Life Expectancy at birth and GDP per capita of 48 countries in the year 2003. We will put this data in a table ordered alphabetically and at the end of the section we will perform some basic statistical analysis of these data. These statistics will include the mean, median, modal class and standard deviation, for both Life Expectancy and GDP per capita. In Section 3 we will find the regression line which best fits our data and the corresponding correlation coefficient r. It is natural to ask if there is a non-linear model, which better describes the statistical relation between GDP per capita and Life Expectancy. This question will be studied in Section 4, where we will see if a logarithmic relation of type y=A ln(x+C) + B, is a better model. ...

Words: 4204 - Pages: 17

Free Essay

Hci for Illiterates

...Human Computer Interaction Contents 1:Human Computer Interaction .....................................................................................................1 2:User's Classification Based on Literacy .....................................................................................1 2.1:Functional Illiterate .....................................................................................................1 2.2:Absolute Illiterate .........................................................................................................1 3:Interfaces for Absolute Illiterate...................................................................................................2 3.1:Visual Aids..............................................................................................................2 3.2:Audible instructions. ...............................................................................................2 3.3:Easy Navigations.....................................................................................................2 3.4: Text Free User Interfaces. ......................................................................................2 3.5:Combination of Visual and Audible instruction......................................................3 4:Recent Works for Illiterate ..........................................................................................................3 4.1:SmartPhone Application for Farmers ....

Words: 1195 - Pages: 5

Premium Essay

Literacy

...The Night Before An Examination                                            It was the night before my examinations. I was appearing for my matriculation examination, for the third time. Come on, even intelligent people fail their exams too!! It was that “butterflies in stomach” Part-3 once again. Not for me, hah.. am talking about my parents. God knows why they took so much of tension about my exams. I had warned my parents of Diabetes and Ulcers way back, but they would never listen. I even asked them to emulate my carefree attitude when it came to exams, but they were one ignorant lot who would not heed good advice. Anyways, I was cool as a cucumber, because this time I had decided that it would not be the Season Three of some failed daily soap. I had made all fool-proof arrangements to pass this time. My dedication, patience, perseverance and persistence would definitely see me through my exams this time around. Day in and day out, I had sacrificed all my useless activities that kept me unduly busy; computer games, movies, parties, discos.. everything! I gave up everything as soon as the exam time table was announced. All my energy and efforts were now aimed at one single objective: getting the question paper somehow!! Patience is always rewarded, so are genuine efforts and dedication. I was lucky enough to discover a gem of a person in one of my class-mates, whom I revered as my senior, coz he had failed thrice in the same exam. He would have made one hell of a statesman...

Words: 2100 - Pages: 9

Free Essay

Dye Absorbtion of Fabrics

...molecule) to bond with the wool very well. The biggest factor in which the dye bonds to the wool is that hydrogen bonds can form between the OH on the dye and the Nitrogens and Oxygens within the amino acid structure. Silk absorbed very well also. This is because the nitrogens and carbonyls within the polypeptides in the amino acid sequence of the silk fabric. This allows for the Hydrogen bonding between the OH of the dye and the carbonyl and Nitrogens within the polypeptide chain. Also, the polarity of these polar amino acids allow for better dying of the silk fabric. Nylon and cotton were not dyed as easily because not as much hydrogen bonding could occur. Many hydroxyl groups are present on cotton. These are the only functional groups on cotton that can hydrogen bond with the dye. Other than the hydroxyl groups that are present on the cellulose that...

Words: 520 - Pages: 3

Free Essay

Table of Ir Absoprtion

...Table of IR Absorptions Functional Group Alkyl C-H Stretch Alkenyl C-H Stretch Alkenyl C=C Stretch Alkynyl C-H Stretch Alkynyl C=C Stretch Aromatic C-H Stretch Aromatic C-H Bending Aromatic C=C Bending Alcohol/Phenol O-H Stretch Carboxylic Acid O-H Stretch Amine N-H Stretch Nitrile C=N Stretch Aldehyde C=O Stretch Ketone C=O Stretch Ester C=O Stretch Carboxylic Acid C=O Stretch Amide C=O Stretch Amide N-H Stretch Characteristic Absorption(s)(cm-1) Notes Alkane C-H bonds are fairly ubiquitous and 2950 - 2850 (m or s) therefore usually less useful in determining structure. 3100 - 3010 (m) 1680 - 1620 (v) Absorption peaks above 3000 cm-1 are frequently diagnostic of unsaturation ~3300 (s) 2260 - 2100 (v) ~3030 (v) 860 - 680 (s) 1700 - 1500 (m,m) 3550 - 3200 (broad, s) 3000 - 2500 (broad, v) 3500 - 3300 (m) See "Free vs. Hyrdogen-Bonded Hydroxyl Groups" in the Introduction to IR Spectra for more information Primary amines produce two N-H stretch absorptions, secondary amides only one, and tetriary none. 2260 - 2220 (m) 1740 - 1690 (s) 1750 - 1680 (s) 1750 - 1735 (s) 1780 - 1710 (s) 1690 - 1630 (s) The carbonyl stretching absorption is one of the strongest IR absorptions, and is very useful in structure determination as one can determine both the number of carbonyl groups (assuming peaks do not overlap) but also an estimation of which types. 3700 - 3500 (m) As with amines, an amide produces zero to two NH absorptions depending on its type....

Words: 257 - Pages: 2

Free Essay

Review

...Unit 2 Review: Answers: Review for Organic Chemistry Unit Test 2. a) b) c) Write the IUPAC names for the following organic molecules: acetone: propanone d) acetylene: ethyne acetic acid: ethanoic acid e) toluene: methyl benzene formic acid: methanoic acid f) isopropyl alcohol: 2-propanol 3. Be able to use physical or chemical properties to distinguish between organic substances. For example, identify one physical or chemical property you could use to distinguish between the following pairs of organic substances: a) 2-butanol and 2-methyl-2-propanol: • 2-butanol is a secondary alcohol so it will undergo oxidation reactions with [O] to produce butanone (a ketone). An oxidizing agent such as KMnO4 or Na2Cr2O7 will change colour to indicate the reaction • 2-methyl-2-propanol is a tertiary alcohol, so it will not undergo an oxidation reaction with [O]. The oxidizing agent will not change colour b) cyclopentane and cyclopentene: • cyclopentane is saturated while cyclopentene is unsaturated • if bromine in water is added to both compounds, the cyclopentane will not remove the orange colour of the bromine, but the cyclopentene will turn the bromine colourless c) butane and 1-butanol: i) solubility in water: butane is a hydrocarbon so it is non-polar and will not dissolve well in water, while 1-butanol is an alcohol so it is polar and is miscible in water ii) state at SATP: butane is a very short chain alkane so it is a gas a SATP. Butanol, because it is polar, is a liquid at SATP iii)...

Words: 1921 - Pages: 8

Free Essay

Characteristic Ir Frequencies

...|Characteristic IR Absorption Frequencies of Organic Functional Groups | | |Type of Vibration |Characteristic Absorptions |Intensity | |Functional Group | |(cm-1) | | |Alcohol | | |O-H |(stretch, H-bonded) |3200-3600 |strong, broad | |O-H |(stretch, free) |3500-3700 |strong, sharp | |C-O |(stretch) |1050-1150 |strong | |Alkane | | |C-H |stretch |2850-3000 |strong | |-C-H |bending |1350-1480 |variable | |Alkene | | |=C-H |stretch...

Words: 446 - Pages: 2

Premium Essay

Chapter 13 Fundamentals of Management

...Week 13 Case Questions 1. Explain a surgical team as a kind of functional group. What features does it share with most functional groups? What features distinguish it from most functional groups? So if I was to explain a surgical team as a functional team it would have to be this: The doctor accesses the patients, the nurses reassess the patients and confirm what the doctor are doing with them and then the anesthesiologist does the same, so everyone knows that they are on the same page. They all confer with one another to come to a positive outcome to any procedure or project they are attempting. Whereas other groups are just trying to satisfy a customer, surgical teams are having to put their reputations and jobs on the line for their profession. 2. Explain a surgical team in terms of its role structures. What factors might lead to role ambiguity? To role conflict? To role overload? Role Structures: Dr.-Head of surgical team, Surgical Nurse – Pain Management and Dr.’s assistant, Anesthesiologist- pain management Role ambiguity- When one or more are doing practically the same job and neither knows what the other is doing. Role Conflict: When the Dr. is telling the nurse one thing, she/he miss understands tells the anesthesiologist something else. Role overload- When one or more of them think they know more about the procedure than the other and they are not capable of doing more than there job. 3. Explain how surgical team...

Words: 410 - Pages: 2

Free Essay

Kookie

...Chapter 2 : Biological Molecules End of this chapter the student will learn about: a) What is the Functional groups and types. b) Macromolecules a) The build up of covalent bond by condensation or dehydration. b) The brake up of covalent bond by hydrolysis c) The chemical elements of life: a review Functional groups contribute to the molecular diversity of life • The components of organic molecules that are most commonly involved in chemical reactions are known as functional groups. • Functional groups are attachments that replace one or more hydrogen atoms to the carbon skeleton of the hydrocarbon. • Each functional groups behaves consistently from one organic molecule to another. • The number and arrangement of functional groups help give each molecule its unique properties. • The basic structure of testosterone (male hormone) and estradiol (female hormone) is identical. • Both are steroids with four fused carbon rings, but they differ in the functional groups attached to the rings. • These then interact with different targets in the body. Fig. 4.8 • There are six functional groups that are most important to the chemistry of life: hydroxyl, carbonyl, carboxyl, amino, sulfhydryl, and phosphate groups. • All are hydrophilic and increase solubility of organic compounds in water. Functional groups are specific groups of atoms within molecules that are responsible for the characteristic chemical reactions of those molecules. ...

Words: 844 - Pages: 4

Premium Essay

The Human Cost Of An Illiterate Society Rhetorical Analysis

...In the essay, “The Human Cost of an Illiterate Society” written by Jonathan Kozol, published in Reading for Writers, New York 2013, the author discusses the arduous plight of the illiterate American. Mr. Kozol shines a spotlight on the extreme hardships faced by people who lack the ability to read or write. He uses emotionally compelling examples to signify the fear and embarrassment one would face without the basic literacy skills that have become the accepted norms in today’s society. The author argues that illiteracy is a problem affecting one-third of U.S. citizens and that the actual human cost is a terrible price to pay. Mr. Kozol points out that it is time we as a society address and correct this problem. Response: This essay by Mr....

Words: 435 - Pages: 2

Premium Essay

Use Cases

...Running head: ASSIGNMENT 2: USE CASES Assignment 2: Use Cases Lawrence A. Mayo, Jr. Dr. Johnnie E. Drake CIS 210 11/4/12 Abstract Your abstract should be one paragraph and should not exceed 120 words. It is a summary of the most important elements of your paper. All numbers in the abstract, except those beginning a sentence, should be typed as digits rather than words. To count the number of words in this paragraph, select the paragraph, and on the Tools menu click Word Count. Assignment 2: Use Cases A use case is a methodology that is used in system analysis as a means to identify, clarify, and organize system requirements. The use cases has make up of several possible sequences for users to interact with a system of a particular environment that is in relation to a particular goal. There are a group of elements that the use case consists of, these elements in be in either the classes or interfaces category. Use cases give a description of how users will perform tasks. There are two main parts of a use case; the steps a user will take to accomplish a particular task on the ATM machine, and the way the ATM should respond to the user's actions. A use case will begin with a user's goal and end when that goal is fulfilled. A use case will describe the interaction sequence between a user and an ATM machine. Each use case captures the actor (the user of the ATM machine), the interaction (what does the user want to do?), and the goal (what is the user's goal?). Writing...

Words: 1139 - Pages: 5

Premium Essay

Carbon Nanotubes

...Abstract Cancer is a generic term to describe a group of diseases which came in form of uncontrolled proliferation of cells. There are over 200 different types of cancer have been recognized, each of which acquires its name uniquely according to the type of issue the cell originates in. Many cancer victims succumb to cancer not because of the primary tumor, but the systematic effects of metastases on other regions away from the affected site. Therefore many treatment and research aim to prevent the metastatic process at the early period. There are currently many therapies in clinical use, and many advanced technologies that help to achieve better result and nanotechnology is the potential candidate to fight against cancer. Nano-materials such as Carbon-nanotubes (CNTs)1, quantum dot, and dendrimers all have unique properties that can be taken advantage of for diagnosis and treatment of cancer. CNTs have the potential to deliver many types of drug directly to targeted cells and tissues at a much higher efficiency compared to the conventional methods. With the help of many recent discoveries in nanotechnology based materials, determining the toxicity of nanoparticles is also a very important task. Thus, in this review, the experiment aims to explore the biomedical application of carbon-nanotubes with the particular emphasis on the use as oncologic therapeutic agent. Introduction United States holds number 7 in the top ten highest overall cancer rates at 300 per 100,000 of the...

Words: 1186 - Pages: 5

Free Essay

A Journal Critique on the Synthesis of New Derivatives of Resveratrol and to Explore Its Potential Health Benefits

...high-calorie diet lived longer than similarly fed mice not given resveratrol. Resveratrol protected mice fed a high-calorie diet from obesity-related health problems by imitating the effects of caloric restriction (Maddox, 2012). Resveratrol also incredibly lengthen the lifespan of worms, yeast, and some fishes (Adams, 2011). In the experiment, local black grapes were gathered and were classified as Vitis vinifera. The skin was separated from the fruit and was placed in dark, cool area. To avoid oxidation of the plant extract, the steps were done away from direct light. The skin was shaken with ethyl acetate and was kept for 72 hours and was filtered. The filtrate was dried using a rotary evaporator to get one-tenth of its original amount. The functional and phenolic groups present in the resveratrol were tested using standard methods. Aromaticity and the...

Words: 1795 - Pages: 8