answersLogoWhite

0

The purpose of normalizing data in DBMS is to reduce the data redundancy and increase the consistency of data.

a) Partial dependency: non-prime attribute ( field) depends on other non-prime attributes

b) Functional dependency

c) Transitive dependency

User Avatar

Wiki User

13y ago

What else can I help you with?

Related Questions

What are the key components and processes involved in the dependency map project management?

The key components and processes involved in the dependency map project management include identifying tasks, determining task dependencies, creating a visual representation of the dependencies, tracking progress, and adjusting plans as needed based on dependencies.


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.


Describe briefly the process involved in producing cheese?

hassan


Describe processes involved in human resource management?

management proceses


What Is Involved With Room Additions?

Alot more than I can describe here...


Describe the relationship between the thylakoid and chloroplasts?

Thylokoid are in chloroplasts.They are involved in photosynthesis.


Describe in detail the steps involved in implementing a stand-alone program?

easy way


What was the significance of camp david of 1979?

The 1979 Camp David Accords involved the normalization of relations between Israel and Egypt following the 1967 and 1973 wars. Most importantly Egypt was returned control of the Sinai Peninsula, which was captured by the Israelis in June 1967.


What was the significance of the camp David accords if 1979?

The 1979 Camp David Accords involved the normalization of relations between Israel and Egypt following the 1967 and 1973 wars. Most importantly Egypt was returned control of the Sinai Peninsula, which was captured by the Israelis in June 1967.


Describe the way in which all machanism of heat transfer are involved in hearting the air?

Convection, conduction, and radiation


What statement best describe the military engagement at Vicksburg and Petersburg?

Both engagements involved siege warfare.


Describe one of your current or recently completed projects, setting out the risks involved?

BLUE APRON DEALS