Notes, summaries, assignments, exams, and exercises for Computer science for Vocational training

Understanding Computer Memory: Types, Features, and RAM

Computer science2.48 KB

Understanding Computer Memory

Memory Types

Main Memory

Main memory is integrated into the system's firmware and directly governed by the CPU. It stores the boot process, data from the stack, memory-resident programs, and the user program currently executing.

Types of Main Memory:
  • Ferrite memories (obsolete)
  • Integrated memory:
    • RAM (Random Access Memory)
    • ROM (Read-Only Memory)
    • PROM (Programmable ROM)
    • EPROM (Erasable Programmable ROM)
    • OTP Memory (One-Time Programmable ROM)
    • EAROM (Electrically Alterable ROM)

Cache Memory

Cache memory is located within the CPU and communicates directly with it. It stores frequently used data to reduce access time from main memory.

Mass Memory

Mass memory refers to storage devices with higher capacity, typically peripherals.

Types
...
Continue reading "Understanding Computer Memory: Types, Features, and RAM" »

MySQL Essentials: Database & Table Management Commands

Computer science5.6 KB

MySQL Essentials: Database & Table Management

Connecting to MySQL

To connect to a MySQL server, use the following command:

mysql -u [username] -p [password]

Database Operations

Viewing Databases

To see all available databases:

SHOW DATABASES;

Creating a Database

To create a new database:

CREATE DATABASE [database_name];

Selecting a Database

To select a database to work with:

USE [database_name];

Table Operations

Viewing Tables

To list all tables within the currently selected database:

SHOW TABLES;

Viewing Table Structure

To display the structure (columns, data types, etc.) of a specific table:

DESCRIBE [table_name];

Creating a Table

To create a new table within the selected database:

