Free Essay

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

Book

...Database Tutorial Question The following relational database table is an extract of part of an “unnormalised” Student table: StudNum | StudName | StudAddr | PhNum | CourseCode | CourseName | UnitID | UnitName | StaffID | StaffName | StaffOffice | Grade | 101 | Jenny Teo | 123a Norwich Hse | 9911345 | 20241 | BBus(Acc) | Acc24 | Finance 2a | S045 | Paul Smith | D401 | D | 101 | Jenny Teo | 123a Norwich Hse | 9911345 | 20241 | BBus(Acc) | Law01 | Intro. Law | S022 | Elaine Ng | F213 | C | 101 | Jenny Teo | 123a Norwich Hse | 9911345 | 20241 | BBus(Acc) | Mgt21 | Org. Behaviour | S099 | Ann McCall | D211 | P | 112 | Warren Wills | 64 South St. Clayton | 9894387 | 30001 | BCom | Ais20 | Acc Info Systems | S120 | Peter Duffy | D411 | HD | 121 | Neil Smith | 123a Norwich Hse | 9911345 | 30001 | BCom | Acc24 | Finance 2 | S045 | Paul Smith | D401 | D | 121 | Neil Smith | 123a Norwich Hse | 9911345 | 30001 | BCom | Mkt10 | Intro Marketing | S111 | Dan Coleman | F210 | P | 130 | Joe Chan | 10 Wells St Frankston | 9901238 | 20242 | BBus(Acc) | Acc11 | Intro Accounting | S030 | Elli Blake | F109 | P | 130 | Joe Chan | 10 Wells St Frankston | 9901238 | 20242 | BBus(Acc) | Acc24 | Finance 2a | S046 | Paul Smith | D401 | D | 130 | Joe Chan | 10 Wells St Frankston | 9901239 | 20242 | BCom(Acc) | Law01 | Intro. Law | S022 | Elaine Ng | F213 | C | 130 | Joe Chan | 10 Wells St Frankston | 9901238 | 20242 | BBus(Acc) | Mkt10 | Marketing A | S111 | Dan Coleman | F210 | P |...

Words: 1236 - Pages: 5

Premium Essay

Doc Remove Delibitablement

...First year ENGINEER – ENG1 Modules | credits | Hours | Functional Analysis | 3,5 | 48 | Algebra for Engineers | 2,5 | 32 | Probability 1 | 3,5 | 48 | Statistical Decision (courses +Tuto) | 3,5 | 48 | Microprocessor System | 3 | 40 | Signal Transmission | 2,5 | 32 | Data Transmission | 2,5 | 32 | Workshop on Linux | 3 | 40 | Databases | 3 | 40 | TOEIC 1 | 2,5 | 32 | Advanced Maintenance | 2,5 | 32 | Numerical Analysis | 2,5 | 32 | Operations Research | 2,5 | 32 | Servo (Tuto) | 2,5 | 32 | Servo (Courses) | 2,5 | 32 | Algorithm (Data Structure) | 2,5 | 32 | Algorithm oriented object (Tuto, C++ Language) | 3 | 40 | Operating System (Theories and Fundamental) | 2,5 | 32 | WAN (courses + Tuto) | 4,5 | 60 | Method of Analysis 1 | 3 | 40 | Programming Workshop C | 2,5 | 32 | Software Engineering workshop (Access, VB) | 3 | 40 | Management Workshop for Science Engineer | 2 | 24 | Entrepreneurship | 1,5 | 20 |   |   |   | TOTAL | 63,5 | 832 | ------------------------------------------------- OBJECT ORIENTED ALGORITHM ------------------------------------------------- (Hands-On in Language C + +) CHAPTER I: GENERAL ON CLASS I. Notion of class • Generality of P.O.O • Incompatibility C / C + + II. Property of the member functions • Defaults • Member functions in-line • Transmission of object as argument III. Object assignment IV. Object Constructors and Destructors V. Object initialization VI....

Words: 2262 - Pages: 10

Premium Essay

Medical Marijuana

