Notes, summaries, assignments, exams, and exercises for Technology for Primary education

Database Data Independence, Schemas, and Architecture

Technology13.1 KB

Data Independence in Database Systems

Building on the 3-level architecture we discussed, Data Independence is the practical benefit of that structure. It is the ability to modify a database schema at one level without requiring a change to the schema at the next higher level. This ensures that as your database grows or your hardware changes, you don't have to rewrite your entire software application.

1. Physical Data Independence

Physical Data Independence is the ability to change the Internal/Physical schema without affecting the Conceptual schema.

Basically, you can change how the data is stored on the disk without changing the logical structure (the tables and relationships).

  • Where it happens: Between the Internal level and the Conceptual level.
...
Continue reading "Database Data Independence, Schemas, and Architecture" »

Understanding Computer Networks: Types, Components, and Protocols

Technology2.85 KB

Understanding Computer Networks

A computer network is a set of computers connected to each other, enabling them to share resources and exchange information. They can share printers, files, folders, and Internet connections.

Ethernet Classification

The two common types of Ethernet networks are 100Base-T and 1000Base-T.

The number indicates the transmission speed in Megabits per second: 100Mbps and 1000Mbps, respectively.

The letter 'T' indicates the type of cable used to transmit data. The cable consists of twisted pairs of copper wire with RJ45 connectors at each end. These cables are used to connect the network.

Types of Cables

  • Twisted Pair UTP: 8 copper wires twisted together in 4 pairs with an RJ45 connector at the end.
  • STP: A safer cable for transmitting
...
Continue reading "Understanding Computer Networks: Types, Components, and Protocols" »

Surface Analysis Techniques: STM, AFM, and Tribocorrosion

Technology4.52 KB

Scanning Tunneling Microscopy (STM) and Atomic Force Microscopy (AFM)

Scanning Tunneling Microscopy (STM)

Scanning Tunneling Microscopy (STM) is an instrument used for imaging surfaces at the atomic level, revealing the topography of conductive specimens. It measures tunneling current and can be used in air, water, and various gas environments, at temperatures ranging from near zero Kelvin to a few hundred degrees Celsius. STM operates in two modes: constant interaction mode and constant height mode.

Advantages of STM

  • High resolution, not limited by diffraction
  • Small sample size
  • Can modify samples to create small structures
  • Does not require a partial vacuum

Disadvantages of STM

  • Difficult to determine detailed shapes
  • Slow scanning speed
  • Small image sizes
  • Not
...
Continue reading "Surface Analysis Techniques: STM, AFM, and Tribocorrosion" »

Essential Building Components: Walls, Roofs, Floors, and Stairs

Technology3.88 KB

Architectural Walls: Function and Types

Walls create spaces, hold weight, and offer protection. They are categorized primarily by their structural role:

  • Load-Bearing Walls: Support the building's weight.
  • Non-Load-Bearing Walls: Simply divide rooms; these are also known as curtain or partition walls.

Masonry Walls

Masonry walls, typically made of bricks, are known for their strength, longevity, and fire resistance. However, they present several drawbacks:

  • They are heavy and costly.
  • They require significant time to construct.
  • They need plaster and paint for finishing.
  • They often require additional insulation for optimal sound and temperature control.

Roof Systems: Protection, Structure, and Materials

Roofs protect buildings from the weather and must be...

Continue reading "Essential Building Components: Walls, Roofs, Floors, and Stairs" »

Aircraft Flight Operations Checklist: Pre-flight to Landing

Technology4.74 KB

Pre-Flight & Taxi Procedures

Before Taxi

  • Pitot Heat: Check
  • Ammeter: Check rise
  • Taxi Clearance: As Required
  • Altimeter: Set and check
  • Transponder: Set code
  • Propeller: Full forward
  • Area: Clear

Taxi

  • Throttle: Idle
  • Parking Brake: Release
  • Landing Light: On
  • Brakes: Check
  • Steering: Check
  • Flight Instruments: Check
  • Takeoff Brief: Perform

Takeoff & Climb Procedures

Takeoff

  • Area Ahead: Clear
  • Transponder: ALT
  • Strobe & Landing Lights: On
  • Fuel Pump: On
  • Propeller: Full forward
  • Mixture: Full forward
  • Flaps: Set
  • Trim: Takeoff setting
  • Directional Gyro: Set
  • Takeoff Clearance: Received
  • Throttle: Full forward
  • Engine Gauges: Check

