answersLogoWhite

0


Best Answer

Types of normalisation

  1. First Normal Form
  2. Second Normal Form
  3. Third Normal Form
  4. BCNF
Students Age Subject Anne 20 Biology, Maths flora 23 Maths devin 16

Maths

User Avatar

Wiki User

7y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Types of normalisation with table example?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is normalization in DBMS?

Normalisation means make table very effective and usable means make table atomic ,unique primary key,not redundancy etc.


What are the role of normalisation in dbms?

with this normalisation only we reduce redudency


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.


What is an non-example for a ratio table?

A dining table is a non-example a ratio table.


What are two common types of static routes in routing tables?

ils y a deux types: table statique et table dynamique Translation - There are 2 types. Static table, and dynamic table.


What normalisation is used in IEEE 754 format?

none, it uses denormalization.


Is non key is same as those key that are not primary key?

A non-key field can be any field in the table that is not the primary key. During the process of normalisation identifying non-key fields is important, as they and other fields may be moved and new tables created. Foreign keys will be left in the table.


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


Example of table appointments?

Examples of table appointments are:silverwaredinnerwareglasswarecenterpiece


Types of table setting?

There are different types of table settings. The most common ones include formal setting, casual setting and buffet table setting among others.


What grade is 114 out of 185?

It is approx 62%. As to the grade, the answer will depend on any normalisation and grade boundaries.