...The co-director of the Pearson center for alcoholism and Addiction Research and PhD Barbara Mason notes that ten percent of Marijuana users have a high risk of developing Marijuana dependence. Ninety percent of individuals will be able to use it in a way they find non problematic in terms of dependence but ten percent will run the risk of developing dependence, and for that, effective treatments should be available (Mason 2010). PhD Alan Marlatt, esteemed researcher, does not seem to be swayed by the support for the legalization of marijuana. He thinks it should be decriminalized not legalized, with decriminalization it does not make it legal but it would “open the door for more people to seek help.” Marlatt feels many marijuana dependences remain depend out of fear of getting in trouble with the law. Although Marlatt feels addicts will quit if they want to quit, many people will not because they will not view their dependency as an addiction. The officials of NIDA believe marijuana use will steadily grow through the years. This was based on a survey given to high school seniors, where many do not view daily consumption of marijuana as a dangerous. The growing...

Words: 1262 - Pages: 6

Free Essay

Nothing

...The reading further talks about the five bases of power and the dependence of power in relationships. The chapter also identifies the nine power and influence tactics along with their contingencies and the connection between sexual harassment and the abuse of power. Lastly the section emphasizes on the causes and consequences of political power and whether political action is ethical. The difference between power and leadership is power doesn’t require goal compatibility, merely dependence as where leadership does require some congruence between the goals of the leader and those being led. Despite how some may feel about power or leadership neither are bad. If you represent the bases of power that you will most likely fall into one of these categories: coercive, formal, legitimate, expert, or referent. The most important aspect of power is that it is a function of dependence. Chapter 14 topics are about conflict and the differences between traditional, interactionist, and managed-conflict views. The chapter also discussed the conflict process while defining negotiation and applying the five steps of the negotiation process. Conflict is defined as the process begins when one party perceives another party has or is about to negatively affect something the first party cares about. There has always been conflict over the view of conflict, some believe it should be avoided- that it indicates a malfunctioning within the group....

Words: 424 - Pages: 2

Premium Essay

Organizational Structure

...Organizational design (such as geographic, functional, customer-based, product, service, hybrid, matrix, marketing channels, and departmentalization) determines what organizational structure is best for any organization. UHS organizational design will be analyzed to ascertain which design is most appropriate for the organization. The three primary organizational structures are functional, matrix, and divisional. UHS utilizes a central and functional structure and has an established chain of command with deliberate authority of position dependence. Decisions are made from the top down. “The Company's business is conducted by its employees, managers and officers under the oversight of the Board. The Board is elected by the Company's stockholders in accordance with the Company's Certificate of Incorporation, to oversee management and to...

Words: 278 - Pages: 2

Premium Essay

Section 2 Notes

...Populations, demography, population models, competition, predation Dr. Dorn Introduction to Populations: (chapter 8) A. What is a population? What is a species? Stickleback (fish) in lakes: Primary population parameters – B I D E B. Methods of estimating populations 1. Census Method 2. Sampling Methods Census of sample areas N = C/ N = population estimate C = survey count = proportion of area 3. Relative Abundances – CPUE (catch per unit effort) 4. Mark-Recapture Estimates of population size Lincoln-Peterson (closed populations) Assumptions 5. Removal Design (closed population) Examining the number of animal “removed” and cumulatively removed during successive catches Gear set 1 2 3 4 Catch 76 54 35 24 Cumulative 0 76 130 165 Demographic Techniques (chapter 8) A. What is Demography? B. Life Table Analysis of populations Cohort: Parts of a life table analysis: 1. x and nx 2. Survivorship schedule: lx a. Per capita mortality rate: qx b. Survivorship patterns: Type I Type II Type III 3. Getting the data: cohort life tables static life tables 3. Fertility schedule bx Life history strategies: - Semelparous - Iteroparous Costs: 5. The Intrinsic rate of increase (r) a. Net Reproductive Rate (Ro): b. Generation Time (G): c. r ~......

Words: 664 - Pages: 3

Premium Essay

Wallace Group, Inc. Case

...STRATEGIC MANAGEMENT (Case Study-The Wallace Group, Inc.) ronald s. leabres JANICE FAYE S. ANG Professor Masters in Business Administration College of Business Administration and Accountancy Central Luzon State University Science City of Muñoz February 23, 2011 CASE ABSTRACT The Wallace Group is devised of three operational groups which include Electronics, Plastics and Chemicals. Harold Wallace was the original owner of the electronics company, but now has 45% of the group after acquiring the plastics company and then the chemical company. He also serves as the Chairman and President of the Wallace Group, but each group is run by a Vice President. Recently, Hal Wallace hired Rampar Associates to put together an effective sales presentation. Included in the presentation would be set of priorities to focus on over the next year, a clear plan and the expense. Frank Campbell, the Vice President of Industrial Relations, sums up the Wallace Group problem in a simple statement. He said, "Morale is really poor here. Hal runs this place like a one man operation, when it's grown too big for that." Frank also mentions that it took a the entire company revolting against him to finally make the President take action. Therefore, the most important problem facing the Wallace Group, is Harold Wallace himself. However, the problems do not stop there. In his interview, Hal mentions two key factors also contributing to his bad business etiquette. First, Hal admits he...

