When is a functional dependency F said to be minimal?

When is a functional dependency F said to be minimal?
by

1 Answer

Answer :

∙ Every dependency in F has a single attribute for its right hand side.
∙ We cannot replace any dependency X A in F with a dependency Y A where Y is a proper  subset of X and still have a set of dependency that is equivalent to F.
∙ We cannot remove any dependency from F and still have set of dependency that is  equivalent to F.
by

Related questions

A B C is a set of attributes. The functional dependency is as follows AB -> B AC -> C C -> B a) is in 1NF b) is in 2NF c) is in 3NF d) is in BCNF

Description : A B C is a set of attributes. The functional dependency is as follows AB -> B AC -> C C -> B a) is in 1NF b) is in 2NF c) is in 3NF d) is in BCNF

Last Answer : a) is in 1NF

What is Fully Functional dependency?

Description : What is Fully Functional dependency?

Last Answer : It is based on concept of full functional dependency. A functional dependency X Y is full functional dependency if removal of any attribute A from X means that the dependency does not hold any more.

What is Functional Dependency?

Description : What is Functional Dependency?

Last Answer : A Functional dependency is denoted by X Y between two sets of attributes X and Y that are subsets of R specifies a constraint on the possible tuple that can form a relation state r of R. The ... [Y]. This means the value of X component of a tuple uniquely determines the value of component Y.

What do you understand by dependency preservation?

Description : What do you understand by dependency preservation?

Last Answer : Given a relation R and a set of FDs F, dependency preservation states that the closure of the union of the projection of F on each decomposed relation Ri is equal to the closure of F. i.e ... ))+ = F+ if decomposition is not dependency preserving, then some dependency is lost in the decomposition

What is join dependency and inclusion dependency?

Description : What is join dependency and inclusion dependency?

Last Answer : Join Dependency: A Join dependency is generalization of Multivalued dependency.A JD {R1, R2, ,Rn} is said to hold over a relation R if R1, R2, R3, , Rn is a lossless-join ... columns of a relation are contained in other columns. A foreign key constraint is an example of inclusion dependency.

What is Multivalued dependency?

Description : What is Multivalued dependency?

Last Answer : Multivalued dependency denoted by X Y specified on relation schema R, where X and Y are both subsets of R, specifies the following constraint on any relation r of R: if two tuples t1 and t2 exist in r such that t1[X] = t2[X] then t3 ... ∙ t3[Z] = t2[Z] and t4[Z] = t1[Z] where [Z = (R-(X U Y)) ]

For a database relation R(a, b, c, d) where the domains of a, b, c, d include only the atomic values. The functional dependency a → c, b → d holds in the following relation (A) In 1NF not in 2NF (B) In 2NF not in 3NF (C) In 3NF (D) In 1NF

Description : For a database relation R(a, b, c, d) where the domains of a, b, c, d include only the atomic values. The functional dependency a → c, b → d holds in the following relation (A) In 1NF not in 2NF (B) In 2NF not in 3NF (C) In 3NF (D) In 1NF

Last Answer : (A) In 1NF not in 2NF 

In RDBMS, the constraint that no key attribute (column) may be NULL is referred to as: (A) Referential integrity (B) Multi-valued dependency (C) Entity Integrity (D) Functional dependency

Description : In RDBMS, the constraint that no key attribute (column) may be NULL is referred to as: (A) Referential integrity (B) Multi-valued dependency (C) Entity Integrity (D) Functional dependency

Last Answer : (C) Entity Integrity

Consider a schema R(MNPQ) and functional dependencies M→N, P→Q. Then the decomposition of R into R1(MN) and R2(PQ) is ............. (1) Dependency preserving but not lossless join. (2) Dependency preserving and lossless join (3) Lossless join but not dependency preserving (4) Neither dependency preserving nor lossless join.

Description : Consider a schema R(MNPQ) and functional dependencies M→N, P→Q. Then the decomposition of R into R1(MN) and R2(PQ) is ............. (1) Dependency preserving but not lossless ... and lossless join (3) Lossless join but not dependency preserving (4) Neither dependency preserving nor lossless join. 

Last Answer : Answer: 1

Explain functional dependency with example.

Description : Explain functional dependency with example.

