Start learning 50% faster. Sign in now
Normalization is a database design technique that organizes data into tables to reduce redundancy and enhance data integrity. 1. Reduction of Redundancy: By decomposing a database into smaller, related tables, normalization minimizes the duplication of data across the database. 2. Integrity Enforcement: Through constraints such as primary and foreign keys, normalization ensures data accuracy and consistency. 3. Normalization Forms: It employs techniques like 1NF (eliminating duplicate columns), 2NF (removing partial dependencies), and 3NF (removing transitive dependencies). 4. Efficiency: A normalized database is easier to maintain, as updates are made in fewer places. This method optimizes data storage, reduces anomalies (update, delete, and insert), and ensures a clean database structure. Why Other Options Are Incorrect: • A) Increase redundancy for faster data retrieval: This contradicts normalization’s primary goal of reducing redundancy. • B) Simplify query optimization: While normalization can assist in query efficiency, its primary goal is to organize data. • D) Create more complex table relationships: Normalization simplifies relationships rather than creating unnecessary complexity. • E) Minimize the use of indexing: Normalization focuses on data organization, not directly on indexing.
According to RBI’s KYC Directions, which account type can have relaxed identification requirements under specific circumstances?
A bank finds it difficult to repay the short term deposits on maturity because the funds of the bank are locked in ____
As per the Nayak committee, what percentage of its annual projected turnover should a n MSME get as working capital from a bank?
What is the minimum duration for which a small account can remain operational after opening without furnishing an Officially Valid Document (OVD)?
According to RBI, which of the following is considered an “Officially Valid Document” (OVD) for KYC purposes?
Which portal monitors outstanding dues to MSEs?
Which of the following is not allowed in small accounts?
What is required for conducting V-CIP (Video-Based Customer Identification Process)?
Which of the following entities was formed to identify and check fraudulent activity in lending transactions against equitable mortgages?
According to RBI's KYC Directions, if KYC/AML standards differ between RBI and a host country regulator for foreign branches of Indian banks, which stan...