Computing and Communications Archives - Student Notes

SQL Database Design & Query Examples

Posted by admin on Aug 30, 2025 in Computing and Communications | 0 comments

Library Database Schema Definition

This section outlines the SQL Data Definition Language (DDL) statements for creating a library database, including tables for publishers, distributors, customers, articles, books, journals, and rental records.

Database Setup

DROP DATABASE IF EXISTS library;
CREATE DATABASE IF NOT EXISTS library;
USE library;

Table Creation Statements

Below are the DDL statements for defining the various tables within the library database, establishing relationships and constraints.

Publisher

Linux Server Network Services Setup

Posted by admin on Aug 22, 2025 in Computing and Communications | 0 comments

DNS and DHCP Installation Exercise

This document outlines the steps to install and configure essential network services on a Linux server, including DNS (BIND), DHCP, HTTPD (Apache), and VSFTPD.

DNS Server Configuration (BIND)

1. Install BIND Packages

Begin by installing the necessary BIND packages using yum:

[root@localhost ~]# yum -y install bind bind-chroot bind-libs caching-nameserver

2. Configure BIND Named.conf

Edit the main BIND configuration file to define your DNS zones:

[root@localhost ~]# vi

Computer Fundamentals: Hardware, Software, and Data Processing

Posted by admin on Jun 9, 2025 in Computing and Communications | 0 comments

Computer Basics: Definitions and Types

What is a Computer?

An electronic device designed for performing operations on data at high speed.

Computer Types

Desktop: The monitor and computer (tower) are separated. Non-portable.
Laptop: The monitor and computer are integrated. Portable.

Core Computing Concepts

Hardware

The physical computer and its parts.

Software

Digital instructions to be run by the computer.

Program: A piece of software.
Operating System: A program for running other programs.

BIOS (Basic Input/

Direct JDBC Connection to Microsoft Access Databases

Posted by admin on Jun 3, 2025 in Computing and Communications | 0 comments

Direct JDBC Connection to Microsoft Access Databases (.MDB)

Accessing .MDB Files Without ODBC Data Source Configuration

This document demonstrates how to establish a direct JDBC connection to a Microsoft Access database (.MDB file) in Java, bypassing the need for an ODBC data source setup in the system’s ODBC Data Source Administrator panel.

Java Class Definition

The main class, Access_sin_odbc, encapsulates the database interaction logic.

import java.sql.*;

public class Access_sin_odbc {

Main Program

Veeam Backup & Replication: Comprehensive Q&A for Administrators

Posted by admin on May 22, 2025 in Computing and Communications | 0 comments

Veeam Backup & Replication: Key Concepts and Solutions

This document provides answers to common questions related to Veeam Backup & Replication, covering various aspects of its functionality and administration.

Backup Copy Job and Backup Files

Question: A Backup Administrator configures a backup copy job containing several VMs, each backed up by different daily jobs. How many backup files will be created as the result of the initial successful run of the backup copy job? (Choose two.)

A. One

HTML Form Examples and Server-Side Processing

Posted by admin on Apr 27, 2025 in Computing and Communications | 0 comments

Web Development Examples

Euro to Peseta Converter Example (PHP)

This example demonstrates a simple server-side process using PHP to convert Euros to Spanish Pesetas. It shows how a value submitted from a form could be processed on the server.

Note: The original code snippet contained a syntax error (`$REQUEST`). The corrected logic would typically use `$_REQUEST`, `$_GET`, or `$_POST` depending on the form method.

<?php
// Assuming the form method is POST and the input name is 'cantidad'
$cantidad_

« Older Entries