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

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

Free Essay

Acc 560

...Activity based Costing (ABC) in Service Industries Activity based Costing (ABC) in Service Industries The Total Gym was developed 1974 by Tom Campanaro and his partners Dale McMurray and Larry Westfall of San Diego CA. The device encouraged “functional exercise” a way of duplicating movements the body performs in everyday life, with and against gravity. The device piqued the interest of Physical Therapists and other medical professional. The total Gym was found to engage all muscle groups, allowing over 100 functional exercises on different levels of inclined resistance. The device also featured a full range of motion and variable resistance levels (heavier resistance near the top and light resistance when more horizontal). The Total Gym is a brand name and product line of exercise machines used for strength training, stretching and Pilates training designed by EFI Sports Medicine Inc. of San Diego, Ca. The various models are manufactured for 3 different types of customers: Medical and Fitness Facilities and Home Consumers (“History of Total Gym”. 2013). Total Gym is the world’s leading privately-held manufacturer of functional and bodyweight training equipment. Founded in 1974, the San Diego-based company’s Total Gym products are used in 14,000 physical therapy clinics, athletic training facilities, hospitals, universities, professional sports teams and health clubs, inspiring over 24 million workouts per year worldwide. Total Gym has a 15-year relationship with...

Words: 828 - Pages: 4

Free Essay

Pt1420 Unit 1 Research Ass 1

...| Exploring Programming Language | Unit 1 Research Assignment 1 | | | 5/3/2014 | PT1420 | The five most popular programming languages in the 1970’s were: 1970: Pascal 1972: C 1972: Smalltalk 1972: Prolog 1973: SQL Pascal The Pascal programming language was developed by Niklaus Wirth. It was created in 1968 but it wasn’t published until 1970. It was developed to provide the features other programming languages didn’t offer at that time. His main reason for developing Pascal was efficiently implement and run, to allow for the development of structured and well organized programs, and to serve as a tool to teach the important concepts of computer programming. The program was named after a mathematician named Blaise Pascal. It was used as the primary language in the Apple Lisa and for the Mac in the early years of the computer. SQL SQL, which is short for, Structured Query Language, was designed by an IBM research center in 1974-1975. The Oracle Corporation introduced it as a commercial database system in 1979, the first time it was introduced. It has been a favorite query language for the use of database management systems for the microcomputer and mainframes, but is being supported by the PC database. C C was created at the Bell Laboratory in 1972 by Dennis Ritchie. It was created for the purpose in designing UNIX. Prolog Was created from 1971-1973 and was distributed in 1974-1975. It was created not as a programming language on purpose but...

Words: 988 - Pages: 4

Free Essay

Functional Decomposition