Words: 2690 - Pages: 11

Free Essay

Polymorphisms of the Serotonin Transporter and Receptor Genes: Susceptibility to Substance Abuse

...Investigating rs6311 on individuals with AD compared with (OD) opiod dependence were enriched with G allele when they carried 5-HTTLPR L allele F. SNP rs6311 not observed to moderate response to alcohol 3) American Indian ancestry G. Examined roll of HTR1B rs6296 vulnerability to AD with (ASPD) antisocial personality disorder a. Frequency of rs6296 C allele elevated b. HTR1B rs6216 significant linkage to AD 4) Taiwanese Han – AD and controls H. rs130058(A-161T) T allele significantly higher in AD cases I. demonstrated in vitro higher than A allele 5) Chinese Han J. T allele of rs130058 associated with AD K. Additional SNP’s in HTR1B related to AD L. Functional HTR1B SNP(rs13212041) described and reported larger portion of variation in self reported anger and hostility compared with HTR1B SNP’s 6) Animal studies and human clinical laboratory paradigms M. 5-HT3 antagonistic potential clinical utility for treating AD c. Efficacy varies widely N. Ondansetron AD treatment homozygous for 5-HTTLPR L allele had fewer drinks and higher abstinence d. Improved drinking outcomes in AD subjects carrying L/L genotype VS L/L genotype recurring sertraline (SSRI) Selective...

Words: 908 - Pages: 4

Free Essay

Untitled

...Chapter 3: Relational Model Chapter 3: Relational Model 1 1 Objectives 2 2 Logical View of Data 3 2.1 Table characteristics 3 2.2 terms 3 2.2.1 domain 3 2.2.2 primary key 4 2.2.3 abstract data type 4 2.2.4 tuple 4 2.2.5 attribute 4 3 Keys 4 3.1 determinant 4 3.1.1 functional dependence 4 3.1.2 multi-functional dependence 5 3.2 types of keys 5 3.2.1 super key 5 3.2.2 candidate key 5 3.2.3 primary key 5 3.2.4 alternate key 5 3.2.5 foreign key 5 3.2.6 secondary key 5 3.2.7 composite key 6 3.3 entity integrity 6 3.4 referential integrity 6 4 DB Integrity 6 4.1 domain integrity 6 4.2 entity integrity 6 4.3 referential integrity 6 4.4 business rules 6 5 Relational DB Query Languages 6 5.1 relational algebra 6 5.1.1 select 7 5.1.2 project 8 5.1.3 join 8 5.1.3.1 equa-join 8 5.1.3.2 theta-join 9 5.1.3.3 natural join 9 5.1.3.4 outer join 10 5.1.4 intersect 11 5.1.5 union 11 5.1.6 difference 11 5.1.7 Cartesian product 12 5.1.8 division 12 5.2 relational calculus 13 6 Meta Data Components 13 6.1 data dictionary 13 6.2 system catalog 13 6.2.1 synonym 14 6.2.2 homonym 14 7 Relationship Types 14 7.1 1:1 14 7.2 1:N 15 7.3 M:N 16 7.3.1 intersection table 16 7.3.2 dummy table 17 8 Data Redundancy in Relational Model 17 9 Indexes 17 9.1 pointer 18 9.2 unique index 18 9.3 non-unique index 18 1 Objectives • The relational database model takes a logical view of data....

Words: 2530 - Pages: 11

Premium Essay

Behavior of Nonprofit Boards of Director

...(Worth, 2014)  Three Theories             “Agency theory predicts that nonprofit boards select members capable of providing organization oversight, Resource dependence theory suggests that the board is likely to recruit members who can facilitate access to critical resources, and Institutional theory are board members who can legitimize...

Words: 617 - Pages: 3

Premium Essay

Accurately Assessing Functional Status

