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

Mechatronics engineers are responsible for designing mechanical equipment. Combining their knowledge of computer, mechanical, and electrical engineering, they develop various automated products, such as cameras, cars, and aircraft. The engineering process typically involves designing and assembling components, testing products in development, making improvements, and evaluating finished products. Engineers must also assess equipment and publish reports outlining production factors, such as practical use, safety, and cost.

Work Areas:

• Electronics Development Unit
• Software Development Unit
• Project Management Unit
• Biomechanical Development Unit including our Mechanical Shop and Scientific Glassblower

Mechanical Engineer Job Duties:

• Evaluates mechanical

Computer Memory Types

• Main Memory (RAM): Volatile memory used for active processes.
• Secondary Memory: Non-volatile devices for permanent data and program storage.

Common Secondary Storage Devices

Examples include hard drives, floppy disks, CD-ROMs, and DVD-ROMs.

Principles of Data Storage

• Magnetic: Uses magnetic particles polarized in specific directions to represent logical 1s and 0s (e.g., hard drives, floppy drives, and tape drives).
• Optical: Utilizes lasers for reading and writing data without magnetic interference.
• Magneto-optical: A hybrid storage technology.

Hard Disk Drive (HDD) Architecture

The HDD is a primary secondary storage device consisting of several metal platters coated with a magnetic layer. Read/write arms access information on both...

What is APOO?

APOO (Analysis and Object-Oriented Programming) considers a problem and a solution from the perspective of objects, things, or concepts. APOO is the investigation of domain objects and their relationships.

What is OOP?

OOP (Object-Oriented Programming) is a logical solution in terms of software components and their collaborations and responsibilities.

UML Language

The UML (Unified Modeling Language) is the standard language for typesetting to view the results of the analysis and design.

Subactivities:

1. Define essential use cases.
2. Draw use case diagrams.
3. Refine the conceptual model.
4. Refine the glossary.
5. Set system sequence diagrams.
6. Set operation contracts.
7. Set state diagrams.

What is a Use Case Diagram?

A use case diagram is used to identify...

TCP/IP Transport Layer Fundamentals

1. Transport Layer Header & Session Description

On the basis of the transport layer header shown in the diagram (not provided), what statements describe the established session?

This TCP header contains a Telnet request.

2. TCP/IP Data Encapsulation & Known Port Numbers

With TCP/IP data encapsulation, which range of port numbers identifies all known applications?

0-1023

3. Purpose of Port Numbers in TCP Headers

Why are port numbers included in the TCP header of a segment?

To allow a receiver to transmit data to the appropriate application.

4. OSI Model Layer for Reliable Flow Control

What OSI model layer is responsible for regulating the flow of information from the source to destination, reliably and accurately?...

jQuery: Simplify Your JavaScript

jQuery is a fast, small, and popular JavaScript library. Its motto is "Write less, do more." Before jQuery, writing plain JavaScript for interactivity required complex code that often behaved inconsistently across browsers. jQuery wraps these tasks into simple, short commands that work perfectly everywhere.

Think of it as a handy shortcut dictionary for JavaScript.

The Basic Syntax

Every jQuery command follows this pattern:

• $: Points to jQuery, signaling its use.
• (selector): Finds the HTML element to modify.
• .action(): Defines the operation (e.g., hiding, styling, or animating).

1. jQuery Selectors

Selectors "grab" HTML elements using CSS-style syntax.

• Element Selector: $("p") selects all paragraph tags.
• ID Selector: $

Information Systems and Business Importance

Q1. Explain the various information systems. Briefly explain the importance of Information System for business. (20 Marks)

Information Systems (IS) are structured combinations of people, hardware, software, networks, and data resources that collect, transform, and disseminate information in an organization. These systems help businesses in decision-making, coordination, control, analysis, and visualization of information.

Types of Information Systems

• Transaction Processing System (TPS): TPS is used to record day-to-day transactions like sales, receipts, cash deposits, payroll, etc. It is crucial for the functioning of operational-level employees. For example, a billing system at a retail store is a TPS.

Input three numbers and find the largest. Enter a number and display the day name of the week.
#include
#include
using namespace std;
using namespace std;
int main() {
int num1, num2, num3;
int day;
cout << "Enter three numbers: ";
cout << "Enter a number (From 1 to 7): ";
cin >> num1 >> num2 >> num3;
cin >> day;
if (num1 > num2 && num1 > num3) {
cout << "Largest number is " << num1;
} else if (num2 > num3) {
cout << "Largest number is " << num2;
} else {
cout << "Largest number is " << num3;
}
switch (day) {
case 1: cout << "Sunday"; break;
case 2: cout << "Monday"; break;
...

SQL*Plus is the version of SQL used to access Oracle databases

1.True

2.False

SQL*Plus del command can delete all lines from the buffer at once

1.True

2.False

There is no difference between the CHAR and VARCHAR2 data types. They are just spelled differently

1.True

2.False

Which command(s) set the title of SQL*Plus report

1. Set Headsep
2. Column
3. Set PageSize
4. Set Line Size
5. Edit
6. Define_Editor
7. Start
8. Remark
9. /* */
10. Host
11. Ttitle
12. Btitile
13. @
14. Break On
15. Compute Sum
16. Set NewPage
17. Set Pause
18. Save
19. Host
20. Command is not in the list
21. Command does not exist

Table in Oracle cannot be created if the primary key is not specified

1.True

2.False

Alternate key may contain NULL values

1.True

2.False

Table can have several alternate keys, but only one primary key and one foreign key

1.True

2.False

Which command(s) is/...

Wide Area Networks

Applications utilize application-level protocols (such as MQTT, CoAP, HTTP, and WS) to communicate effectively across networks.

MQTT: Publish/Subscribe Messaging

MQTT is a lightweight messaging protocol based on TCP/IP. It utilizes Quality of Service (QoS) levels to manage delivery:

• QoS 0 (At Most Once): Messages are sent with no guarantee of arrival.
• QoS 1 (At Least Once): Subscribers acknowledge message reception. The broker stores the message and retries until an acknowledgment is received.
• QoS 2 (Exactly Once): The most reliable delivery method. The broker ensures messages are delivered to subscribers without duplicates.

MQTT Security

MQTT does not provide native security. It can utilize TLS/SSL encryption for data in transit,...