Back to the 2024 paper
Similar questions
Database Management SystemExplain the terms ‘partial functional dependency’ and ‘transitive dependency’. Define 2NF and 3 NF in relation with these terms.20227mDATABASE MANAGEMENT SYSTEMA normal form in which every non-prime attribute is fully dependent on prime attribute is - (i) 1 NF - (ii) 2 NF - (iii) 3 NF - (iv) BCNF20237mDatabase Management SystemConsider the universal relation R = \{A, B, C, D, E, F, G, H, I\} and the set of functional dependencies F = \{\{A, B\} \rightarrow \{C\}, \{A\} \rightarrow \{D, E\}, \{B\} \rightarrow \{F\}, \{F\} \rightarrow \{G, H\}, \{D\} \rightarrow \{I, J\}\} What is the key for R? Decompose R into 2NF, then 3NF relations.201814mDatabase Management SystemWhich normal form is considered adequate for normal relational database design? (i) 2 NF (ii) 5 NF (iii) 4 NF (iv) 3 NF20222m
PreviousWhich of the following ensures no data is lost after a system crash? (i) Commit log (ii) View (iii) Recovery manager (iv) TriggerNextWhich of the following is true about object-oriented databases? (i) They use tables only (ii) They allow encapsulation (iii) No support for complex data (iv) Only support numeric data
Student FinanceWeb Platform
Pocketly — Personal Finance for Students
Keep your hostel and college expenses under control. Track accounts, log spending in seconds, and stay within your monthly budget.