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

Client-Server Model

• The client-server model defines the structure of communicating applications and their synchronization.
• It consists of two interacting processes:
  • Server Process
  • Client Process
• Client and server are inseparable; one cannot exist without the other.

Server

• This process awaits hearing on a given server port. It continuously waits for remote client processes to connect.
• Authentication
• Security and information privacy in the system where they reside.
• Must be able to handle requests from multiple clients simultaneously.
• Important: All clients will be connected to the same server port.

In general, we say that a computer is a server when its operating system runs one or more server processes (FTP, HTTP, DNS, etc.).

Client

• It is a process that sends

E1 Primary Access and Multiplexing

Multiplexing and Quantization

True or False: Multiframes are sent 500 per second in E1 primary access.

Plesiochronous multiplexers cause a loss of original formatting information.

CMI code requires greater bandwidth.

Question: What is the step size of a uniform quantizer with 2048 levels and a dynamic signal range of ±1V?

Answer: 0.977 mV

Question: How many quantization levels are in the second segment of a non-uniform quantizer using the A-law approach?

Answer: 16 levels

E1 Primary Access Characteristics

False Statement: In E1 primary access, the word alignment multiframe is transmitted every 15 frames.

True Statement: In E1 primary access, the word alignment multiframe is transmitted every 2 ms.

NFAS: Offers a speed...

Creating Engaging Multimedia Presentations

A presentation is a multimedia file that can contain text, graphics, photos, music, and video. Its organization is done by slides, which succeed one another under your control. Templates are presentations that have predefined design objects in the slides, such as the background, fonts, placement of text, and other objects that give the presentation a common appearance across all slides.

Interactivity: Establishing Hyperlinks

Interactivity is established by creating hyperlinks. Clicking on a button or text performs an action, such as opening a file or linking to a website. You can insert a hyperlink from the Insert menu, then selecting Hyperlink.

Interactivity in objects allows navigation to different slides...

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...