0
date of birth determines a person's age.
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
What is complex attribute in dbms?
Complex Attribute: A complex attribute is an attribute that is both composite and multivalued.
What is multivalued attribute?
Potential to have more than one value for an attribute
Difference between single valued and multivalued attribute?
single value attribute is one that holds a single value for a single entity. example:- name, roll_number... multivalued attribute is one that holds multiplevalues for a single entities. example:- degree(phd, mca)
What is a complex attribute?
A Complex attribute that is both Composite and Multi valued. Composite and Multivalued attributes can be nested arbitrarily to form a Complex attribute like Address.
What two courses of action are available to a designer when he or she encounter an attribute?
what two courses of action are available to a designer who encounters a multivalued attribute
What is multivalued dependency?
Multivalued dependencies are also referred to as tuple generating dependencies. After the Boyce -Codd normal form the results may be devoid of any functional dependencies but it may encounter multivalued dependencies as the multivalued dependencies also cause redundancy of data. For eg: If there are 3 attributes involved in a relation,A,B, and C.. Then for every value of A we will have respective values for B and C.. But it is a necessary in the 4th normal form that both B and C values are independent of each other. This is represented by .,, A->>B A->>C.. MVD or Multivalued Dependency is a dependency where one attribute value is potentially a "multivalued fact" about another and the attributes must be independent of each other.
What are some examples of a composite attribute?
A composite attribute consists of a group of values from more than one domain. For example, the Address attribute consists of several domains such as house number, street number, city, country, etc.
What is mvd in dbms?
multivalued data
An example of a physical or a economic attribute would be?
There are a few examples of economic attribute. One main example is water resources.
What is the prime attribute in a database?
It is an attribute that does not occur in some candidate key.
What is an arcsine?
An arcsine is any of the single- or multivalued functions which are inverses of the sine function.
What is classical logic and multivalued logic?
Classical Logic allows two truth values, True and False. Multivalued or "many-valued logic" allows other kinds of truth values and it allows there to be more than two truth values.
