Back to the 2018 paper
Similar questions
Database Management SystemExplain the different integrity constraints in database system with the help of example.20187mDatabase Management SystemExplain integrity constraints in DBMS. Discuss different types with examples.20257mDATABASE MANAGEMENT SYSTEMDescribe the importance of data integrity in a database. How can constraints (such as primary keys and foreign keys) help enforce integrity?20247mDATABASE MANAGEMENT SYSTEMWhich key cannot be null - (i) Unique key - (ii) Primary key - (iii) Super key - (iv) Foreign key20237m
PreviousTo include integrity constraint in an existing relation use (i) create table (ii) modify table (iii) alter table (iv) drop tableNextConsider 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.