...Accurately Assessing Functional Status and the MDS 3.0 Rena R. Shephard, MHA, RN, RAC-MT, C-NE Judy Wilhide Brandt, RN, BA, RAC-MT, C-NE March 2013 Version Accurately Assessing Functional Status and the MDS 3.0 was developed as an educational program and reference for long-term care professionals. To the best of our knowledge, it reflects current federal regulations and practices. However, it cannot be considered absolute and universal. The information in this manual must be considered in light of the individual organization and state regulations. The authors and publisher disclaim responsibility for any adverse effect resulting directly or indirectly from the use of this manual, from any undetected errors, and from the user’s misunderstanding of the text. The authors and publisher put forth every effort to ensure that the content, including any policies, recommendations, and sample documents used in this text, were in agreement with current federal regulations, recommendations, and practices at the time of publication. The information provided in this course is subject to revision based on future updates and clarifications by CMS. The instructor commentary related to coding the MDS 3.0 contains the latest information released by CMS by the time of publication of this manual. Accurately Assessing Functional Status and the MDS 3.0 Rena R....

Words: 66309 - Pages: 266

Premium Essay

Drug Seeking

...This stands as a serious public health concern because individuals experiencing chronic pain are at great risk for decreased functional status and quality of life. Additionally, individuals living with chronic pain experience the common co-morbidities of depression, anxiety, and anger (Wilsey et al., 2008). The IASP/EFIC data from WHO (2004) concludes that one in four individuals experiencing pain, report that relationships with family and friends is “strained or broken.” Within the clinical setting, pain is a topic of great debate. The majority of health care professionals have fallen into the routine of branding and stigmatizing their clients as “drug seeking.” This term has been used for the last 25 years and implies that a client seeking medical attention is an addict out to obtain opioids, with the inclination that...

Words: 1382 - Pages: 6

Premium Essay

Organisation Structure

...Functional Organisation structure. Line and staff Organisation structure. Product Organisation structure. Committee and Matrix Organisation structure. .1 Line Organisation Structure Line Organisation (also called Military/Scalar Organisation) is the oldest and the simplest form of internal Organisation structure authority moves directly from the top level to the lowest level in a step-by-step manner. It is straight and vertical. The top-level management takes all major decisions and issues directions for actual execution. The general manager, for example, issues order to various departmental managers. Thereafter, the departmental manager issues instructions to works manager. Advantages of Line Organisation Structure Simplicity: Line Organisation structure is easy to understand and follow by superiors and subordinates. It is simple and clear as regards authority and accountability. Prompt decisions: Line Organisation facilitates prompt decision-making at all levels as the authority given is clear and complete. Discipline: It brings discipline in the Organisation due to unity of command, delegation of authority and direct accountability. Economical: Line Organisation is economical as experts are not appointed. Attraction to talented persons: Line Organisation brings out talented workers and develops in them quality of leadership. It offers opportunities of self-development to employees....

Words: 484 - Pages: 2

Premium Essay

Mario Mustilli Filom

...* Written by Filomena Izzo ** Written by Mario Mustilli & Filomena Izzo INTRODUCTION** Customer closeness necessitate that everyone in the firm have the customer firmly in mind when exercising their functional capabilities. At the same time, functional capabilities are of necessity interdependent in creating value for customers. For example, logistics must work closely together with production and marketing to plan, co-ordinate and integrate their activities. The modern way of expressing this is that logistics must serve both the internal customers and external customers of the firm (Langley, C.J. Jr and Holcomb,...

Words: 4452 - Pages: 18

Premium Essay

Substance Use Assessment

...The following treatment plan will assess the client’s need for alcohol dependence treatment by studying the client’s past and present usage, background, family history, any past or present medical conditions, behavior, and reasoning for entering treatment. Reason for Assessment The client, Bob M., is being assessed at this time based on concerns of his parents about his current alcohol abuse and its effects on his educational aspirations. Bob has failed the first year of college despite having above average intelligence and no previous problems in school. Bob’s parents have stated that financial support for further education will become unavailable if his behavior remains unchanged. Considering that alcohol-induced damage to the hippocampus region of the brain is a possibility for the college drinker (Doweiko, 2012), Bob is in danger of suffering long-term damage in memory processing and information retrieval. Bob has expressed a willingness to seek treatment in an effort to restore a relationship with a significant other. Sources of Information Bob’s past and current alcohol use history was retrieved through an interview with his parents, as well as from Bob himself. Both parties are in agreement that Bob’s early alcohol use was experimental and typical for adolescence; however the parent’s view of his alcohol use...

Words: 1884 - Pages: 8