Back to the 2024 paper
Similar questions
Database 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 SystemData models in DBMS are classified into _____ categories. (i) 3 (ii) 4 (iii) 5 (iv) 220182mDatabase Management SystemAn object in databases is equal to ____ + relationships. (i) data (ii) attribute (iii) entity (iv) constraint20192mDATABASE MANAGEMENT SYSTEMWhich of the following is the original purpose of SQL? - (i) To specify the syntax and semantics of SQL data definition language (ii) To specify the syntax and semantics of SQL manipulation language (ii) To define the data structures (iv) All of the above20212m
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.
AI LearningWeb Platform
Coursify — Personal AI Course Generator
Struggling with a difficult subject or concept? Turn any engineering topic into a structured course with interactive lessons, quizzes, and research-backed explanations.