...Section 4.3 Switching Algebra Functional Decomposition Alfredo Benso Politecnico di Torino, Italy Alfredo.benso@polito.it Why? Goal: • Translate a large and complex circuit into a network of small and simple circuits • Express a switching function of n variables as a composition of switching functions of less than n variables Motivation: • Reduce the complexity of simplification • Reduce the size of a circuit by finding common circuit elements Theoretical background: • Shannon’s Expansion Theorem (SET): – Simple type of decomposition – f(x1, x 2, ..., xn) = x 1f(1, x 2, ..., xn) + x’1 f(0, x 2, ..., xn) 1 Residues • The function that is obtained from setting one of the variables, say xi, equal to 1 is called xiresidue. If xi is set to 0, the resulting function is called xi’-residue. • The notation for the xi–residue function is fi(1); for the x’i–residue is fi(0). Boolean Difference • The “Boolean Difference” (or Boolean Derivative) indicates whether f is sensitive to changes in the value of xi and is defined as: ∂f = fi (0) ⊕ f i (1) ∂xi Example • f(w,x,y,z) = wx + w′ z′ , find values of x and z to sensitize circuit to changes in w. fw = x , fw′ = z′ ∂f = z′ ⊕ x = z′x′ + zx ∂w z=x=1 o r z=x=0 will sensitize circuit to changes in w 2 Simple Disjoint Decomposition Definition: • A switching function f(x1, ..., xn) is functionally decomposable iff there exists switching functions G and H (simple) x1 f xn A G B H where A ∪ B = {x 1...

Words: 596 - Pages: 3

Free Essay

Ehhfhcb

...Acetate buffer pH 4.5 23.469 0.098 Phosphate Buffer pH 6.8 23.350 0.093 7.1.3: Physical properties Table 7.3: Physical Evaluation of Aspirin Physical properties Observations Bulk density(gm/mL) 0.682 Tap density(gm/mL) 0.883 Carr’s index (%) 22.72% Hausner’s ratio 1.29 7.1.4: Fourier transforms infrared (FTIR) Spectroscopy The IR spectrum of the pure Aspirin sample was recorded by FTIR Spectrometer is shown in Figure 7.1 which was compared with standard functional group frequencies of Aspirin as shown in Table 7.4 Table 7.4: Reported and observed IR frequencies of Aspirin Functional groups (Observed Frequency) (cm-1) (Reported Frequency) (cm-1) O-H-(Stretch) 3350.00 3100-3500 O-H stretch from CO-OH dimer 2991.59 3200-2800 Aromatic C-H stretch 3015.99 3150-3050 Aliphatic C-H Stretch 2898.28 2950-2850 -C=O stretch 1695.82 1700 Aromatic C=C stretch 1548.73 1600-1500 Aromatic C-H bending 713.46 600-850 The Functional group frequencies of Aspirin were in the reported range which indicates that the obtained sample was of Aspirin and was pure. Figure 7.1: FTIR spectrum of pure Aspirin 7.1.5: Differential scanning calorimetry (DSC) The DSC spectrum of pure drug was obtained and is given in Figure 7.2....

Words: 332 - Pages: 2

Free Essay

Whatever

...Draw the structures and name the compunds according to the IUPAC nomenclature for: i) straight chain and branched alkenes (parent chain ≤ C10) ii) cyclic alkenes (C3-C6) iii) simple dienes (C4-C6) 2 Learning Outcomes At the end of this topic, students should be able to: c) Show the preparation of alkenes through: i) dehydration of alcohols ii) dehydrohalogenation of haloalkanes d) Write the mechanism for c(i) e) State Saytzeff’s Rule. f) Deduce the major product of elimination reaction. 3 Alkenes - General formula CnH2n , n  2. - Functional group  C=C double bond - Unsaturated hydrocarbon - C═C  1 σ bond and 1 π bond A B C=C A B Restricted rotation of carbon-carbon double bond causes cis-trans isomerism 4 Alkenes Cycloalkenes - General formula CnH2n-2 - Isomeric to alkynes CnH2n-2 Example : C4H6 CH2 CH CH2 Functional group isomerism CH CH3C – CCH3 5 Alkenes Common Names Of Alkenes Many older names for alkenes are still in use … example: CH2 CH3 CH2 ethene  ethylene CH2 CH CH3 CH2 2–methylpropene  isobutylene CH3 CH3 propene  propylene C CH3 C CH CH2 2–methylbut-1,3-diene 6  isoprene Alkenes IUPAC Nomenclature 1. Determine the parent name by selecting the longest chain that contains the double bond and change the ending ‘-ane’ in alkane to ‘-ene’. 2. When the chain contains more than three carbon atoms...

Words: 555 - Pages: 3

Free Essay

Illiteracy a Challenging Problem in Our Society Today.

...ILLITERACY A CHALLENGING PROBLEM IN OUR SOCIETY TODAY. CHE DIVINE AFOH STRAYER UNIVERSITY PROFFESSOR; AUDREY. L. VAUGHAN AUGUST 16TH 2015. Even though we search how to solve the problems of illiteracy, illiteracy is a serious problem in pour society today because illiteracy causes high rate of unemployment, high crime rates, health issues and loss of talents inbuilt in our youths leading to low self-esteem. Illiteracy is a pressing concern especially for poor countries, it affects all other aspects of life and personal behavior of the uneducated one. There are several causes which may lead someone to be uneducated or to escape from school. In this essay I will discuss some causes of illiteracy and its effects on our society, and how we can treat it. Illiteracy is a global problem we are facing in our society today of which it greatly affects all our day to day life activities. I will first start with the problem unemployment in which one of the reasons for this is the high illiteracy level in our society. Unemployment is a situation where youths and the general population are unable to get jobs to meet up with their day to day responsibilities and bills. When people are not able to read and write...

Words: 934 - Pages: 4

Premium Essay

Arial

