In RDBMS, different classes of relations are created using __________ technique to prevent modification anomalies.

This question was previously asked in
UGC NET Computer Science (Paper 2) Nov 2017 Official Paper
View all UGC NET Papers >
  1. Functional dependencies.
  2. Data integrity
  3. Referential integrity
  4. Normal Form

Answer (Detailed Solution Below)

Option 4 : Normal Form
Free
UGC NET Paper 1: Held on 21st August 2024 Shift 1
13 K Users
50 Questions 100 Marks 60 Mins

Detailed Solution

Download Solution PDF
A functional dependency is a constraint that describes the relationship between attributes in a relation. Data integrity refers to the accuracy and consistency of data stored in a database, data warehouse, data mart or another construct. Referential integrity is a relational database concept, which states that table relationships must always be consistent. Normalization is a process of organizing the data in the database to avoid data redundancy, insertion anomaly, update anomaly & deletion anomaly. 1NF, 2NF, 3NF and BCNF are types of normal forms. So, option (D) is correct.
Latest UGC NET Updates

Last updated on Jun 19, 2025

-> The UGC NET City Slip 2025 has been released on its official website today.

-> The UGC NET June 2025 exam will be conducted from 25th to 29th June 2025.

-> The UGC-NET exam takes place for 85 subjects, to determine the eligibility for 'Junior Research Fellowship’ and ‘Assistant Professor’ posts, as well as for PhD. admissions.

-> The exam is conducted bi-annually - in June and December cycles.

-> The exam comprises two papers - Paper I and Paper II. Paper I consists of 50 questions and Paper II consists of 100 questions. 

-> The candidates who are preparing for the exam can check the UGC NET Previous Year Papers and UGC NET Test Series to boost their preparations.

More Normal Form Questions

More Integrity Constraints and Normal Form Questions

Get Free Access Now
Hot Links: teen patti lotus teen patti happy teen patti