Last Answer : A functional dependency occurs when one attribute in a relation uniquely determines another attribute. OR Consider a relation say R(X,Y), where X and Y are one or more than one attribute, ... sscper. That is, given rollno of a student, the name and sscper can be determined or searched.

Dependency theory was introduced by ____. (a) Andre Gunder Frank (b) Fanon (c) Samir Amin (d) Edward Said

Description : Dependency theory was introduced by ____. (a) Andre Gunder Frank (b) Fanon (c) Samir Amin (d) Edward Said

Last Answer : (a) Andre Gunder Frank

What is Functional Setup Manager or FSM as it is more commonly known as?

Description : What is Functional Setup Manager or FSM as it is more commonly known as?

Last Answer : Oracle Fusion Functional Setup Manager (FSM) is an application that provides an end to-end guided process for managing your functional implementation projects throughout the entire implementation life cycle.

Feeling hesitant to take an over-the-counter drug because I know I will develop dependency...do you have any advice?

Description : Feeling hesitant to take an over-the-counter drug because I know I will develop dependency...do you have any advice?

Last Answer : If you can don’t take it, it’s simple as that.

What is sliding into dependency on alcohol or other substances like?

Description : What is sliding into dependency on alcohol or other substances like?

Last Answer : answer:It began in college for me. It was the first time I was away from home, and the drinking age was 18 in my state at the time. I could march into any liquor store and by a bottle of ... me freedom from the fears that once plagued me. I sleep at night, and I'm relatively sane most days.

Ladies - Are you or would you be comfortable with a relationship that put you in total dependency of your partner?

Description : Ladies - Are you or would you be comfortable with a relationship that put you in total dependency of your partner?

Last Answer : answer:My sister did it. “So currently. She is out of work.” Pretty sure the outcome would be the same if she picked the job.

Are you interested in what the Director of the CIA has to say about OPEC and America's dependency on foreign oil?

Description : Are you interested in what the Director of the CIA has to say about OPEC and America's dependency on foreign oil?

Last Answer : Well at least with foreign oil when there’s a spill it screws up someone elses country.

Why is the dependency ratio higher in rural areas than in urban areas ? State two reasons. -Geography

Description : Why is the dependency ratio higher in rural areas than in urban areas ? State two reasons. -Geography

Last Answer : Dependency ratio is higher in rural areas because : 1. Birth rates are higher in rural areas. 2. Large numbers of adults migrate to urban areas in search of jobs. 3. Adults who migrate return to their rural homes after retirement.

The dependency ratio is higher in rural areas than in urban areas. Give two reasons to explain why. -Geography

Description : The dependency ratio is higher in rural areas than in urban areas. Give two reasons to explain why. -Geography

Last Answer : The following are the reasons for higher dependency ratio in the rural areas as compared to urban areas: 1. Birth rates are higher in the rural areas as compared to those in the urban areas. 2. ... . Adults who migrate to urban areas in search of jobs come back to their rural homes in old age.

How do i figure Child dependency ratio?

Description : How do i figure Child dependency ratio?

Last Answer : It is usually calculated as the number of children (aged under15 years) as a ratio of people of working age (ages 15 to 64). Thisratio is currently in a state of flux because the pension age isbeing raised in many countries so that the denominator of the ratiocovers a bigger age range.

What are some therapies used for chemical dependency treatment programs?

Description : What are some therapies used for chemical dependency treatment programs?

Last Answer : There are several treatment options for chemical dependency. There are 48 hours treatments, counseling, and group meetings for individuals to meet with people with similar chemical dependencies.

What is the success rate of patients who complete chemical dependency rehab?

Description : What is the success rate of patients who complete chemical dependency rehab?

Last Answer : The answer to this question will ultimately depend on the particular program in question. Some rehab centers prove to be better than others. Here are a few tips to evaluate the success rate of ... dependency rehab is between 2% to 20%, depending on the particular chemical the person is dependent on.

According to Arrhenius equation of temperature dependency of rate constant for an elementary reaction (A) k ∝ √T (B) k ∝ e -E/RT (C) k ∝ T e -E/RT (D) None of these

Description : According to Arrhenius equation of temperature dependency of rate constant for an elementary reaction (A) k ∝ √T (B) k ∝ e -E/RT (C) k ∝ T e -E/RT (D) None of these

Last Answer : (B) k ∝ e -E/RT

