The section contains multiple choice questions and answers on dealing with the concept of Relational Model. These include relational and schema, keys and relational query operators. 2. SQL : Queries, Constraints and Triggers The section contains questions and answers on different set of SQL basics,...
DBMS Questions for GATE From Database Management Section of Computer Science and Engineering MCQ – Single Answer DBMS GATE Questions If you take these entities ‘hotel room’, and ‘person’ with a many-to-many relationship, ‘lodging’ as shown in the figure below. To store information about...
Deletion Anomaly:The delete anomaly refers to the situation where the deletion of data results in the unintended loss of some other important data. Updatation Anomaly:The update anomaly is when an update of a single data value requires multiple rows of data to be updated. ...