0611-113 Final Solved Questions & Study Guide (Summer 2025)

0611-113 ICT In Business Final Exam Solved Questions — Summer 2025 (DIU BBA)

Introduction

The 0611-113 ICT In Business course is a core component of the BBA program at Daffodil International University (DIU), designed to equip students with essential information and communication technology (ICT) skills for modern business environments. This course covers critical topics such as database management systems (DBMS), network topologies, cybersecurity threats, and network architectures, all of which are vital for managing business operations efficiently and securely.

For DIU BBA students, practicing past exam questions is one of the most effective ways to prepare for the final exam. Solving these questions helps reinforce key concepts, improve problem-solving skills, and identify areas that need further review. In this blog post, we provide detailed, step-by-step solutions to the Summer 2025 final exam paper for 0611-113 ICT In Business, ensuring you understand not just the "what" but the "how" and "why" behind each answer. Whether you're revising for the exam or looking to strengthen your grasp of ICT in business, this guide is tailored to help you succeed.

Exam Overview & Mark Distribution

The Summer 2025 final exam for 0611-113 ICT In Business consists of four questions, each testing different Course Learning Outcomes (CLOs) at varying levels of difficulty. The exam is structured to assess both theoretical knowledge and practical application of ICT concepts in business scenarios. Below is the mark distribution for each question:

• Question 1 (CLO 2, Level 2): 10 marks (5 + 5)

- Advantages of DBMS over spreadsheets

- Application of primary and foreign keys for data integrity

• Question 2 (CLO 2, Level 2): 10 marks (5 + 5)

- Network topology selection and illustration

- Advantages and disadvantages of the chosen topology

• Question 3 (CLO 3, Level 3): 10 marks (5 + 5)

- Identification of cybersecurity threats

- Security measures to prevent future incidents

• Question 4 (CLO 3, Level 3): 10 marks

- Network architecture identification

- Advantages and disadvantages of the architecture

Solved Questions

Question No. 1: Advantages of DBMS and Application of Primary/Foreign Keys

Question:

Sunrise University manages data for 15,000 students, including personal details, academic records, and tuition payment history. Currently, each department keeps its own spreadsheet files, leading to problems such as duplicate student records, inconsistent information, and difficulty in quickly generating reports. The university's management decides to implement a centralized Database Management System (DBMS) to solve these issues. Identify major advantages of using a DBMS for the university than the current spreadsheet-based system. Apply the concepts of primary key and foreign key to the university's database to maintain data integrity.

Solution:

Part 1: Advantages of DBMS Over Spreadsheets

A Database Management System (DBMS) offers several advantages over traditional spreadsheet-based systems, especially for large organizations like Sunrise University. Here are the key benefits:

• Data Centralization and Consistency:

- In a DBMS, all student data (personal details, academic records, and payment history) is stored in a single, centralized database, eliminating the need for multiple spreadsheets across departments.

- This ensures data consistency, as updates made in one place are reflected everywhere, reducing errors caused by duplicate or outdated records.

• Reduced Data Redundancy:

- Spreadsheets often lead to data redundancy (e.g., a student’s name appearing in multiple files). A DBMS uses normalization techniques to minimize redundancy, saving storage space and improving efficiency.

• Improved Data Integrity:

- DBMS enforces data integrity rules, such as constraints and validation checks, to ensure that only accurate and valid data is entered. For example, a student’s ID must be unique, and their enrollment date cannot be in the future.

• Efficient Data Access and Reporting:

- DBMS allows for fast and flexible querying using languages like SQL (Structured Query Language). Sunrise University can generate reports (e.g., tuition payment summaries or academic performance analytics) in seconds, whereas spreadsheets would require manual consolidation.

• Enhanced Security and Access Control:

- DBMS provides role-based access control, ensuring that only authorized personnel (e.g., finance staff for payment data) can view or modify sensitive information. Spreadsheets, on the other hand, are prone to unauthorized access or accidental deletions.

• Scalability for Future Growth:

- As Sunrise University expands, a DBMS can scale effortlessly to accommodate more students, courses, and departments. Spreadsheets become unwieldy and slow as data volume grows.

Part 2: Application of Primary and Foreign Keys

To maintain data integrity in Sunrise University’s database, primary keys and foreign keys are essential:

• Primary Key:

- A primary key is a unique identifier for each record in a table. For example:

- In the `Students` table, the `Student_ID` (e.g., `2025001`) serves as the