Notes, summaries, assignments, exams, and problems for Computers

Users and Privileges

The root user is the administrator and possesses all privileges in MySQL. It is not recommended to grant all users full server access; maintaining data and structural integrity requires restricting specific tasks to authorized users only.

Users and privileges are intimately related. You can create users without immediately assigning privileges. MySQL allows you to define distinct users and assign specific permissions at various levels.

Privilege Levels

• Global: Applies to all databases on a server. This is the highest and most general level of privilege.
• Database: Applies to individual databases and, by extension, all contents within them.
• Table: Applies to individual tables and all columns within those tables.
• Column: Applies

Java Programming Fundamentals

Variables and Data Types

• Which of the following options is not a variable? Literal
• A block of related data elements is called a table.
• According to convention, the dollar sign character is never used to start a variable name.
• An object is a software bundle related to its state.
• Using 16-bit Unicode.
• You can use the short data type to save memory in large tables.
• You do not need to assign a value when a field is declared.
• Each item in a table is called an element.
• Parameters are always variables.
• The length of a table is set when the table is created.

Operators and Expressions

• The operator with the highest priority is evaluated before operators with lower priority.
• Operators on the same line have equal priority.
• If the name of

Understanding Assembly Language

Assembly language is a low-level programming language where instructions are written using mnemonic codes rather than binary machine language. An assembler translates these instructions into executable machine code.

Classification of Assembly Instructions

Assembly language instructions are categorized into three primary types:

• Imperative Statements (IS): Specify operations for the processor to perform. These generate executable machine code. Examples include: STOP, ADD, SUB, MULT, MOVER, MOVEM, COMP, BC, DIV, READ, and PRINT.
• Declarative Statements (DL): Used for memory allocation and data definition. DS (Define Storage) reserves memory locations, while DC (Define Constant) stores a constant value in memory.
• Assembler

Cohen-Sutherland Line Clipping Algorithm

As covered briefly in our previous discussion, the Cohen-Sutherland algorithm is a highly efficient line-clipping method that uses a 4-bit binary region code (Outcode) to categorize where the endpoints of a line lie relative to a rectangular window.

The 9-Region Outcode Breakdown

The clipping window boundaries (x_min, x_max, y_min, y_max) divide the 2D world space into 9 distinct regions. Each region is assigned a 4-bit code [Bit 1, Bit 2, Bit 3, Bit 4] defined by coordinate comparisons:

• Bit 1 (Top): Set to 1 if y > y_max
• Bit 2 (Bottom): Set to 1 if y < y_min
• Bit 3 (Right): Set to 1 if x > x_max
• Bit 4 (Left): Set to 1 if x < x_min

Mathematical Intersection Formulas

When a line cannot be trivially accepted... Continue reading "Computer Graphics: Clipping, 3D Modeling, and Projections" »

Topic Modeling: LSI vs LDA

Latent Semantic Indexing (LSI)

Use LSI for semantic similarity, retrieval, short/sparse documents, and synonymy problems. It uses Singular Value Decomposition (SVD) to find latent concept axes from term-document co-occurrence. Concepts are mathematical directions, not clean probability-based topics. It is better when the goal is to “find similar documents.”

Latent Dirichlet Allocation (LDA)

Use LDA for discovering hidden themes and topic percentages. In this model, each document is a mixture of topics, and each topic is a distribution over words. It is better when the goal is to determine “what themes exist in this corpus?”

Key Distinction

• LSI finds latent concept dimensions.
• LDA explicitly models probabilistic topics.

What is Software Engineering?

Software Engineering is the application of engineering principles, methods, and tools to the design, development, testing, deployment, operation, and maintenance of software systems in a systematic, disciplined, and measurable way.

Software Process Flows

A software process defines the approach used to develop a system. Common process flows include:

• Linear/Sequential: Activities are performed one after another in a fixed order. Each phase must be completed before the next begins.
• Iterative: The development process is repeated in cycles. Each iteration improves the software based on feedback.
• Evolutionary: The system is developed in versions or increments, where each version adds new features and improves the previous

Experiment 5: Customer Analytics Database

This Python experiment demonstrates the practical application of core data structures: Tuples, Lists, Sets, and Dictionaries to build a basic Customer Analytics System.

# Experiment Code:
# Tuple: Fixed dataset structure (immutable)
dataset_schema = ("CustomerID", "Name", "PurchaseAmount", "Segment")
# List: Stores purchase amounts (mutable, ordered)
purchase_amounts = []
# Set: Stores unique customer IDs
unique_customers = set()
# Dictionary: Stores complete customer records
customer_records = {}

while True:
    print("\n--- Menu Customer Analytics ---")
    print("1. Add Customer Data")
    print("2. View Purchase Amounts (List)")
    print("3. View Dataset Schema (Tuple)")
    print("4. View Unique

1. Armstrong Number Checker

Write a shell script to check whether a given number is an Armstrong number.

echo "Enter a number"
read c
x=$c
sum=0
while [ $x -gt 0 ]
do 
  r=$(( $x % 10 ))
  n=$(( $r * $r * $r ))
  sum=$(( $sum + $n ))
  x=$(( $x / 10 ))
done
if [ $sum -eq $c ]
then
  echo "This is an Armstrong number"
else 
  echo "This is not an Armstrong number"
fi

2. Calculate Area of a Circle

Write a shell script to find the area of a circle.

echo "Enter radius"
read r
echo "Area is"
echo "3.14 * $r * $r" | bc

3. Average of Command Line Arguments

Write a shell script to find the average of numbers entered as command line arguments.

sum=0
for i in $*
do
  sum=$((sum + i))
done
echo "Summation of $# numbers is: $sum"
N=$#
avg=$(echo "$sum / $N" | bc -l)
echo "Average = $avg"

1. Resolution

Resolution refers to the number of pixels used to display an image on a screen. It determines the clarity and detail of the image.

• It is usually written as width × height (e.g., 1920 × 1080).
• The higher the resolution, the sharper and clearer the image.
• Lower resolution images appear blurry or pixelated.

Example: If a display has a resolution of 1024 × 768, it means the screen contains 1024 pixels horizontally and 768 pixels vertically.

2. Aspect Ratio

Aspect Ratio is the ratio between the width and height of a display screen or image. It defines the shape of the display area and is expressed as width : height.

Common Aspect Ratios:

• 4 : 3 – Old computer monitors and televisions
• 16 : 9 – Modern widescreen monitors and TVs
• 21 : 9 –

Functional Units of a Computer

A computer system is logically divided into several functional units that work together to perform data processing. These units accept input, process the data, store information, and produce output.

Main Functional Units

1. Input Unit

• Accepts raw data and instructions from the user and enters them into the computer.
• Converts the input data into machine-readable form (binary) for processing.

Examples: Keyboard, Mouse, Scanner, Microphone.

2. Output Unit

• Displays the processed results to the user.
• Converts the machine results into human-readable form.

Examples: Monitor, Printer, Speakers.

3. Memory Unit

• Stores data, instructions, and intermediate results required for processing.
• Supplies data to the CPU whenever needed.

Types