Notes, summaries, assignments, exams, and problems for Computers

Understanding Websites and HTML

A website is a document written in HTML (HyperText Markup Language). It is a system that allows us to format text using tags. A web page can be composed of images, sounds, videos, and animations. HTML is a language focused on the transmission of documents using the HTTP protocol.

A website is a collection of pages linked together. These are viewed through programs called browsers, which interpret the tags added to the text, such as:

• Mozilla Firefox
• Google Chrome
• Opera

HTML uses two types of labels: opening (<tag>) and closing (</tag>). A website consists of a header and a body. Common tags include:

• Header: <h1>
• Paragraph: <p>
• Bold: <b>
• Italic: <i>
• Underlined: <u>
• Horizontal Line:

What is Abstraction? Types and Principles

Abstraction is a mental process involving the understanding of phenomena or situations that involve many details. It consists of two key aspects:

• Highlighting the most relevant details of the object under study.
• Ignoring irrelevant details of the object (at that specific level of abstraction).

Abstraction is fundamental for designing programs that are shorter, readable, easy to maintain, and reliable—i.e., quality software.

Programming languages are the tools used by programmers to implement these abstract models. Abstraction in programming is typically divided into two types:

1. Operational Abstraction: It is based on the use of procedures and/or functions without worrying about how they are implemented.

Topic 4: Advanced Tables and Data Analysis

• What is an advanced table?
  The most efficient template for initiating a new database.
• Difference between SUM and COUNT functions:
  The SUM function adds the numerical elements of a column, while the COUNT function calculates the total number of entries in a column.
• Standard Deviation Function:
  A statistical measure used to determine the dispersion or variability of data relative to the mean.
• Table Analyzer:
  An assistant tool that examines a table and suggests whether it should be normalized into two or more separate tables.

Topic 5: Creating and Modifying Fields

• Methods to create a field:
  There are three primary ways to create a field in Microsoft Access.
• Adding fields in views:
  You can add a field in Datasheet

Topic 8: Exporting Data from Access

Exportable File Formats

• SharePoint
• Word files
• Excel documents
• Other Access databases
• Text files

Linked Tables and Data Updates

Changes made to the original Excel data will not be reflected in the linked Access table.

Dividing a Database

An Access database can be split into two files:

• Server File: Contains the tables.
• Client File: Contains forms, reports, and other created objects.

Topic 9: Working with Forms in Access

Simple Forms

Access can automatically generate simple forms from active tables, displaying records in an organized layout and allowing for new data entry.

Form Tools

Form tools simplify the creation of forms by allowing you to select the desired data fields.

Split Forms

Split forms offer two views:

• Form View
• Datasheet

C Example 1: Writing Structured Data to a File

This program demonstrates appending structured date data (assuming struct fecha is defined elsewhere) to a file named Dades.txt. It includes basic file opening and error checking.

#include <stdio.h>
#include <stdlib.h>

int main() 
{
    int temp = 1;
    int auxiliar = 0;
    int i = 0;
    FILE *v1;
    
    v1 = fopen("Dades.txt", "a");
    
    // Note: Variables 'origen' and 'destino' are undefined in this snippet.
    if (origen == NULL || destino == NULL) {
        printf("Problemas con los ficheros.\n");
        exit(1);
    }
    
    printf("Inserte el día, mes y año. El programa finalizará marcando 0 en el día:\n\n");
    
    while (temp != 0) {
        printf("Día:\

Why the 4 + 1 Architecture?

The 4 + 1 architecture model provides different views (logical, process, development, and physical) plus scenarios. This allows for a comprehensive understanding of the system to be built. The 4 + 1 model is also generic.

How Does It Help with Design?

It aids in system design by helping to understand the system's behavior through detailed component design and specifications. This ensures that the functional requirements are met.

Choosing a Construction Methodology

The construction methodology depends on the problem or system being addressed. Therefore, the criterion is paramount when choosing a methodology. Options include:

• Rational Unified Process
• CMMI
• Scrum

Importance of Documentation Standards

Documentation standards facilitate... Continue reading "Software Architecture: Key Concepts and Best Practices" »

Database Management Essentials

Data Recovery

Recovery: Recover data from the sources of error mentioned above. Restoring the database to its normal state is the responsibility of the DBA, who is responsible for implementing the procedures for error detection and recovery.

The DBA is the one with the centralized control of the database. This reduces the number of people who have access to technical and design details for the operation of DBMS.

Concurrency Control

Concurrency: It occurs in a multi-user environment when multiple users try to access the same data object at the same time.

Concurrency occurs when the system is multi-user and does not make adequate controls to synchronize the processes that affect the database. This is commonly referred... Continue reading "Database Management: Recovery, Concurrency, and More" »

Printer Technology Comparison

Translation 2

Printers

Daisy Wheel Printer

The highest quality of printer available is the daisy wheel with flexible stems radiating from the center. The letters are well-defined and can be read clearly. The printer moves bi-directionally, printing both ways from left to right and then right to left. Remember that what is to be printed already exists in the computer's memory, and the daisy wheel does not have to type in sequence as would be expected from a human brain. The carriage therefore does not need to waste time returning at the end of each line.

Dot Matrix Printer

The dot matrix is usually faster than the daisy wheel. The printer has a print head consisting of a row of needles. This moves speedily over the place... Continue reading "Printer Technology Comparison: Daisy Wheel to Laser" »

Historical Operating Systems: A Timeline

This document provides a brief history of operating systems, covering their evolution across different generations.

1st Generation (1945-1955)

Characterized by vacuum valves and machine language. These systems were large, consumed high energy, were very slow, and performed simple mathematical calculations.

2nd Generation (1955-1965)

Transitioned to transistors and batch processing. Systems became smaller and consumed less power.

3rd Generation (1965-1980)

Integrated circuits were introduced, making systems cheaper and enabling multiple processors to run concurrently.

4th Generation (1980-Present)

Marked by the advent of personal computers.

Memory Management

The memory manager is a crucial part of the OS. It is... Continue reading "Evolution of Operating Systems: Generations & Concepts" »

Relational Model: This approach allows users to obtain information from the database without assistance from information management professionals. The data is stored in a way that makes it easier for users to understand. The data is organized as tables, and the relationships between the rows and tables are visible in the data.

Features of Relational Models
It is important to know that the entries in the table are atomic. All entries in any column are of a single type. The table columns are called attributes. No two rows in the table are identical.

Structure of Relational Databases
The relational database model, at the conceptual level, is represented by a collection of stored relations.

Submodel Data
External schemas of relational sub-models are... Continue reading "Understanding the Relational Database Model and Its Features" »