Back to the 2024 paper
Similar questions
Database Management SystemExplain object-oriented databases and discuss their advantages over relational databases.20257mDatabase Management SystemExplain the concepts of Object-Oriented Databases (OODBMS) and Object-Relational Databases (ORDBMS).20247mDatabase Management SystemWhich of the following is *not* a feature of the relational database model? (i) Tables with rows and columns (ii) Use of SQL (iii) Pre-defined data access paths (iv) Data independence20242mDatabase Management SystemWrite short notes on: Object Oriented DBMS20227m
Previous2NF removes which kind of dependency? (i) Transitive (ii) Partial (iii) Functional (iv) MultivaluedNextConsider the relation R (P, Q, S, T, X, Y, Z, W) with the following functional dependencies. PQ → X; P → YX; Q → Y; Y → ZW Consider the decomposition of the relation R into the constituent relations according to the following two decomposition schemes. D1 : R = [(P, Q, S, T); (P, T, X); (Q, Y); (Y, Z, W)] D2 : R = [(P, Q, S); (T, X); (Q, Y); (Y, Z, W)] Identify whether it is a lossless or lossy decomposition and justify your answer.