Notes, summaries, assignments, exams, and exercises for Technology for University

Basic SQL Statements: DDL and DML Commands

Data Definition Language (DDL) Commands

DDL commands are used to define or modify the structure of database objects. All DDL commands are auto-committed, meaning they save all changes permanently in the database immediately after execution.

The primary DDL commands are:

• CREATE
• ALTER
• TRUNCATE
• DROP
• RENAME

CREATE Command

The CREATE command is used to define a new table structure. It uniquely defines each column, specifying its name and data type. Each column definition is separated by a comma, and the SQL statement is terminated with a semicolon.

Syntax:

CREATE TABLE table_name (
    column_name1 datatype1,
    column_name2 datatype2,
    ...
    column_namen datatypen
);

Example:

CREATE TABLE Student (
    reg_no

Mechanical Pump: Concept and Operation

The mechanical pump is the most used artificial lift method worldwide. This method consists of an underground pump with reciprocating action, which is supplied with power produced by a string of rebar. Energy comes from an electric motor or internal combustion engine, which mobilizes a unit area through a gear system and straps. The mechanical pump has its largest application in the global production of heavy and/or extra-heavy crudes, but is also used in the production of medium and light crudes.

Many theories explain the behavior of production wells by mechanical pumping. Some operators prefer to produce a coated pit open to the atmosphere and closed with the casing; this mechanism really depends on the...

Types of Knives

Chef's Knife (Cebollero)

• All purpose knife for peeling, trimming, chopping, slicing, and dicing
• Triangular blade, rock chop

Utility Knife or Salad Knife

• All purpose, smaller than the chef's knife
• Used specially for peeling and slicing fruit and vegetables

Santoku Knife or Japanese Cook's Knife

• Sheep's foot tip
• Top chop

Paring Knife

• Used for paring or peeling fruits and vegetables

Tournée Knife

• Sometimes considered as a kind of paring knife
• Used for turning vegetables

Slicer Knife

• Long slender and flexible blade
• Used for carving or slicing cooked meats

Bread Knife or Serrated Slicer

Used to cut bread, cakes, and similar food

Boning Knife

• Thin and pointed blade
• Used for boning raw meats, poultry, and fish
• Used for trimming fat from meats

Filleting Knife

• Pointed

Understanding Electrical Safety and Protection

The physiological effects and after-effects of electric current are determined by several critical factors:

• Type of current
• Current magnitude
• Frequency
• Duration of current passing through the body
• Resistance of the human body
• The insulation properties of the skin

Conductor Identification: Notation and Colors

Proper identification of conductors is crucial for electrical safety. Here are the standard notations and colors for insulated conductors:

• Working Conductor: Wire of the current system for power supply and energy transmission. Colors: Black, Brown, and Grey.
• Neutral Conductor: Wire connected to the source node, which contributes to energy transmission. Color: Light Blue.
• Protective Conductor: Wire required

1. Construction Machinery Administration

R: Administration is essential for optimal operation of construction machinery in all relevant processes.

2. Machine Definition

R: A machine is a set of moving and fixed parts that leverages, manages, regulates, or transforms energy to perform work.

3. Machinery Definition

R: Machinery refers to a set of machines with a common purpose and the mechanism providing motion.

4. Machine Components

R: The main components are: Motor, mechanism, chassis, and safety components.

5. Motor

R: The motor converts energy to perform the required work.

6. Mechanism

R: The mechanism is a set of mechanical elements, some mobile, transforming motor energy into the desired output.

7. Chassis

R: The chassis is the rigid structure supporting...

Character Devices and Block Devices

Character devices read and write data as a byte stream. Examples of character devices are printers and keyboards that allow the handling of a single byte at a time.

Block devices read and write information in fragments ("blocks") to the block device at a time. Examples include hard drives, floppy disks, and CD/ROM drives.

Locate Command

The locate command writes the names of files and directories that match a given pattern. It is the fastest of the two commands because it depends on a database (updated daily by default) instead of looking in real-time. It finds files that have been deleted since the last update of the database.

bzip2 Command

The bzip2 command tends to generate more compact compressed files but...

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

Railway Track Crossings: Name, Schema Usage, and Design

Crossings are essential devices that ensure the continuity of connections via different paths and can provide maximum security. They consist of combinations of two devices:

• Bypass: Allows the separation of a railroad into two or more tracks.
• Journey: Allows the intersection of two roads.

Components of Diversions and Crossings

Diversions and crossings are formed from three elements:

• Change: The contra-needle assembly. The needle is the mobile part, and the immobile part is the contra-needle. The end of the needle tip, which is not machined, connects to the union rails and is called the heel. The contra-needle is a normal lane. The needle has to transition from one lane to become normal to an

Industrial Robots: Definition and Applications

An industrial robot is an automatic manipulation machine, programmable with three or more axes, capable of positioning or orienting materials to execute diverse tasks. Its primary functions include:

• Manipulation: The main robot task is to move a part from one place to another, often for:
  • Assembling
  • Packaging
  • Machine tending
• Processing: The robot performs operations on a part, transforming it through processes such as:
  • Welding
  • Spray application
  • Cutting

Service Robots: Examples and Functions

Service robots are designed to assist humans in various non-industrial settings. Examples include:

• Telesurgery
• Assistance for dependent people
• Companionship and entertainment
• Medication dispensing

Technical Specifications: Catalogs