answersLogoWhite

0

There are several normal forms are available in DBMS.those are

1NF,2NF,3NF,BCNF,4NF,PJNF(project Join),DKNF(Domain Key).

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

What are the disadvantages of normalisation?

When we use Normalisation it does not allow some of the modifications of the database. Another disadvantage of Normalisation is that it is only applicable in the Relational Database Management System.


What is the difference between normalisation and denormalisation?

Hi, Normalisation is used to reduce the redundancy of database. So, we divide the the data into smaller tables. These tables are related to each other through a relationship. Denormalisation is the reverse process of normalisation. In this we add redundancy of data and grouping of data to optimize the performance.


How are forms and reports different?

a form is an object in a database; you can print data that appears in forms


Why is normalisation necessary?

Normalisation is necessary in database because of following:It eliminates data redundancy. Same data do not occur in more than one places.By making use of normalisation query process is easy.Data entry time is saved as the tables are broken down in repeating and not repeating fields.Data modification is made easy.Database becomes more flexibleInconsistent dependency is eliminated


What are the role of normalisation in dbms?

with this normalisation only we reduce redudency


Why normalisation necessary during database design?

Database normalization, or data normalization, is a technique to organize the contents of the tables for transactional databases and data warehouses. Normalization is part of successful database design; without normalization, database systems can be inaccurate, slow, and inefficient, and they might not produce the data you expect.


Why normalizations are important for database development?

Normalisation is process of taking data from a problem and reducing it to a set of relations. Meanwhile ensuring data integrity and eliminating data redundancy.


How do you design forms in object oriented database?

A database is about storing data, not about creating forms. You would create the forms in some programming language - NOT something directly related to the database server - than have your forms, or rather your program in general, connect to the database.


Why are forms an important part of a database?

the function of the database


What is a description of the data and the organization of data into tables in a relational database?

The process of working out what data should go into which tables and how the tables should be related to each other is known as Normalisation.


How is a Database organised?

A database contains forms and reports stored in tables


What can be achieved from the database using forms?

what can be achieved from the database using reports