Back to the 2019 paper
Similar questions
Database Management SystemExplain integrity constraints in DBMS. Discuss different types with examples.20257mDatabase Management SystemExplain the different integrity constraints in database system with the help of example.20187mDATABASE MANAGEMENT SYSTEMThe relational model feature is that there - (i) is no need for primary key data (ii) is much more data independence than some other database models (iii) are explicit relationships among records (iv) are tables with many dimensions20212mDatabase Management SystemWrite short notes on: Referential integrity in database20187m
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.
Free AppAndroid App
Coursify Android App
Generate AI courses, take quick quizzes between classes, and master complex engineering concepts on the go.