Quiz 3

1. How web technologies work?

Web technologies work through the internet using websites and web browsers.
When a user enters a website address, the browser sends a request to the server.
The server processes the request and sends the webpage back to the browser.
Technologies like HTML, CSS, and JavaScript are used to create and display web
pages.

2. Internet fundamentals with example.

The internet is a global network that connects computers and devices worldwide.
It allows users to share information and communicate online.
Basic components include IP address, web browser, server, and protocols like HTTP.
Example: When we search on Google, data travels through the internet to show
results.

3. Email system vs Videoconferencing.

Email System Videoconferencing

Used to send written messages. Used for live video meetings.

Communication is not instant. Communication happens in real time.

Files and documents can be attached. Audio and video interaction is possible.

Example: Gmail Example: Zoom

4. Explain collaboration tools.

Collaboration tools help people work together online.
These tools allow communication, file sharing, and teamwork from different
locations.
They improve productivity and save time.
Examples include Google Docs, Microsoft Teams, Zoom, and Slack.
Quiz 4
1. Explain SQL.
SQL stands for Structured Query Language.
It is used to create, manage, and retrieve data from databases.
SQL helps users store and organize information easily.
Common SQL commands are SELECT, INSERT, UPDATE, and DELETE.

2. Difference between Constraints and Joins.

Constraints Joins

Used to apply rules on data. Used to combine data from tables.

Maintain data accuracy and integrity. Retrieve related data from multiple tables.

Example: Primary Key, NOT NULL Example: INNER JOIN, LEFT JOIN

Applied while creating tables. Applied during data retrieval.

3. Create Table (PPT).

CREATE TABLE Student (
ID INT,
Name VARCHAR(50),
Department VARCHAR(30)
);

4. Create Table.
CREATE TABLE Employee (
EmpID INT,
EmpName VARCHAR(50),
Salary INT
);

Assignment 3
1. Explain the role of ICT in modern education.
ICT plays an important role in modern education by improving learning methods.
It helps students access online classes, digital books, and educational videos.
Teachers can communicate easily with students using technology.
ICT also supports distance learning and online examinations.

2. Compare traditional learning vs e-learning.

Traditional Learning E-Learning

Takes place in classrooms. Takes place online.

Requires physical attendance. Can be accessed from anywhere.

Fixed learning schedule. Flexible timing.

Uses books and boards. Uses digital devices and internet.

3. Explain how ICT is used in business operations.

ICT helps businesses communicate and manage information efficiently.
Companies use computers, emails, and databases for daily work.
Online meetings and cloud storage improve teamwork and productivity.
ICT also helps in marketing, customer service, and online sales.

4. Discuss the types of e-commerce models (B2B, B2C, C2C).

B2B means Business to Business, where companies sell products to other companies.
B2C means Business to Consumer, where businesses sell directly to customers.
C2C means Consumer to Consumer, where people sell products to each other online.
Examples are Alibaba (B2B), Amazon (B2C), and OLX (C2C).

5. Explain basic concepts of digital marketing.

Digital marketing is the promotion of products using the internet.
SEO helps websites appear higher in search results.
Social media marketing uses platforms like Facebook and Instagram for promotion.
Email marketing is used to send promotional messages to customers.

6. Explain data processing cycle with diagram.

The data processing cycle converts raw data into useful information.
The steps include input, processing, storage, and output.
This cycle helps organizations make better decisions.
Diagram:
Input → Processing → Storage → Output

7. Describe the structure of a database.

A database stores information in an organized form.
Tables are used to store data.
Rows represent records, while columns represent fields or attributes.
This structure helps manage and retrieve data easily.

8. Explain types of databases.

Relational databases store data in tables with rows and columns.
They use SQL for managing data.
Non-relational databases store unstructured data like documents and images.
Examples are MySQL (relational) and MongoDB (non-relational).

