Back to the 2019 paper
Similar questions
Database Management SystemAn object in databases is equal to ____ + relationships. (i) data (ii) attribute (iii) entity (iv) constraint20192mDatabase Management SystemExplain integrity constraints in DBMS. Discuss different types with examples.20257mArtificial intelligenceDescribe constraint satisfaction problem in detail.20197mDatabase Management SystemExplain the different integrity constraints in database system with the help of example.20187m
PreviousWhen we try to modify any table in a database system, we encounter some side-effects if the tables are insufficiently normalized. Can you explain those side-effects with the respective examples?NextDiscuss the correspondence between E-R model construct and the relation model construct. Show how each E-R model construct can be append to the relational model using the following description of an organization: An organization uses number of items of an equipment to produce goods. Each item is at one LOCATION, of one TYPE and has a DETAILED_DISCRIPTION. Faults on the equipment are identified by a unique FAULT_ID and are reported at a TIME_REPORTED. Any number of persons may be assigned to a fault and work on the fault until it is fixed. The TIME_FIXED is recorded as the TIME_SPENT by each person on a fault. Any number of parts may be used to repair a fault. The QTY_USED of each part is recorded against the fault. Each part is identified by a PART_ID and has a given weight and MAX_DIMENSION and can have any number of colors.