DIP stands for: a) Domain Inversion Principle b) Diodic Inversion Principle c) Dependency Inversion Principle d) None of These

Description : DIP stands for: a) Domain Inversion Principle b) Diodic Inversion Principle c) Dependency Inversion Principle d) None of These

Last Answer : c) Dependency Inversion Principle

. At the Melting Moments, an ice cream parlour, customers place their orders, watch their ice- cream sundaes being prepared, and then quickly eat the sundaes in the store before the ice cream melts. This is an example of a characteristic of services known as A. Inseparability B. Intangibility C. Heterogeneity D. Perishability E. Dependency

Description : . At the Melting Moments, an ice cream parlour, customers place their orders, watch their ice- cream sundaes being prepared, and then quickly eat the sundaes in the store before the ice cream ... known as A. Inseparability B. Intangibility C. Heterogeneity D. Perishability E. Dependency

Last Answer : D. Perishability

Which of the following is not a part of the characteristic of 4G network? a) Multirate management b) Fully converged services c) Software dependency d) Diverse user devices

Description : Which of the following is not a part of the characteristic of 4G network? a) Multirate management b) Fully converged services c) Software dependency d) Diverse user devices

Last Answer : a) Multirate management

What was the theory of Immanual Wallerstein? (a) Capitalist theory (b) World system theory (c) Dependency theory (d) Devil theory

Description : What was the theory of Immanual Wallerstein? (a) Capitalist theory (b) World system theory (c) Dependency theory (d) Devil theory

Last Answer : (b) World system theory

Which of the following is a knowledge representation technique used to represent knowledge about stereotype situation? (A) Semantic network (B) Frames (C) Scripts (D) Conceptual Dependency

Description : Which of the following is a knowledge representation technique used to represent knowledge about stereotype situation? (A) Semantic network (B) Frames (C) Scripts (D) Conceptual Dependency

Last Answer : (C) Scripts 

A relation R={A,B,C,D,E,F,G} is given with following set of functional dependencies: F={AD→E, BE→F, B→C, AF→G} Which of the following is a candidate key? (A) A (B) AB (C) ABC (D) ABD

Description : A relation R={A,B,C,D,E,F,G} is given with following set of functional dependencies: F={AD→E, BE→F, B→C, AF→G} Which of the following is a candidate key? (A) A (B) AB (C) ABC (D) ABD

Last Answer : Answer: D

If the unredacted Mueller report can be viewed by members of congress in some restricted-access room, and the fully released version has only minimal redactions, why is congress so vehemently demanding an unredacted distribution?

Description : If the unredacted Mueller report can be viewed by members of congress in some restricted-access room, and the fully released version has only minimal redactions, why is congress so vehemently demanding an unredacted distribution?

Last Answer : Because from a constitutional point of view, the Executive branch cannot and should not control what the legislative branch does. We have three co-equal branches of government. Not a dictatorship.

Is it odd to prefer minimal decoration?

Description : Is it odd to prefer minimal decoration?

Last Answer : I don't think it's weird, but it sounds like there is some sort of cultural/decorational sameness being desired or its lack is making some of them uncomfortable for some reason. If the workplace ... tons of knicknacks in their offices and are self-conscious and so projecting on you. Just guessing.

A MacBook Air 11 sleeve (very minimal) with shoulder straps?

Description : A MacBook Air 11 sleeve (very minimal) with shoulder straps?

Last Answer : I bought exactly what you’re describing at the Apple Store. It’s made by Thule

What is the best way to set up a minimal-maintenance vegetable garden?

Description : What is the best way to set up a minimal-maintenance vegetable garden?

Last Answer : Get a timer for the the hoses and use a drip system.

What's your favorite way for saving electricity or gas with minimal impact on quality of life?

Description : What's your favorite way for saving electricity or gas with minimal impact on quality of life?

Last Answer : Laundry off-peak. I’m a big night owl so I’m always doing laundry over night… yes it’s loud but earplugs go a long way ;)

For women who wear no/minimal makeup (seems to be a majority here), have you always felt that natural was better?

Description : For women who wear no/minimal makeup (seems to be a majority here), have you always felt that natural was better?

Last Answer : When I started high school, I wore a ridiculous amount of makeup. I definitely had raccoon eyes goin' on. As I got older, I wore less and less, until at one point I was only wearing foundation. When I ... my head. I have to wear a lot of eye makeup again, just because I hate being called sir.