CREATE TABLE [table_name] (
    [field_name_1] [data_type_1] [field_definitions_
...
Continue reading "MySQL Essentials: Database & Table Management Commands" »

Types of RAM Modules: DIMM, DDR, RIMM, FB-DIMM, GDDR, SO-DIMM

Computer science2.93 KB

Memory Modules

Small printed circuit boards built on different memory chips:

  • DIMM (Dual In-Line Memory Module): Similar to the SIMM, physically larger, and have 168 contacts. They are distinguished by having a notch on both sides and two more in the row of contacts. The mounting of the sockets is different than that of the SIMM. DIMMs are found in 32, 64, 128, 256, 512 MB, and 1, 2 GB capacities.
  • DIMM DDR: Has gradually replaced the standard DIMMs. It has a total of 184 pins instead of the 168-pin DIMM of SDRAM. Physically, they resemble the above but have one notch in the row of contacts.
  • DIMM DDR2: Has 240 pins and a notch in a different position than DDR DIMMs.
  • DIMM DDR3: Also has 240 pins but is neither physically nor electrically compatible
...
Continue reading "Types of RAM Modules: DIMM, DDR, RIMM, FB-DIMM, GDDR, SO-DIMM" »

Essential Number Properties and Divisibility Rules

Computer science4.22 KB

Fundamental Number Concepts

Prime Numbers Up to 97

Here is a list of prime numbers up to 97:

  • 2
  • 3
  • 5
  • 7
  • 11
  • 13
  • 17
  • 19
  • 23
  • 29
  • 31
  • 37
  • 41
  • 43
  • 47
  • 53
  • 59
  • 61
  • 67
  • 71
  • 73
  • 79
  • 83
  • 89
  • 97

Rules for Exponents

Understanding how exponents work is crucial for various mathematical operations:

  • Positive Base: If the base (m) is positive, the result (b) of mn = b is always positive.
  • Negative Base, Even Exponent: If the base (-M) is negative and the exponent (n) is an even number, the result (+b) of (-M)n = +b is positive.
  • Negative Base, Odd Exponent: If the base (-M) is negative and the exponent (n) is an odd number, the result (-b) of (-M)n = -b is negative.

Powers of Decimal Numbers

Here are examples of squaring and cubing decimal numbers:

  • 1.12 = 1.21
  • 0.42 = 0.16
  • 0.032 = 0.0009
  • 0.23 = 0.008

Divisibility Criteria

Divisibility...

Continue reading "Essential Number Properties and Divisibility Rules" »

Mastering Page Layout: Essential Elements and Formats

Computer science4.81 KB

Elements of Page Layout

Clean layout: Visual elements in good order.

Layout elements are three essential elements:

Format: The size or area of the paper on which our design will be printed.

Many formats are according to user needs, such as books, magazines, etc.

Margins: The surrounding areas that respect each box and the edge of the paper.

May be varied according to design. (Head, Spine, Foot, and Fore-edge).

The Box: This is the real space and limiting area where we diagram and fit the elements of the page.

In Microsoft Publisher, the document box appears delineated by a blue box on the page.

Chaotic layout: Items at random, without aesthetic consideration.

What is Page Layout?

It is the attempt to balance the elements across pages, organizing the masses...

Continue reading "Mastering Page Layout: Essential Elements and Formats" »

Understanding Computer Systems: Hardware, Software, and Key Concepts

Computer science3.17 KB

1. Computer System

The set of physical elements (Hardware) and software (Software) that allow information processing.

2. Physical Subsystem

Commonly known as hardware.

3. Logical Subsystem

Referred to as software.

4. Computer

An electronic device capable of processing data, performing load, arithmetic, and logic operations without human intervention.

5. Informatics

The science that studies the automatic and rational treatment of information.

6. Automatic and Rational

  • Automatic: Tasks are performed by machines.
  • Rational: Processes follow human reasoning.

7. Central Processing Unit (CPU)

Responsible for implementing programs and comprises the main memory, control unit, and arithmetic-logic unit.

8. Supercomputer

A specialized machine designed for tasks requiring...

Continue reading "Understanding Computer Systems: Hardware, Software, and Key Concepts" »

MS-DOS Memory Management: Conventional, Upper, Expanded

Computer science3.53 KB

MS-DOS Memory Management

The memory management depends on the version of MS-DOS we use and the CPU that we have.

Processor Memory Limits

Processors have different address limits:

  • 8088 / 8086 (XT): handle up to 1 MB
  • 286 (AT): handle up to 16 MB
  • 386: handle up to 4096 MB

Conventional Memory

Conventional memory is where programs run; you must manage it properly and release memory when possible.

0 Kb

S.O.

Contains the interrupt table, computer specification, etc.

2 KB

Core MS-DOS Files

The core files include (examples by version):

  • IO.SYS (depending on the version)
  • MSDOS.SYS (system)
  • Other variable core components

Order File (CONFIG.SYS)

Configuration directives and settings found in CONFIG.SYS:

  • BUFFERS
  • FCBS
  • FILES
  • LASTDRIVE
  • STACKS

Device Drivers

Device drivers loaded via

...

Continue reading "MS-DOS Memory Management: Conventional, Upper, Expanded" »

Computer Architecture Fundamentals: CPU, Memory, Buses, and Addressing

Computer science3.52 KB

Core Computer Architecture Components

CPU Registers Explained

CPU registers are small, high-speed storage locations within the central processing unit (CPU) that hold data and instructions for immediate processing.

Accumulator Register

The Accumulator Register stores the results of executed operations. It connects to input registers for feedback in chained operations and also connects to the data bus for sending results to main memory or the control unit.

Program Counter (PC)

The Program Counter (PC) stores the memory address of the next instruction to be executed.

Instruction Register (IR)

The Instruction Register (IR) contains the instruction currently being executed.

Understanding Computer Buses

A bus is a channel or set of parallel connections that...

Continue reading "Computer Architecture Fundamentals: CPU, Memory, Buses, and Addressing" »

Workshop Workload and Production Capacity Management

Computer science3.82 KB

Workshop Planning and Control

Planning

Planning aims to coordinate workload with available resources and equipment to perform the required services in production, or the quantity and quality required, at the lowest cost and meeting the deadline.

Organization

Methods, order, time > budget OR > acceptance > delivery term.

Workload

The workload is the amount of work available for the workshop, consisting of the OR already issued and accepted by clients.

Production Capacity

Production capacity is the amount of work that the workshop can perform based on available operators, equipment, and facilities.

The workload can be defined in a working or time to implement and scale, or are uncertain about working with an open OR work involving a diagnostic...

Continue reading "Workshop Workload and Production Capacity Management" »

Shared Memory in IPC: Features and Creation

Computer science2.8 KB

Common Features of IPC Light Mechanisms

These mechanisms are implemented as a unit and share common features, including:

  • All mechanisms have a table whose entries describe their usage. Each table entry has a numerical key chosen by the user.
  • Each mechanism has a 'get' call to create a new entry or retrieve an existing one. The parameters of this call include a key and a mask of flags. The kernel searches the table for an entry that matches the provided key.
  • If the key is set to IPC_PRIVATE, the kernel occupies the first free entry. Subsequent calls will return this entry until it is released.
  • If the IPC_CREAT flag is active in the mask, the kernel creates a new entry if there is no match for the provided key. If both IPC_CREAT and IPC_EXCL flags
...
Continue reading "Shared Memory in IPC: Features and Creation" »