Database Systems Past Paper 2024 – University of Sargodha (BS 4th Term)
University: University of Sargodha (UOS)
Program: BS 4th Term
Subject: Database Systems (CMPC-202)
Year: 2024
Time Allowed: 2 Hours 30 Minutes
Maximum Marks: 40
Why Use This Database Systems Past Paper?
This paper helps students understand real exam patterns and frequently asked topics in Database Systems.
- Practice SQL queries
- Understand normalization & ERD
- Revise database terminology
- Prepare structured answers
Database Systems Past Paper 2024 (Complete)
Below is the complete text of the paper:
University of Sargodha
BS 4th Term Examination 2024
Subject: Computer Science
Paper: Database Systems (CMPC-202)
Time Allowed: 02:30 Hours
Maximum Marks: 40
Note: Objective part is compulsory. Attempt any three questions from subjective part.Objective Part (Compulsory)
Q.1 Write short answers of the following in 2-3 lines each. (2×8)
- What is Data Warehouse?
- What is database management system?
- What is data independence?
- What is composite identifier?
- What is degree of relationship?
- Write down the limitations of hierarchical and network model?
- Explain the Multivalued Attribute.
- What is data dictionary?
Subjective Part (Attempt any Three)
Q.2 Explain the functions of each of the following SQL keywords using sample SQL queries. COUNT, GROUP BY, HAVING, INNER JOIN, IN, LIKE
Q.3 Explain Degree and Cardinality of Relationships with example.
Q.4 Convert the given table into 3rd Normal Form.
Q.5 Draw ER-Diagram for the given scenario (employees, organizations, jobs, budget, employment dates etc.).
Q.6 Write SQL commands for given relational queries.
Download
Download Database Systems Past Paper (PDF)
Related Past Papers
More papers coming soon – stay connected.
Short Question Solutions
1. What is Data Warehouse?
A data warehouse is a centralized repository used to store large volumes of historical data for reporting and analysis.2. What is database management system?
A DBMS is software that allows users to create, store, retrieve, update, and manage databases efficiently.3. What is data independence?
Data independence is the ability to change a database schema without affecting application programs.4. What is composite identifier?
A composite identifier (composite key) is a primary key made up of two or more attributes.5. What is degree of relationship?
The degree of relationship represents the number of entity types involved in a relationship (Unary, Binary, Ternary, etc.).6. Write down the limitations of hierarchical and network model?
They are complex, difficult to modify, lack flexibility, and require rigid data relationships.7. Explain the Multivalued Attribute.
A multivalued attribute can store more than one value for a single entity (e.g., student phone numbers).8. What is data dictionary?
A data dictionary stores metadata — definitions and descriptions of database tables, fields, indexes, constraints, etc.References:
DBMS Concepts — GeeksforGeeks
Oracle Database Docs