0
Redundancies is found when there are 2 rules no matter what condition is that, the final action are the same. For example,
1st rule: if today is Raining day and if it is Weekend, the action is Stay at home.
2nd rule: if today is Raining day and if it is Not Weekend, the action is Stay at home.
So no matter it is Weekend or not, the action will be Stay at home. This is called redundancies. As a result, we will remove 1 rule and write the rules like this:
Condition/Action Rule
1
Raining Day Y
Weekend -
Stay at home X
The dashes (-) means Y or N.
Contradictions is found when there are impossible rules which there are 2 rules with different action but have the same condition meet. This is occured when the dashes(-) are incorrectly inserted into the table.For example,
Condition/Action Rules
1 2
Salary> $50000/year Y Y
Salary< $2000/month - -
Work> 5 years Y Y
2% bonus X
5% bonus X
no bonus
Can you see? Although the 2 rules are Salary > $50000/ year and Work > 5 years, but the Bonus entitled are not the same. This is called contradiction.
What else can I help you with?
How do you create unnormalized table?
To create an unnormalized table, you can combine multiple related entities and their attributes into a single table without splitting them into separate tables. This violates the principles of database normalization, leading to redundancy and potential data anomalies. Unnormalized tables can be created by directly designing the database schema without following normalization rules.
Which gas is colourless in a periodic table?
Nitrogen is a colorless gas that can be found on the periodic table.
What category of elements is the most common in the periodic table and where is that category found in the periodic table?
The transition metals are the most common, and are found in the middle (groups 3-12) of the periodic table.
What are the most common metalloids found in the periodic table?
The most common metalloids found in the periodic table are boron, silicon, germanium, arsenic, antimony, and tellurium.
Is diamond found in the periodic table of elements?
NOT as 'diamond'. However, diamond is an allotrope of carbon . Carbon is found in the periodic table. as 'C'. NB Diamond, Graphite and Buckminster Fullerene (Footballene) are three allotrop[es of of Carbom . NOT isotopes. An Allotrope is an element that exists in different physical form.
Open ended decision table permits access to another..?
This type of decision table is known as an extended-entry decision table.
What is a sentence for decision?
they made their decision at the judge's table
What advantages does decision table have over decision tree?
could u send me the answers for the merits of the decision tables
What is the advantage of table?
One advantage of decision table is that table is drawn in the first iteration which acts as a stepping stone to derive a new decision table. One disadvantage is that the table does not scale up well.
What are the metals found in the periodic table?
Metalliods are found at the center of the periodic table.
What does table it mean?
It means to delay making a decision on a matter- leaving it on the table, rather than acting on it.
Which can be found on a periodic table elements compounds or mixtures?
Elements are found on periodic table. Compounds are not present on periodic table. The table does not contains mixture.Elements can be found on a periodic table. Compounds can be made by bonding two or more elements. But they are not depicted on the periodic table.
Found on the nose or on the table?
Glasses are found on the nose or on the table. This is an example of a word, or language riddle.
Where can a anion be found on the periodic table?
yourube table
Is table salt found in Walmart?
Table salt can be found in just about any grocery store.
Where is cation found on the periodic table?
Cations are mainly found on the left side of the period table.
How do you create unnormalized table?
To create an unnormalized table, you can combine multiple related entities and their attributes into a single table without splitting them into separate tables. This violates the principles of database normalization, leading to redundancy and potential data anomalies. Unnormalized tables can be created by directly designing the database schema without following normalization rules.
