Question
Which of the following scenarios violates Boyce-Codd
Normal Form (BCNF) in a relational schema?Solution
BCNF is a stricter version of 3NF. A table is in BCNF if, for every functional dependency X→YX , X is a superkey. If a candidate key determines another candidate key, it creates redundancy and violates BCNF. For instance, consider a table where StudentID and CourseID are candidate keys, but CourseID determines StudentID. This means there are multiple possible combinations leading to redundancy. Why Other Options Are Incorrect:
- Option A: This scenario adheres to both 3NF and BCNF, as all non-key attributes depend only on the primary key.
- Option B: This violates 2NF due to partial dependency but does not directly address BCNF.
- Option C: This violates 3NF by allowing transitive dependency but does not necessarily violate BCNF.
- Option E: This statement is a valid condition for both 3NF and BCNF.
According to the new Guidelines of issuing of Credit Cards, the NBFCs need to meet the criteria of having a net worth of not less than ____ crore.
Why did SEBI cancel the registration of Karvy Investor Services Ltd. (KISL) as a merchant banker?
Which of the following ministry recently launched the Citizen Perception Survey-2022?
RBI granted i n- p rinciple Payment Aggregator l icence to Paytm . Which of the follow i ng is the correct description of a Payment A ggregator?
Many initiatives have been taken to fight pandemic, TLTRO is one such initiative, identify under which policy category does it fit ?
Cabinet approves interest subvention of 1.5% on short-term agriculture loans up to Rs ____ lakh for FY23 to FY25.
India's Reliance Industries Ltd acquire which solar panel maker company for an enterprise value of $771 million?
The Priority Sector Lending (PSL) target for Small Finance Banks has been revised to ______ from FY2025-26 onwards by RBI. Â
Which among the following funds of the mutual fund invests primarily in other schemes of the same mutual fund or other mutual funds?
When traders first sell securities without first borrowing them or having possession of those securities, that is called: