C# Programming Fundamentals: Arrays, Loops, and Decisions

Posted by on Dec 4, 2025 in Computers | 0 comments

Life Expectancy Analysis with Parallel Arrays

This exercise demonstrates the use of parallel arrays to store and process life expectancy data by gender.

Instructions

  1. Create four parallel arrays containing the life expectancy data as shown in Table 1.
  2. Iterate through the parallel arrays to count and display a list of country names where the life expectancy for both genders exceeds 80 years.
  3. Prompt the user to input a country code.
  4. Use a loop to display the country name and life expectancies for males,
Read More

Essential OS and Computer Networking Lab Exam Q&A

Posted by on Dec 3, 2025 in Computers | 0 comments

Operating System (OS) Lab Questions

Basic OS Concepts

  1. What is an Operating System (OS)?

    → It is system software that acts as an interface between the user and the hardware.

  2. What are the main functions of an OS?

    → Process management, memory management, file management, I/O management, and security.

  3. What is a process?

    → A program in execution.

  4. Difference between process and program?

    → A program is passive (stored on disk); a process is active (in execution).

  5. What is a thread?

    → A lightweight process;

Read More

Essential Python and Command Line Programming Concepts

Posted by on Nov 30, 2025 in Computers | 0 comments

Essential Command Line Tools

Terminal Commands

  • mkdir: Creates a new directory.
  • pwd or cd (or chdir): Shows the current working directory.
  • Changing Directory Example: To change the current directory to the ‘SI206’ folder (if you are currently in its parent folder, ‘Fall22’), use cd SI206.

Git Commands (Version Control)

  • git clone url: Copies a repository to your local computer.
  • git status: Shows what has changed and what is staged for commit.
  • git add file: Adds a specific file to the staging area for the
Read More

Database Storage Structures and Index Management Techniques

Posted by on Nov 29, 2025 in Computers | 0 comments

Database Storage Structures

There are several methods for storing user data in a database, each optimized for different performance and scalability requirements.

Regular Tables

A regular table (generally referred to as a “table”) is the most commonly used form of storing user data.

  • The database administrator has very limited control over the distribution of rows in an un-clustered table.
  • Rows can be stored in any order depending on the activity on the table.

Partitioned Tables

A partitioned table enables

Read More

Data Structuring, Acquisition, Cleaning, and ETL Cheatsheet

Posted by on Nov 29, 2025 in Computers | 0 comments

Module 1 Cheatsheet — Foundations, Acquisition, DOM/XPath, Structuring


1) What “Big Data” means:


No single size cutoff. Think:
Volume (lots of rows/large objects), Variety (heterogeneous), Velocity (fast-changing), Veracity (quality).Implication: choose tools/storage/pipelines that match data scale and shape.

2) Three canonical encodings:


Tables / Relations / DataFrames

Heterogeneous columns; ideal for SQL/Pandas joins, filters, aggregations.

Arrays / Matrices / Tensors

Uniform numeric cells;

Read More

Mastering SQL: Practical Database Design and Query Examples

Posted by on Nov 29, 2025 in Computers | 0 comments

SQL Database Management: Supplier and Product Inventory

Defining the Inventory Schema (DDL)

We begin by setting up the database structure for tracking suppliers and their products. Note the use of PRIMARY KEY, FOREIGN KEY, and CHECK constraints for ensuring data integrity.

Supplier Table Creation

CREATE TABLE Supplier (
    SupplierID INT PRIMARY KEY,
    Name VARCHAR(100) NOT NULL,
    City VARCHAR(50)
);

Product Table Creation

CREATE TABLE Product (
    ProductID INT PRIMARY KEY,
    Name VARCHAR(100)
Read More