wiz-icon
MyQuestionIcon
MyQuestionIcon
1
You visited us 1 times! Enjoying our articles? Unlock Full Access!
Question

___________ is the process of organising data in tables with the object of elimination redundancy and inconsistent dependency.

A
Data modelling
No worries! We‘ve got your back. Try BYJU‘S free classes today!
B
Normalisation
Right on! Give the BNAT exam to get a 100% scholarship for BYJUS courses
C
Data mining
No worries! We‘ve got your back. Try BYJU‘S free classes today!
D
None of these
No worries! We‘ve got your back. Try BYJU‘S free classes today!
Open in App
Solution

The correct option is B Normalisation

Normalisation:-

Normalisation is the process of organising data in tables with the object of elimination redundancy and inconsistent dependency.

Normalization is a process of reducing redundancies of data in a database. Normalization is a technique that is used when designing and redesigning a database. Normalization is a process or set of guidelines used to optimally design a database to reduce redundant data.

Data redundancy is a condition created within a database in which the same piece of data is held in two separate places. Data redundancy in database means that some data fields are repeated in the database. Redundancy is when we store same sort of information in different parts of DBMS.

Anomalies are any occurrence that weakens the integrity of your data due to irregular or inconsistent storage (delete, insert and update irregularity, that generates the inconsistent data).



flag
Suggest Corrections
thumbs-up
0
Join BYJU'S Learning Program
similar_icon
Related Videos
thumbnail
lock
Database Structuring
ACCOUNTANCY
Watch in App
Join BYJU'S Learning Program
CrossIcon