Notes, summaries, assignments, exams, and exercises for Computer science for Primary education

MapReduce is a computing paradigm for processing data that resides on hundreds of computers, which has been popularized recently by Google, Hadoop, and many others. The paradigm is extraordinarily powerful, but it does not provide a general solution to what many are calling “big data,” so while it works particularly well on some problems, some are more challenging. This book will teach you what problems are amenable to the MapReduce paradigm, as well as how to use it effectively. At first glance, many people do not realize that MapReduce is more of a framework than a tool. You have to fit your solution into the framework of map and reduce, which in some situations might be challenging. MapReduce is not a feature, but rather a constraint....

Creating Engaging Multimedia Presentations

A presentation is a multimedia file that can contain text, graphics, photos, music, and video. Its organization is done by slides, which succeed one another under your control. Templates are presentations that have predefined design objects in the slides, such as the background, fonts, placement of text, and other objects that give the presentation a common appearance across all slides.

Interactivity: Establishing Hyperlinks

Interactivity is established by creating hyperlinks. Clicking on a button or text performs an action, such as opening a file or linking to a website. You can insert a hyperlink from the Insert menu, then selecting Hyperlink.

Interactivity in objects allows navigation to different slides...

This document provides practical SQL Data Definition Language (DDL) examples for creating and modifying database schemas across various common applications. Each section details the necessary tables and their relationships, offering a clear foundation for building robust relational databases.

Library Management System Database

The following SQL DDL statements define the core tables for a library management system, enabling the tracking of books, members, and loan transactions.

Table Creation

CREATE TABLE Books (
    BookID INT PRIMARY KEY,
    Title VARCHAR(100) NOT NULL,
    Author VARCHAR(100) NOT NULL,
    ISBN VARCHAR(20) UNIQUE,
    PublishedYear INT CHECK (PublishedYear >= 1500 AND PublishedYear <= 2025)
);

CREATE TABLE Members (

CPU Internal Registers

Internal registers are a set of temporary storage units available to the Central Processing Unit (CPU) for its operation. They serve as high-speed storage locations within the CPU itself.

The size of these registers depends on the function to be performed and the type of CPU. They generally match the size of the Data Bus or the Address Bus.

Classification of CPU Registers

CPU registers are broadly classified into two main types:

• Inaccessible Registers: Not directly controllable by the user.
• Accessible Registers: Controllable by the user.

Inaccessible Registers

Inaccessible registers are those whose operation or content the user cannot directly control. They are for the exclusive and restricted use of the CPU. From the user's...

Database Architecture

The definition of an information system is the detailed description of the system architecture.

Internal Level

The lowest level of abstraction, defining how data is stored on hardware and accessed. Responsibilities of the Database Administrator (DBA) include managing:

• Block size
• Relative position of stored records
• Addressing methods
• Overflows
• Indexing
• Storage changes
• Compression techniques

Conceptual Level

The mid-level of abstraction, representing the organization's data. This level encompasses partial views of different users' requirements and potential uses. It provides a total organizational vision, including data definitions and relationships. DBA responsibilities include:

• Defining the data stored in the database:
  • Data name
  • Attributes
  • Relationships

Understanding the Instance Relationship

In Artificial Intelligence and knowledge representation, the "instance" or "instantiates" relationship describes the connection between an individual object (an instance) and the class or concept (the type) it belongs to.

Explanation of Instance Relationship

• An instance is a specific object or entity that belongs to a broader category or class. For example, "Snoopy" is an instance of the class "Dog."
• The instantiates relation links this individual object to the class it is part of. It shows that the object "is a specific example of" that class.
• This is different from the "is-a" (ISA) or subclass relationship, which connects broader categories or classes to more specific subclasses. The instance relation connects

Radio Buttons

Radio buttons allow you to choose only one option among multiple. If an option wasn't previously selected, it can be automatically changed. Radio buttons with the same name are grouped together, ensuring that only one option within that group can be selected at a time.

Gender: Male Female

Checkboxes

Checkboxes allow you to choose one or more options from a list. Unlike radio buttons, a name attribute is not required for grouping.

Activities: Yoga Boxing

To check if a checkbox is selected in JavaScript, you can use the following code within a button's function:

if (document.getElementById("checkbox_id").checked == true)

To reset a checkbox, use:

document.getElementById("checkbox_id").checked = false;

Sensors

Senses allow us to collect information...

Gantt Chart: A Project Planning and Control Method

A Gantt chart is a graphical method of planning and control in which a project is divided into different activities, and estimates are made about how long each activity takes. This chart shows the timing relationships between events of a program and was developed by Henry L. Gantt. Gantt charts are useful for monitoring relatively small projects.

Understanding Key Concepts

• Task: Project activities are carried out in a particular sequence.
  • Predecessor Task: A task that must start or finish before another can begin.
  • Successor Task: A task that depends on the start or finish of a preceding task.
  • Summary Tasks: These are made up of subtasks and summarize those subtasks.
• Milestones: A task without duration

C++ Code Examples: Data Filtering and Sorting

This document presents two fundamental C++ programming examples. The first demonstrates how to process user input to extract and display only unique integer values, effectively removing duplicates. The second illustrates the classic Bubble Sort algorithm for arranging elements in ascending order within a std::vector.

Filtering Duplicate Integers in C++

This C++ program prompts the user to enter 20 integers. It then processes these inputs to identify and store only the unique values, discarding any duplicates. Finally, it displays the list of non-duplicate integers.

Program Description: Unique Element Extraction

• Initializes an array a of size 20 to store unique elements, along with a subscript to track

Computer Hardware

Core Components

CPU (Central Processing Unit)

The CPU controls and executes operations within the computer to process information. It consists of:

• CU (Control Unit): Coordinates all computer activities and manages temporary data storage.
• ALU (Arithmetic and Logic Unit): Performs basic data operations.

Memory

• Random Access Memory (RAM): Enables reading and writing operations, allowing access to random memory locations.
• Read Only Memory (ROM): Contains permanent instructions for computer startup, forming the BIOS (Basic Input Output System).

Input/Output Units

These units facilitate communication between the CPU, internal components, and external devices.

Buses

Buses enable efficient information exchange between computer components. Types...