Notes, summaries, assignments, exams, and problems for Computer science

Understanding Window Elements

Standard Window Components

1. Control Menu: Displays a menu with options to restore, move, size, minimize, maximize, and close the window.
2. Toolbar: Provides direct access to frequently used display options for greater efficiency.
3. Title Bar: Displays the name of the window or application.
4. Menu Bar: Displays and provides access to the menus available within the application.
5. Work Area: The primary area provided by the application for the user to perform their work.
6. Window Border: Allows you to resize the window when it is not maximized. Place the mouse pointer on the border, then press and drag it to the new position.
7. Status Bar: Displays help or information about the current task or ongoing processes.

Window Control Buttons

• A.

Inter-VLAN Routing: Router-on-a-Stick Configuration

Router-on-a-Stick is a router configuration type used for forwarding network traffic between multiple Virtual Local Area Networks (VLANs) using a single physical interface.

The router performs inter-VLAN routing by accepting traffic labeled with VLAN tags (using a trunk interface from the adjacent switch) and routing internally between virtual interfaces (subinterfaces).

Configuring Subinterfaces and Multilayer Switches

Subinterfaces are multiple logical interfaces associated with a single physical interface. To enable a multilayer switch to perform routing functions, you must configure the VLANs on the switch interfaces with corresponding IP addresses that match the subnet associated with that...

Data Link Layer Fundamentals

1. MAC vs. LLC Sublayers: Motivation

The Data Link Layer (Layer 2) is crucial for connecting to upper layers and managing device communication within a local network. It employs specific addressing schemes to identify devices and uses frames to group bits for transmission. This layer is divided into two sublayers:

• Logical Link Control (LLC):
  • Establishes the connection with upper layers, integrating with network layer protocols.
  • Identifies the network layer protocol (e.g., IPv4, IPv6) for the encapsulated packet.
  • Remains independent of the physical equipment, providing a consistent interface to the network layer.
• Media Access Control (MAC):
  • Responsible for bringing data onto and off the physical media.
  • Handles data encapsulation,

MySQL Essentials: Database & Table Management

Connecting to MySQL

To connect to a MySQL server, use the following command:

mysql -u [username] -p [password]

Database Operations

Viewing Databases

To see all available databases:

SHOW DATABASES;

Creating a Database

To create a new database:

CREATE DATABASE [database_name];

Selecting a Database

To select a database to work with:

USE [database_name];

Table Operations

Viewing Tables

To list all tables within the currently selected database:

SHOW TABLES;

Viewing Table Structure

To display the structure (columns, data types, etc.) of a specific table:

DESCRIBE [table_name];

Creating a Table

To create a new table within the selected database:

CREATE TABLE [table_name] (
    [field_name_1] [data_type_1] [field_definitions_

Cache Write Policies

Write-Through

• Definition: Writes data to both the cache and main memory simultaneously.
• Synchronization: Cache and main memory are always synchronized.
• Write Speed: Slower, because every write goes to both cache and memory.
• Data Integrity: Ensures data in both cache and main memory is identical.
• CPU Performance Impact: Slower, due to the additional write to main memory.
• Use Cases: Ideal for systems where data consistency is critical (e.g., databases).
• Cache Miss Handling: Writes to both cache and memory on a miss.
• Complexity: Simple to implement; doesn't require tracking of data in the cache.

Write-Back

• Definition: Writes data to the cache first and only writes to memory when the cache line is evicted.
• Synchronization: Cache and main

• A class is a template used to create objects and declare data types and methods in a program.
• Public - Modifier used to declare classes and interfaces. Void - Method that returns no value. Main - Marks the start and end of program execution.
• Scanner class - Used to get user input for types like String and Int.
• Exceptions: Try-catch block, throw statement.
• Inheritance provides a powerful and natural mechanism for organizing and structuring software programs. It improves clarity in the design of classes.
• A subclass provides specialized behavior based on elements provided by the superclass. Using inheritance, programmers can reuse the code in the superclass many times.
• Reading and Writing to Files:
  1. Import java.io file.
  2. File inputFile = new File("input.

Loop Invariant:

Big-Theta, Big-Oh, Big-Omega

Explanation

10.1 Pivot tables

What is a pivot table? It is one of the most powerful tools in Excel. They are also called “dynamic” because the data on them can be changed by rearranging or changing the position of the column and row headers in an easy and quick way.

The use of a dynamic table is to obtain information summaries from our data grid in order to be able to quickly analyze big volumes of information. These type of tables can be used in situations such as:

• When you have a table with rows that have different date and you need to organize the information by time periods (month, semester, etc.)
• When you need to change the arrangement in the rows or column cells to show different perspectives from the same data set.

Follow these steps to...

Importing Bitmap Images into Fireworks

Defining the Canvas

The first step is defining the work area or canvas (remember to have the negative area visible). Then, select the import option from the File menu.

A window like the one below will open.

Locating and Selecting the Image

In the Look in option, you'll search the folder where your image is saved. In the Files of type menu, the formats that Fireworks recognizes are shown. Once you select the file, click Open.

Placing the Image

The following mark will be displayed on the canvas, which means Fireworks is ready to bring in the selected image.

Simply click with your mouse or try to trace the desired size of the image.

That way, the image will appear on the canvas.

Image Properties

This image's properties...