...Answer Briefly: 1. (a) Define the following. Saponification Functional Group Isomerism 2. Explain how will you prepare following. Carbolic Acid from Benzene Acetaldehyde from acetylene Acetal from formaldehyde 3. What are phenols? How are they classified? Explain why phenols are acedic in nature. 4. What are Organometallic compounds? How will you prepare the following from methyl magnesium bromide. Vinegar Isopropyl Alcohol Ethane 5. Draw the structures and give the I.U.P.A.C names of the following. Vinyl Chloride Neo-pentae Tert-butyl methyl ether Picric acid 6 . What product or products are formed when the following compound is nitrated. Bromo Benzene Nitro Benzene 7 . What is methylated spirit? Give its composition. 8. Partial hydrogenation of 2-Butyne forms two geometrical isomers. Write the equation and the condition necessary to obtain these isomers. 9. –COOH and –CN groups deactivate the benzene ring. a. Which property of these groups causes this deactivation? b. Giving a suitable example compare the directive influence of –NO2 and –Cl group, when attached with benzene. (OR) Benzene is a highly unsaturated compound, but it does not give addition reaction with bromine even in the presence of Lewis acid. Name and explain the process which gives this extra stability to benzene. Q.10 . a. In the preparation of alkyl halides from alcohols SOCl2 is the best reagent...

Words: 492 - Pages: 2

Free Essay

Forex Analyst

...ANALYSIS OF PROGRAMMING LANGUAGE PARADIGMN BY GROUP 4 (M. Sc.) CSC 801 PROGRAMMING LANGUAGE PARADIGMNS TERM PAPER SUBMITTED TO THE DEPARTMENT OF COMPUTER SCIENCE, UNIVERSITY OF LAGOS, AKOKA June, 2015. ABSTRACT This is a survey on the programming languages paradigm: Imperative, Scripting, logic, Functional, object oriented and Markup. Our survey work involves a comparative study of these six programming languages with respect to the above programming paradigm using the following criteria: secure programming practices, web application development, OOP-based abstractions, reflection, Reusability, Portability, Reliability, Readability, Availability of compilers and tools, Familiarity, Expressiveness We study these languages in the context of the above mentioned criteria and the level of support they provide for each one of them. TABLE OF CONTENT 1. OVERVIEW OF PROGRAMMING LANGUAGE PARADIGMS 1.1 INTRODUCTION 1.2 CRITERIA OF LANGUAGE COMPARISON 2. IMPERATIVE LANGUAGES 2.1 Imperative Paradigm 2.1.2 Java as an Imperative Paradigm 2.1.3 Criteria 3. SCRIPTING LANGUAGES 3.1 Scripting Paradigm 3.2 Php as an Scripting Paradigm 3.3 Criteria 4. FUNCTIONAL LANGUAGES 4.1 Functional Paradigm 3.2 Php as an Scripting Paradigm 3.3 Criteria 5.1 LOGIC LANGUAGES 5.1.1 Readability 5.1.2 Ease of Learning 5.1.3 Ease of Maintenance 5.1.4 Extensibility 5.1.5 Pedagogy 5.1.6 Portability 6.1 OBJECT ORIENTED LANGUAGES (OOL) 6.1.1 Readability 6.1.2 Ease of Learning 6.1.3 Ease of Maintenance...

Words: 4013 - Pages: 17

Free Essay

Amines

...Name: Josiah Morales Title: Amines Introduction: Amines are organic compounds containing nitrogen containing the functional group R−NH2. Amines are capable of forming hydrogen bonds and small amines are quite soluble in water. Amines are one of the primary functional groups in amino acids, and are often found as part of compounds that are physiologically active or used in medications. In this experiment, the identity of an unknown amine or amine salt had to be determined using Solubility testing and the Hinsberg test. Apparatus and Materials: See Laboratory Manual, pages 40-42(Gary Gray. Laboratory Procedures: Organic Chemistry 2. Chemistry 3404. Wayland Baptist University, Plainview, TX.) Procedure: See Laboratory Manual, pages 40-42(Gary Gray. Laboratory Procedures: Organic Chemistry 2. Chemistry 3404. Wayland Baptist University, Plainview, TX.) Results: Boiling point of unknown – 181 ͦC Refractive index of unknown- 1.586 Solubility Test: Compound | Solubility | Odor | Aniline | - | Odor remained | Aniline hydrochloride | + | Odor formed then disappeared | Aniline sulfate | - | no odor | 4-Bromoaniline | - | Odor formed then disappeared | Methylamine hydrochloride | + | Odor remained | Pyridine | + | Odor remained | Unknown #4 | - | Odor remained | Hinsberg Test: Compound | Reaction | Precipitate | Dissolved in Water | Aniline | - | - | - | N-Methylaniline | + | + | - | Triethylamine | + | - | - | Unknown Amine | - | - |...

Words: 533 - Pages: 3