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

Object Identifier (OID) Explained

OID stands for Object Identifier, which is a unique identifier assigned to each object in an object-oriented database (OODB).

Function and Structure of OIDs

In an OODB, data is stored as objects that have properties (attributes) and behaviors (methods). Each object is assigned a unique OID that identifies it uniquely within the database. OIDs are used to reference objects and to establish relationships between them.

For example, if one object in a database needs to refer to another object, it can do so using the OID of the other object. This helps to establish relationships between objects and enables the creation of more complex data structures.

OID vs. Primary Key

OIDs in database management systems are similar...

Gestión de Libros: Formularios de Control

1. Insertar un nuevo libro

Título:

Autor:

Editorial:

Categoría: Texto Lectura

2. Borrar un libro

ID del libro:

3. Consulta de libros por categoría

Mostrar libros de la categoría: Todos Texto Lectura

PL/SQL Components for Race Management

The following PL/SQL objects demonstrate core database programming concepts, including custom functions for calculation, procedures for data manipulation and ranking, and triggers for auditing.

1. Calculating Global Time: The tempo_global Function

This function calculates the total elapsed time for a specific pilot by summing the duration of all stages recorded in the TempoEtapas table. It includes robust error handling using SQLCODE.

CREATE FUNCTION tempo_global (ID_piloto IN NUMBER)
RETURN NUMBER
IS
    soma_tempo NUMBER;
    coderro NUMBER;
    CURSOR c1 IS
        SELECT tempo_inicio, tempo_fim
        FROM TempoEtapas
        WHERE Piloto_idPiloto = ID_piloto;

BEGIN
    soma_tempo := 0;
    FOR item IN

This document presents seven fundamental Java programming examples (pg1 through pg7) that demonstrate basic input/output, conditional logic, array handling, and algorithmic concepts. The original code contained numerous syntax errors, capitalization issues, and logical flaws. Below, we provide the corrected and optimized versions, ensuring proper Java conventions and functionality.

1. pg1: Conditional Arithmetic Checks

Purpose: Evaluating multiple arithmetic relationships between three input integers (a, b, c).

The original code had incorrect capitalization (Int, If, Else) and a logical flaw where the combined condition check was unreachable due to sequential else if statements. The corrected version addresses these issues.

import java.util.Scanner;

File Management

File management is the system an operating system uses to organize and keep track of data. The operating system stores data in units called files, determines how files are stored, efficiently uses available storage space, creates a record of all file usage, and carries out every task related to files and folders.

File names typically have this structure:

filename.extension

Task and User Management

Task Management

Task management is the part of the operating system that controls the running of one or more programs on a computer simultaneously. Today's widely used operating systems support multitasking, allowing multiple tasks to run concurrently, taking turns using the computer's resources.

User Management

With user management, the operating...

1. Speed

Computers process data at an extremely fast rate. In a few seconds, they can perform tasks that would take a human days or even years to complete. Computer speed is measured in MHz (Megahertz) or GHz (Gigahertz).

• Microcomputers: Execute millions of instructions per second consistently without error.
• Supercomputers: Operate at speeds measured in nanoseconds and picoseconds, performing tasks one thousand to one million times faster than microcomputers.

2. Accuracy

Computers are highly accurate, though performance depends on the instructions provided. Because computers only execute what they are programmed to do, faulty instructions lead to faulty results—a concept known as GIGO (Garbage In, Garbage Out).

While errors can occur, advanced...

Understanding Computer Networks

• A computer network is the interconnection of multiple devices, generally termed as hosts, connected using multiple paths for the purpose of receiving data or media.
• Connected devices share information and resources.
• The channel or line is where this information is transmitted.

Computer Network Classifications

Networks can be classified in several ways:

1. By Size: The most common classification.
2. By Property
3. By Connection Method
4. By Topology

1. Network Classification by Size

• LAN (Local Area Network): Maximum of a building. The most frequent type, common in most offices.
• MAN (Metropolitan Area Network): Maximum of a city, connecting different buildings.
• WAN (Wide Area Network): Connects devices from different cities or even countries.

Understanding Parsers and Abstract Syntax

A Parser is a program that translates terms in concrete syntax into abstract syntax.

• In our language (PLAI, not Racket), we use {braces} instead of (parentheses) to distinguish concrete syntax from Scheme by looking at the delimiters.
• The parser identifies the program structure and converts it to the appropriate abstract syntax. This requires a clear specification of the concrete syntax using Backus-Naur Form (BNF).

Arithmetic BNF Specification

<AE> ::= <num>
      | {+ <AE> <AE>}
      | {- <AE> <AE>}

• The <AE> in BNF is a non-terminal, meaning it can be rewritten as one of the items on the right-hand side.
• The ::= symbol means “can be rewritten as.”
• Each | presents

Data Manipulation with dplyr

Ordering Rows with arrange()

Selecting Columns with select()

Creating New Variables with mutate()

Creating Functions with Vector Arguments