Analytical
1. Student uses Google to find research papers.
How the search engine processes the query
Google reads the keywords entered by the user.
It searches its database and finds related webpages.
The search engine ranks results based on relevance and quality.
Ways to improve search results
Use specific keywords.
Use quotation marks for exact phrases.
Add filters like filetype:pdf or publication year.

2. Company shifting to video conferencing.

Benefits
Saves travel time and cost.
Improves communication between teams.
Supports remote work.
Challenges
Internet problems can affect meetings.
Security and privacy issues may occur.
Technical knowledge is required.
Best practices
Use strong internet connections.
Schedule meetings properly.
Use secure platforms with passwords.

3. Educational institute wants LMS.

Key features required
Online classes and assignments.
Student progress tracking.
Discussion forums and quizzes.
Benefits for students and teachers
Easy access to study materials.
Better communication and learning management.
Time-saving and flexible learning environment.

4. Online business wants to increase sales.

Strategies
Use SEO to improve website ranking.
Promote products on social media.
Use email marketing for customer engagement.
Impact
Increases website traffic.
Improves brand awareness.
Helps attract more customers and sales.

5. Company stores employee data in one large file.

Problems
Data can be duplicated.
Searching information becomes difficult.
Higher risk of data loss and errors.
Database solution
Use a database management system.
Store data in tables with proper structure.
Apply backups and security controls.

Case Study
A startup launches an e-commerce website but faces several issues.
Problems
Poor website traffic due to weak SEO and marketing.
Poor communication among team members.
Data management problems because of unorganized records.
Solutions using ICT tools
Use SEO and digital marketing to improve traffic.
Use collaboration tools like Zoom and Microsoft Teams for communication.
Use databases like MySQL for proper data management.
Use LMS platforms for employee training and learning.

Assignment 4
1. Explain key components of Cybersecurity.
Confidentiality
Protects data from unauthorized access.
Integrity
Ensures data remains accurate and unchanged.
Availability
Ensures systems and data are available when needed.

2. Discuss common cybersecurity threats.

Malware
Malicious software that damages systems.
Phishing
Fake messages used to steal personal information.
Ransomware
A virus that locks files and demands payment.

3. Explain ethical concerns in ICT.

Ethical concerns include misuse of personal data and digital surveillance.
Organizations may collect user information without permission.
This can violate privacy and security rights.
Proper laws and ethical policies are important for protection.

4. Describe the working and applications of IoT.

IoT connects smart devices through the internet.
Devices collect and share data automatically.
Applications include smart homes, healthcare, and smart cities.
IoT improves automation and efficiency.

5. Explain cloud computing services.

IaaS
Provides virtual hardware and storage online.
PaaS
Provides a platform for application development.
SaaS
Provides software through the internet.
Examples include AWS, Google App Engine, and Microsoft 365.

Analytical
1. Impact of cyber-attacks on organizations.
Cyber-attacks can cause financial loss and data theft.
They damage company reputation and reduce customer trust.
Preventive measures include antivirus software, firewalls, backups, and employee
training.

2. Company collects user data without consent.

Ethical issues
Violation of user privacy.
Misuse of personal information.
Possible consequences
Legal penalties and loss of customer trust.
Damage to company reputation.
Solutions
Take user permission before collecting data.
Follow privacy laws and secure customer information.
3. Compare AI, IoT, Cloud Computing, and Mobile Computing.

Technology Applications Benefits Security Challenges

AI Chatbots, automation Fast decision making Data privacy risks

IoT Smart homes Automation Device hacking

Cloud Computing Online storage Easy access Data breaches

Mobile Computing Smartphones Mobility Malware attacks

Case Study
Smart Home System (IoT-based)
Potential cybersecurity risks
Hackers may access smart devices.
Weak passwords can expose the system.
Devices may spread malware.
Privacy concerns
Personal data and camera recordings may leak.
User activities can be monitored without permission.
Security measures
Use strong passwords and encryption.
Update device software regularly.
Enable two-factor authentication.