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

Important Oracle SQL Data Dictionary Views

Important Oracle SQL tablespaces views include: dba_tablespaces, dba_data_files, dba_tables, user_types, user_source.

Creating Complex Object Types

CREATE OR REPLACE TYPE direccion AS OBJECT(
    calle VARCHAR2(50),
    numero NUMBER(3),
    piso NUMBER(2),
    puerto VARCHAR2(1),
    codpostal NUMBER(5),
    localidad VARCHAR2(50),
    provincia VARCHAR2(50)
);

CREATE OR REPLACE TYPE persona AS OBJECT(
    dni VARCHAR2(9),
    nombre VARCHAR2(50),
    apellido1 VARCHAR2(50),
    apellido2 VARCHAR2(50),
    telefono NUMBER(9),
    fecha_nac DATE,
    direccion direccion
);

Creating Tables Using Object Types

CREATE TABLE agenda OF persona;

DESC agenda; -- Visualize table structure


CREATE TABLE agenda2

Information Systems Explained

Definition of an Information System

An information system is a set of interrelated components that collect, process, store, and distribute information to support decision-making, coordination, and control within an organization.

Key Activities in an Information System

• Input: Capturing raw data from the organization or its external environment.
• Processing: Converting raw data into a more meaningful form.
• Output: Transferring processed information to the people or activities that will use it.

Understanding the Internet of Things (IoT)

Meaning and Impact of IoT

The Internet of Things (IoT) represents a revolution in the relationship between objects and people, connecting them to the network and enabling real-time data exchange.... Continue reading "Essential Digital Concepts: Information Systems, IoT, and Web Evolution" »

Azure Core Services & Features

Application Gateway & Web Application Firewall

• Service: Azure Application Gateway
• Feature: Web Application Firewall (WAF)

Messaging & Integration

• XML Message Handling: Azure Service Bus
• Recommended Serverless Solution: Azure Logic Apps and Azure Functions
• Event Grid C# Response: Azure Functions in Consumption Plan

Content Delivery & User Proximity

• Solution for Data Proximity to User: Content Delivery Network (CDN)

High-Performance Computing (HPC)

• HPC Cluster Node Management: CycleCloud

Application Hosting & Scalability

General Hosting Solutions

• App1 Hosting Solution: Load Balancer with VM Scale Set across two availability zones
• Service1 Hosting: VM Scale Set
• Deployment of Two VMs with Traffic Manager: Recommended
• VM

Resistors

• Longer side on positive
• Limit current through circuit
• Measured in ohms (Ω)

Voltage, Current, and Resistance

• Voltage (V): Exerted force to push electricity
• Current (I): Amount of electricity pushed (measured in Amps)
• Resistance (R): Constraints on the flow of electricity
• V = I*R, R=V/I, I=V/R

Diodes

• Act as stop-gap gates
• Ensure electron flow in intended direction

Motors

• Regular DC motors: Spin at various speeds
• Servo motors: Directional control, moving arm from controllable positions

Serial Communications

• Used to print values to Serial Monitor
• Good for troubleshooting

LEDs

• Light Emitting Diodes
• Light up when required forward voltage is found
• Intensity of light depends on current flow

Photodiodes

• Trip to reception of light, not emission of it
• Basics of solar

What is the Difference Between Principle - Principle of Operation?

Brayton Cycle

The continuous combustion cycle.

How Does Engine Thrust Vary?

Low temperature gives greater thrust.

Which Statement is True?

At lower engine speeds...

Static Thrust is Developed

Aircraft on the ground and stationary.

The Fan Bypass Ratio (BPR)

The mass ratio of air that passes...

P2 and P7 Sensors are Pickups for

Inlet and outer pressures.

Thrust

Increases with an increase in speed.

EPR (Engine Pressure Ratio) is

The main parameter that shows the thrust produced.

Compressor Inlet Screens

For protection against Foreign Object Debris (FOD).

Intakes are Designed to

Decelerate the free air stream.

What is the Shape of a Jet Engine Air Intake?

Divergent

Compressor Stall

Is the airflow separation... Continue reading "Jet Engine Fundamentals and Operations" »

