A detailed explanation of functional dependence
A functional dependence was a term derived from mathematics. When a set of attributes determined another set of attributes, the other set of attributes depended on the set of attributes. It represents the dependence of the value of one attribute or set of attributes on the value of another attribute or set of attributes. This dependence is the semantical property of the information expressed by the relationship itself, and cannot be determined by the way the attributes form the relationship, nor can it be determined by the current content of the relationship. For example, in a complete functional dependence, if a non-main attribute data item depended on all keywords in a relationship, it was called a complete functional dependence. The Extraordinary Ordinary Life novel is equally exciting. Everyone is welcome to click and read it!
trivial functional dependence and partial functional dependence
Based on context alone 1. ** Ordinary Function Dependence ** - In a database, let R(U) be a relation pattern on a set of attributes U, and X and Y be a set of attributes U. If Y is a sub-set of X (that is, Y X), then X→Y is a trivial functional dependence. - For example, in the relationship mode of students (student number, name, gender),{student number, name}→{name} is a trivial functional dependence, because the name itself is a part of {student number, name}. Semantically speaking, trivial functional dependence represented an obviously established dependence relationship. This dependence relationship did not actually contain much meaningful new information, because it only indicated that the dependence of a set of attributes on its own set must exist. 2. ** Part of Function Dependence ** - Let (X,Y) be the property set of the relation pattern (R). If (X→Y) exists a proper set of (X ') such that (X'→Y), then (Y) is partially dependent on (X). - For example, in the Relational Mode course selection (student number, course number, grades, course name),{student number, course number}→{course name}, but in fact,{course number}→{course name}, which meant that the course name only depended on the student number and the course number in the course number, not the entire {student number, course number}, so the course name was partially dependent on {student number, course number}. Partial functional dependence may cause data redundancy-like problems. In the standardized design of a database, it is usually necessary to eliminate partial functional dependence to achieve a higher standard. The Extraordinary Ordinary Life novel is equally exciting. Everyone is welcome to click and read it!
Non-trivial functional dependence and trivial functional dependence
Let X and Y be the attributes of a relation, and X→Y. If Y is contained in X, then X→Y is called a trivial functional dependence. If Y is not contained in X, then X→Y is called a non-trivial functional dependence. The trivial functional dependence was automatically established because it was determined by the reflexive nature of the functional dependence. The functional dependence that was generally studied was mostly non-trivial functional dependence. The Extraordinary Ordinary Life novel is equally exciting. Everyone is welcome to click and read it!
Non-trivial functional dependence and complete functional dependence
Non-trivial functional dependence: In the Relational Model, if there is an attribute set X and an attribute set Y, and X→Y, but Y is not a sub-set of X, this functional dependence is called a non-trivial functional dependence. For example, in the relationship between students (student number, name, class, course, grade), student number → grade was a non-trivial functional dependence, because grades were not a sub-set of student number, and the student number could determine the attribute of grades. Complete functional dependence: In a relationship, if a non-main attribute data item depends on all keywords, it is called complete functional dependence. For example, in the relationship course selection (student number, course number, score), the score was completely dependent on the combination of the student number and course number. This was because the student number or course number alone could not determine the score. Only the combination of the two could determine the score. The Extraordinary Ordinary Life novel is equally exciting. Everyone is welcome to click and read it!
An example of functional dependence
The following are some examples of functional dependence: 1. In student relationships, the student number determined the student's name, age, and department. It could be expressed as student number → (name, age, department). Since one student number corresponded to one student, once the student number was determined, the corresponding name, age, and faculty would also be determined. 2. In the course selection relationship, the student number and the course number could be added together to determine the results of a student's course, that is,(student number, course number)→ results. A single student number or course number could not determine the results. This was a complete functional dependence. 3. In describing the relationship between students, student number → name, student number → department. Because one student number corresponded to one and only one student, and one student studied in a certain department, when the value of the "student number" attribute was determined, the value of "name" and "department" was also uniquely determined. 4. In the relationship mode, the course number determines the course name, which can be expressed as: course number → course name. The Extraordinary Ordinary Life novel is equally exciting. Everyone is welcome to click and read it!
Completely nontrivial functional dependence
In a functional dependence, let R(U) be the relation pattern on the property set U, and X and Y be a set of U. If X→Y (Y depends on X), and Y is not a sub-set of X (this is a non-trivial functional dependence), and for any proper sub-set X'of X, X' cannot determine Y (that is, the property of complete functional dependence), then Y is said to be completely non-trivial functional dependence on X. For example, in a relationship model (student number, course number) → grade, grade depends non-trivial on (student number, course number), and neither student number nor course number alone can determine grade. This is a completely non-trivial functional dependence. The Extraordinary Ordinary Life novel is equally exciting. Everyone is welcome to click and read it!
trivial and nontrivial functional dependence
If in a functional dependence, the attributes in the right attribute set are all a sub-set of the left attribute set, this functional dependence is called a trivial functional dependence. Conversely, if at least one attribute in the right attribute set is not a sub-set of the left attribute set, it is called a non-trivial functional dependence. For example, in the relation pattern R(A,B,C), if A→A exists, it is a trivial functional dependence, because A on the right is a sub-set of A on the left; if A→B exists, it is a non-trivial functional dependence, because B is not a sub-set of A. The concept of functional dependence was very important in the field of database design. It was an important basis for operations such as the normalisation of the relationship model. The Extraordinary Ordinary Life novel is equally exciting. Everyone is welcome to click and read it!
How to understand partial functional dependence
Let X and Y be the two sets of attributes of relation R. If X→Y exists, and when X 'is a true set of X, X' →Y exists, then Y is said to be partially dependent on X. Simply put, Y could be obtained by depending on X, but Y was not completely dependent on X. There was a proper set of X that could also be obtained by Y. This situation was partial functional dependence. The Extraordinary Ordinary Life novel is equally exciting. Everyone is welcome to click and read it!
What are the non-trivial functional dependence?
Let a relation be R(U), and X and Y be the sets of attributes U. If X→Y and X does not contain Y, then X→Y is called a non-trivial functional dependence. For example,(student number, course number) → personal score was a non-trivial functional dependence. The Extraordinary Ordinary Life novel is equally exciting. Everyone is welcome to click and read it!
A detailed explanation
"Sincerity" had many parts of speech and meanings: - ** Noun **: - The original meaning was close-fitting underwear. For example, in ancient times, the word "inner garment" meant "inner garment" or "underwear." - It could also express his heart. Words such as " heartfelt,"" difficulties,"" indifference," and " heartfelt " all meant what was in one's heart. They could also mean good or good, such as " lowering one's heart to the people." At the same time, they could also mean neutral, such as " compromise." - ** Verbs **: - It meant to wear it close to one's body or inside, such as "or Zhongqi Ru". It could also be extended to surround them, such as 'Zhongrong division, attack them from the front and back, kill them all.' - Adjectives: - It means to be upright, such as "Chu Pi Wo Zhong". It can also express kindness and happiness, such as "today I am loyal to Wu"; It also has the meaning of loyalty, such as "I don't want to listen to my words." The novel,"The Morality of the Past", is equally exciting. Everyone is welcome to click and read it!
A detailed explanation of Buddhism
In Buddhism,"crossing" had many meanings. From the meaning of the original meaning,"crossing" meant leaving the secular world, leaving life and death, and had the meaning of crossing over. From the perspective of cultivation, it was a way to achieve freedom through Buddhism. With the help of Buddhism, the cultivator could face things in life clearly and clearly, thus leading a free life and finally achieving the realm of wisdom and divine power. From a broad understanding of Buddhism,"crossing" was the process of reaching the other side of life and death from this side of the mortal world. For example, becoming a monk was seen as the first step to enlightenment, also known as "attaining salvation." In addition, in some modern understandings,"crossing" was also a restraint on emotions, anxiety, and depression. It was a kind of persistence and patience towards time. In real life, it could be seen as a manifestation of the level of emotional intelligence. For example, when the time was not ripe, one had to wait patiently and use the method of "crossing"(such as "enduring"), or watch coldly through setbacks and difficulties, waiting for the time to be ripe to defeat the enemy in one move. While waiting for the TV series, he could also read the exciting content related to this site!