Data managment (sec) 2025 pyq kuk bca 3rd semester

examination paper for the subject **DATA MANAGEMENT** with the paper code **B23-SEC-302**. It is a three-hour exam with a maximum of 35 marks. The paper is structured as follows: * **Structure and Requirements**: Students must attempt five questions in total, including the compulsory Question No. 1 and one question from each of the four units. Each question carries equal marks. * **Question 1 (Compulsory)**: This section consists of seven short-answer questions (a-g) covering fundamental database concepts like DBMS properties, hashing, entity types, Codd's rules, functional dependency, SQL data types, and view creation syntax. * **Unit I**: Focuses on DBMS definitions, architectures (centralized, web-based, and N-tier), and storage structures such as indexing and data dictionaries. * **Unit II**: Covers relationship types, cardinality ratios, attribute differences (single vs. multivalued), keys, and the concepts of generalization and specialization. * **Unit III**: Addresses database system design, including converting E.R. diagrams into relational systems and the principles of normalization, specifically the third normal form. * **Unit IV**: Examines SQL implementation, including constraints (default, primary, and foreign keys) and specific statements such as `DELETE`, `UPDATE`, and data retrieval in descending order.