The Motherboard: The Backbone of Your Computer

The motherboard is the central component of a computer, connecting all of its parts together. It serves as a platform for the CPU, memory, hard drives, optical drives, video card, sound card, and other ports and expansion cards.

Features of a Motherboard

• Supports various types of components
• Supports a single type of CPU and few types of memories
• Video Cards, Hard disks, Sound Cards must be compatible with the motherboard to function properly
• Motherboards, cases, and power supplies must be compatible to work properly together

Popular Motherboard Manufacturers

• Intel
• ASUS
• AOpen
• ABIT
• Biostar
• Gigabyte
• MSI

The CPU: The Brain of Your Computer

The CPU, or Central Processing Unit, is the brain of the computer. It handles... Continue reading "Motherboard and CPU: The Core Components of a Computer" »

Common Fabrics and Materials

Textiles and Clothing Fabrics

• Terciopelo (Velvet): Gloves, dresses, costumes, and scarves.
• Seda (Silk): Scarves, bed sheets, and handkerchiefs.
• Cotele (Corduroy): Pants, coats, vests, and scarves.
• Lana (Wool): Caps, vests, dresses, and scarves.
• Algodón (Cotton): Vests, jackets, pants, and shirts.
• Lino (Linen): Tablecloths, bedspreads, and shawls.
• Poliéster (Polyester): Bags, coats, hoodies, socks, and jackets.

Durable and Industrial Materials

• Cuero (Leather): Jackets, suits, bags, sneakers, wallets, and shirts.
• Goma (Rubber): Boots, jackets, ponchos, and gloves.
• Plástico (Plastic): Pens, bottles, toys, and boots.
• Gamuza (Suede): Sneakers, boots, belts, and bags.
• Acero (Steel): Screws, chairs, sculptures, and bowls.
• Papel (Paper)

Fundamental Concepts of Forces and Structures

A force is anything that can deform a body (static effect) or change its state of movement or rest (dynamic effect).

Examples of Forces

• Gravity: Pulls us towards the Earth and gives us weight.
• The force of the wind.
• Mechanical forces that move machines.
• Pressures of gases in closed containers.
• The force created by the effects of heat.

A structure is the set of elements in a body that are intended to resist the effects of the forces that act on it. A structure prevents a body from breaking or becoming too deformed.

Loads and Internal Stresses

The forces that act on a structure are called loads.

Types of Loads

• Fixed or Permanent Loads: Do not vary over time.
• Variable Loads: Are occasional and changeable.

Loads... Continue reading "Principles of Structural Mechanics and Applied Forces" »

Mechanisms: Transmitting Force and Motion

Mechanisms are devices used to transmit and convert forces and motion from a driving force or input to an output.

a) Levers

A lever is a rigid bar that is supported by a fulcrum. When a lever is balanced, it complies with the Law of the Lever:

F × d = R × r

Force (F) and Resistance (R) can be measured in Newton [N] or kilograms [Kg], but both must always be in the same unit.

There are 3 kinds of levers according to the position of the Force (F), Resistance (R or Load), and Fulcrum (P or pivot):

• Class 1: Force – Fulcrum – Resistance
• Class 2: Force – Resistance – Fulcrum
• Class 3: Fulcrum – Force - Resistance

b) Pulleys

We will study three kinds of pulleys:

Fixed Pulley

A fixed pulley is a wheel that has... Continue reading "Mechanical Motion and Force Conversion Systems" »

Fossil Fuel Power Stations

Fossil fuels, such as coal, oil, and natural gas, are used to heat water in a boiler. Steam from the boiler turns a turbine, which is connected to the rotor of a generator. The generator produces electricity, which is transported by a network of high voltage power lines. After that, the steam goes to a condenser where it cools and becomes liquid water again. Finally, the water is pumped back to the boiler.

Combined Cycle Power Stations

Electricity is generated in two systems. In the first, natural gas is burned with compressed air. This produces superheated gases which turn a turbine to generate electricity. In the second, the hot gases from the first system are used to produce steam in a heat recovery boiler. Then the... Continue reading "Types of Power Stations: Fossil Fuels, Combined Cycle, Hydroelectric, Geothermal, and Solar" »