After Takeoff

  • Brakes: Apply
  • Gear: Up
  • Airspeed: Refer to table
  • Flaps: Up
  • Throttle: Full forward
  • Propeller: 2700 RPM
  • Landing Light: Off
  • Fuel Pump: On
  • Engine Gauges:
...
Continue reading "Aircraft Flight Operations Checklist: Pre-flight to Landing" »

Harnessing Renewable Energy: Eolian and Tidal Power Explained

Technology3.29 KB

EOLIC ENERGY

1. How It Is Obtained and Its Characteristics

  • It is obtained from the wind's kinetic energy.
  • The sun heats the Earth's air unevenly. The temperature differences in different locations cause air masses to move.

Characteristics of Wind:

  • Speed: Higher wind speed results in greater power generation.
  • Permanent Wind Zones: Areas with consistent wind patterns are ideal for wind energy production.
  • Elevation: Wind speeds are typically higher at higher elevations.
  • Power Density: Measured in watts per square meter (W/m²).

2. Parts of a Wind Power Plant

  • Propeller (Blades):
    • Number of blades varies depending on the motor (typically one to six).
    • Made from lightweight materials like carbon fiber.
    • Spin the shaft, which drives the generator.
    • Types: Horizontal-
...
Continue reading "Harnessing Renewable Energy: Eolian and Tidal Power Explained" »

Mechanical Gear Systems and Transmission Ratios

Technology3.42 KB

Gear Speed and Transmission Ratio Calculations

For Gears 2 and 3, the speed calculation is: Nm x Zm = Ns x Zs. The transmission ratio for gears is defined as: Zm / Zs = Nm / Ns.

For chain transmission, the formula remains: Nm x Zm = Ns x Zs.

Fundamental Gear Characteristics

Gears are mechanical elements designed to transmit turning movements. There are two main characteristics of gears:

  • The fundamental characteristic is the number of teeth it has, which is represented by the letter Z.
  • The other characteristic is the rotational speed, represented by the letter N, which is measured in RPM (revolutions per minute).

Gear Sizes and Rotational Speed

If two gears have a different number of teeth, and the output gear is larger than the motor gear, it will

...

Continue reading "Mechanical Gear Systems and Transmission Ratios" »

Hydroelectric Power Generation: Components and Types

Technology4.2 KB

Hydroelectric Energy: How It Works

Hydroelectric energy is produced by the force of falling water. The capacity to produce this energy is dependent on both the available flow and the height from which the water falls. As water accumulates, it builds up potential energy, which is then converted into mechanical energy. This mechanical energy drives the turbine, and the generator subsequently produces electricity.

Dams: Structure and Function

A dam is constructed to create a reservoir, storing water during periods of high flow in the river. There are two main types of dams:

  • Gravity Dams: These are made from concrete or masonry. They rely on the weight of their material to resist the force of the water. Gravity dams are suited to sites with either
...
Continue reading "Hydroelectric Power Generation: Components and Types" »

Computer Hardware, Software, and Peripherals: A Comprehensive Look

Technology5.33 KB

Computer Basics

A computer is a device that processes data according to a set of instructions known as a program.

Hardware and Software

Hardware: The equipment. Software: The programs and data.

Operating System

The operating system is a special set of programs that provides an interface for the user and allows application programs to communicate with the hardware.

Application Programs

Application programs include:

  • Word processors (for creating and editing texts)
  • Spreadsheets (for calculating mathematical formulae)
  • Databases (for storing data in a way that allows the data to be sorted and searched)

Antivirus Programs

Antivirus programs are used to detect and remove viruses (harmful programs that can reproduce themselves and attach themselves to other programs)...

Continue reading "Computer Hardware, Software, and Peripherals: A Comprehensive Look" »

Understanding Density, Pressure, and Fluid Systems

Technology45.77 KB

Know what the relationship is between density and temperature

Substances have different densities depending on their temperature.  

For example, a lake on a hot summer day. The surface temperature is warmer than the water beneath. The warm water floats on the cold because it has a lower density. 

Know why your ears pop when you are landing at an airport

Your ears pop from pressure change. The change of pressure outside causes your middle ear to have to readjust, resulting in a popping sound

Know the term buoyancy and why objects sink or float in a substance

Buoyancy is the ability of an object in a fluid to rise or sink due to density differences with its surroundings.

Know the densities of some common substances

Sea water

1.03g/mL

distill

1g/mL

Know

...
Continue reading "Understanding Density, Pressure, and Fluid Systems" »