📘 Chandigarh University – MCA/CA/B.Tech
These Mid-Semester papers are part of the official examinations of Chandigarh University,
designed to test knowledge and practical understanding of core MCA, Computer Applications, and B.Tech subjects.
💡 Each paper encourages students to think critically, apply concepts, and showcase problem-solving skills — helping them prepare for real-world IT challenges.
Usage Condition:
- 📖 Papers are for reference and study purposes only.
- 🧑🎓 Students should use them responsibly and not for any malpractice.
- 📅 Availability depends on the course and year.
Business Analytics
Subject Code:24CAH-703
Semester: 2 | Time: 1 Hour | Max Marks: 20
Section A
- Define a Database Management System (DBMS) and state its primary functions
- State how do you use the MIN function to retrieve the minimum value in SQL
- Explain the primary key. Why is it important in a relational database?
- Identify an SQL query to create a new table named departments with columns department_id and department_name
- Define view in SQL? Provide a basic definition and an example
Section B
(2 × 5 = 10 Marks)
- Explain the usage of the GROUPING function to identify super-aggregate rows in grouped data.
- Explain the usage of the ALTER TABLE statement to modify the structure of an existing table.