Without using modern plumbing, or water in a ditch, how can I get up to a liter of clean drinking water from my back yard by tomorrow morning with minimal effort?

Description : Without using modern plumbing, or water in a ditch, how can I get up to a liter of clean drinking water from my back yard by tomorrow morning with minimal effort?

Last Answer : http://www.wikihow.com/Make-Water-in-the-Desert

How do I create this web effect (With Minimal Coding)?

Description : How do I create this web effect (With Minimal Coding)?

Last Answer : I would use LightBox v2 for this. It is pretty easy to get working. No javascript knowledge needed. It uses javascript but you don’t need to write any.

How can I shorten the straps on a dress with some sort of fastener or minimal sewing?

Description : How can I shorten the straps on a dress with some sort of fastener or minimal sewing?

Last Answer : Try sewing a button and button hole, you can always go back later and change it if you don’t like the fit.

What is a good stainless steel electric kettle to buy? I'd like one with minimal plastic that might leach into the water.

Description : What is a good stainless steel electric kettle to buy? I'd like one with minimal plastic that might leach into the water.

Last Answer : I got all this info from Zoe, who's been doing tons of research on the very same topic: Breville makes two $70 dollar models, all stainless steal, well reviewed. And ChefMate makes a full stainless steal one for $40, if a little less elegant. Both on Amazon.

I have too many cleaning products, and I've heard that you just need five. Can anyone tell me the minimal number of cleaning products I need to provide myself with a clean home?

Description : I have too many cleaning products, and I've heard that you just need five. Can anyone tell me the minimal number of cleaning products I need to provide myself with a clean home?

Last Answer : do you care about toxics? i say baking soda, vinegar, lemon juice, dish soap and bleach.

why does minimal breast exposure cause a woman to lose professionalism in her job?

Description : why does minimal breast exposure cause a woman to lose professionalism in her job?

Last Answer : answer:I can imagine a situation in which a co-worker (or boss in this case I guess) might think that it was on purpose just for the sake of doing so or possibly to gain the ... should be completely neutral in the sense that should do exactly what they are told without personality or uniqueness.

What well-paid careers don't have much bodily risk but no/minimal staring at screens?

Description : What well-paid careers don't have much bodily risk but no/minimal staring at screens?

Last Answer : Being born rich.

People who have become minimal or minimal-ish, has it actually made you happier?

Description : People who have become minimal or minimal-ish, has it actually made you happier?

Last Answer : Makes you appreciate things in life more

People who have become minimal or minimal-ish, has it actually made you happier?

Description : People who have become minimal or minimal-ish, has it actually made you happier?

Last Answer : Makes you appreciate things in life more

How can you say that women’s role in public life is minimal? -SST 10th

Description : How can you say that women’s role in public life is minimal? -SST 10th

Last Answer : . Earlier, only men were allowed to participate in public affairs, vote and contest for elections and public offices. . Gradually, the gender issue was raised in politics. . Women in ... lawyers, managers and college and university teachers, which were earlier not considered suitable for women.

How to create a minimal class in Python -Web-Development

Description : How to create a minimal class in Python -Web-Development

Last Answer : answer:

Minimal vacation

Description : How many days a year does an employee have the right to leave?

Last Answer : at least 4 weeks a year. Its length and method of drawing may be regulated by the employment contract. there is also an additional holiday - everything is in zp. its drawing is regulated by zp. (tuxedo)

How a damaged iPhone's screen can be replaced at a minimal cost?

Description : How a damaged iPhone's screen can be replaced at a minimal cost?

Last Answer : Yes just search someone on facebook that offers less in screen repair nearby in your area. I did it a year ago when I ask to apple store they offer 170$ for the screen repair but its really ... thou then I contacted the person who offers me 37$ for the screen repair then It fixed really smooth.

The strain neutrospara which grows on minimal mediu is called

Description : The strain neutrospara which grows on minimal mediu is called

Last Answer : The strain neutrospara which grows on minimal mediu is called A. Autotroph B. Prototroph C. Auxotroph D. Heterotroph

What ocean has extreme winds and storms causing exploration to be minimal?

Description : What ocean has extreme winds and storms causing exploration to be minimal?

Last Answer : Need answer

What is minimal super key?

Description : What is minimal super key?

Last Answer : no they did not