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

FireWire: High-Speed Serial Bus Interface

FireWire is an interface designed to connect up to 63 devices. The bandwidth of this bus is either 400 Mbps or 800 Mbps, depending on the version. IEEE 1394a supports up to 400 Mbps, while IEEE 1394b supports up to 800 Mbps.

Computer Peripherals: Input, Output & Storage

Peripherals are a set of elements, often referred to as information media or mass storage units, that are necessary to store data and information and are available to the central processor. There are two main types:

Input Devices

An input device is any device through which information is introduced to the central processing unit (CPU).

Output Devices

An output device is any device through which information is drawn from the central processing...

Ping Command Options

• -t: Sends echo requests to the host until interrupted.
• -a: Resolves IP addresses to host names.
• -n number: Specifies the number of echo requests to send.
• -l size: Sets the send buffer size in bytes.
• -f: Prevents fragmentation of the packet.
• -i TTL: Sets the Time To Live (TTL) value.
• -v TOS: Specifies the Type of Service (TOS).
• -r amount: Records the route for this number of hops.
• -s number: Records timestamps for this number of hops.
• -j lista_de_host: Specifies a loose source route along the host list.
• -k lista_de_host: Specifies a strict source route along the host list.

ARP Command Parameters

• -a: Displays current ARP entries. If Dir_IP is specified, it shows the IP and physical addresses only for that specific computer.
• -g: Same as

The Open Systems Interconnection Model

The Open Systems Interconnection (OSI) model is an abstract, layered representation created as a reference for network protocol design. The OSI model divides the process of networking into different logical layers, each of which has unique functionality and to which specific services and protocols are assigned.

Application Layer

The application layer, the seventh layer, is the top layer of both the OSI and TCP/IP models.

Presentation Layer

The presentation layer has three main functions:

• Coding and data conversion of the application layer to ensure that data from the source device can be interpreted by the appropriate application on the target device.
• Compression of the data in a way that can be decompressed

SQL Database and Table Creation

These commands demonstrate how to create a new database and define a table structure within it.

Creating the BDHotel Database

USE master;
GO
CREATE DATABASE BDHotel
ON
(
    NAME = 'BDHotel',
    FILENAME = 'c:\MSSQL7\Data\BDHotel.mdf',
    SIZE = 4MB,
    MAXSIZE = UNLIMITED,
    FILEGROWTH = 1MB
);

Creating the ROOM Table

USE BDHotel;
GO
CREATE TABLE ROOM
(
    NHabit INT NOT NULL,
    Building CHAR(1) NOT NULL,
    NumCamas INT NOT NULL DEFAULT (2),
    Available CHAR(1) NOT NULL,
    PRIMARY KEY (NHabit),
    CHECK (Building IN ('A', 'B', 'C', 'D', 'E'))
);

SQL Data Query Language (DQL)

The SELECT statement is used to retrieve data from a database. Here are various ways to query data.

Basic Data Retrieval (SELECT)

Media Player Functionality

A media player can play both audio and video, including TV programs. Common widget types include:

• DVD (xine)
• Audio (Winamp)
• Video (Windows Media)
• Multimedia (Movie Player)

FLV Format

FLV is a streaming video format popular on the internet, especially due to platforms like YouTube and Google Video. It requires Adobe Flash Player.

Video Editing Process

Video editing encompasses all operations performed during movie production.

Movie Components

Key components of a movie include:

• Menu
• Movie
• Frame
• Transition
• Clip

Windows Movie Player

Windows Movie Player is a built-in Windows application for simple and comprehensive video editing.

Film Editing

Film editing involves inserting various clips in chronological order for viewing.

Mounting Process

The...

Component Architecture

A component diagram illustrates the three layers:

• User layer (interface)
• Login layer (business rules)
• Data layer (database)

The use of interfaces and menus indicates who created the interface design.

Object Fundamentals

Class -> identity + state + behavior

Denormalization: The process of reverting from normalization, accepting redundancy and data dependencies to improve data performance. Data - Entity (instance, records)

Object Properties

Object properties:

• Encapsulation: Objects hide their attributes, state, and behavior from other objects.
• Inheritance: An object can inherit attributes and behavior from other objects.
• Overriding: The ability to change or modify inherited attributes or behavior.
• Composition: An object can be composed

IPv6: The Next Generation of IP Addressing

IPv6 utilizes 128 bits for addressing, a significant expansion from IPv4's 32 bits. It is represented in three primary forms:

• Standard Form: Eight groups of four hexadecimal digits, separated by colons (e.g., 2001:0db8:85a3:0000:0000:8a2e:0370:7334).
• Compressed Form: Consecutive groups of zeros can be replaced by a double colon (::). This compression can only be used once per address (e.g., 2001:0db8:85a3::8a2e:0370:7334).
• Mixed Form: A combination of IPv6 and IPv4 notation, where the last 32 bits are represented in standard IPv4 dotted-decimal format (e.g., ::ffff:192.0.2.128).

IPv6 enables automatic configuration of network devices. The method for establishing IP addresses with this version is more complex...

Foundations of Computer Security

The CIA Triad and Security Design Principles

• Confidentiality: Ensures data is accessible only to authorized entities. It prevents unauthorized disclosure of sensitive information using encryption, access controls, and data masking.
• Integrity: Guarantees that data remains accurate, complete, and uncorrupted by unauthorized modification or deletion. Maintained using hash functions, checksums, and digital signatures.
• Availability: Ensures systems, networks, and data remain operational and accessible to authorized users when needed. Protected via hardware redundancy, backups, and DDoS mitigation.
• Key Design Principles:
  • Least Privilege: Give entities only the minimum permissions necessary to perform their functions.
  • Fail-

ARM Family Core Architecture and Design Philosophy

ARM (Advanced RISC Machine) is a family of 32-bit/64-bit RISC processors designed for high performance, low power consumption, and efficient execution. ARM processors are widely used in embedded systems, smartphones, and IoT devices.

Components of the ARM Core Architecture

• ARM Core: Executes instructions and performs arithmetic and logical operations. It contains registers, an ALU, and a control unit.
• Instruction Cache: Stores frequently used instructions. It improves execution speed by reducing memory access time.
• Data Memory / Data Cache: Stores program data and temporary variables, enabling faster data access.
• Bus Interface: Connects the processor with memory and peripherals, transferring data

An Operating System (OS) acts as an intermediary or a bridge between computer hardware and the user. It manages hardware resources, provides a platform for application software to run, and ensures that the computer system operates efficiently and securely.

1. Core Functions and Characteristics

Major Functions of an OS

• Processor Management (CPU Scheduling): Decides which process gets the processor when, and for how long.
• Memory Management: Tracks primary memory (RAM), allocating and de-allocating blocks of memory to programs as they execute.
• File Management: Organizes files into directories, navigation paths, and manages access permissions (read, write, execute).
• Device Management: Communicates with hardware devices via their respective drivers, managing