Notes, abstracts, papers, exams and problems of Computers

Image Optimization Process

During image design and transformation, there's complete freedom. Optimization is applied at the end, before exporting the image to a web-compatible format.

Optimization involves three key steps:

1. Selecting the best file format to manage file size.
2. Adjusting format options and colors. Each format has specific compression controls, some limiting color palettes.
3. Defining export options based on image use.

Common Export Formats

• GIF (Graphics Interchange Format): Up to 256 colors, supports transparency, ideal for animations, logos, and images with transparent areas. Often used for vector graphics.
• JPEG (Joint Photographic Experts Group): Best for photos and textured images, supports many colors, but has fewer image quality options.

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

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" »

8 Steps for Parallel Work & Uninstallation

The operation of the application, i.e., its use at full capacity.

Parallel Work

When an application is replaced by another, performing a parallel operation of the new application with the old. This means a double data entry, and duplicating all tasks for a certain period of time. This results in greater safety for two reasons:

• You can compare the results of both applications. If the previous application had no failures, the results of the new application should be the same as the old, for identical processes.
• If you detect a serious problem in the new application, you can continue working with the former, which has all the information up to date, while the situation is resolved.

Warranty and After-Sales

Connecting Through JDBC Driver for Microsoft SQL Server 2000

Exercise 2

import java.sql.*;

Class Home

public class Jdbc_sqls3 {

private Connection con = null;

Constants for PLS USE chain link

private final String url = "jdbc:microsoft:sqlserver://";

private final String server = "localhost";

private final String port = "1433";

private final String db = "pubsSQL";

private final String user = "sa";

private final String pass = "spark";

The password is easily found; it is recommended to request the user for the final application.

Make the driver use cursor on the server side, allowing more than one active SQL statement per connection.

private final String method = "cursor";

Main Method of Entry Program

public static void main(String[] args) throws Exception {

Jdbc_

Batch Processing Systems

5) For + d l sistma oprativo exploit. Two types are distinguished:

• Processes by Lots: The following processes are followed:

1. Load the data in a device (e.g., punched cards).
2. Receive the magnetic tape CPU and processes, leaving the results on another magnetic tape.
3. Other devices manage the processed data, leaving it for printing or visualization.

In this way, the CPU processes data only in intervals. This system is very slow because it takes time to load and remove the data. This is the oldest system used and the first structure supposed to be of the IT department, according to these functions. The operators entered and exited the CPU managers.

• Real-Time:

The process is very different from the processes by lots, more prone to... Continue reading "Operating Systems: Types, Processes, and Architectures" »

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" »

10 Good Deeds in Website Design

1. Place the organization name and logo on every page and make the logo a link to the home page.
2. Provide a search function if the site has more than 100 pages.
3. Write straightforward and simple headings and page titles that explain the content.
4. Structure the page to facilitate reader scanning.
5. Instead of cramming everything about a product, use hypertext to structure the content.

3 Broad Aspects of Web Design

1. Designing for the computer medium
2. Designing for the whole site
3. Designing for the user

3 Design Patterns

1. SINGLETON: Ensures that only one object of a given class is created.
2. ADAPTER: An example of the indirection design principle (like an electrical adapter).
3. OBSERVER: Allows two objects to be linked dynamically.

Statechart

Used... Continue reading "10 Good Deeds of Web Design and Object-Oriented Design Principles" »

1.2. Organization of Memory

On Intel's 8051 family, program storage and data are physically separate. Both data and programs can be stored in internal or external memory devices. To identify external memory locations accessed during instruction execution, the microprocessor generates pulses on the ALE (Address Latch Enable) line and controls the PSEN (Program Store Enable) output state.

1.2.1. Program Memory

In 8051-based systems, the selection of program memory (internal and external) is determined by the hardware designer. The microprocessor accesses external memory only if the EA (External Access Enable) pin is connected to ground. If EA is high (connected to Vcc), the microprocessor uses its internal memory for low addresses and external memory... Continue reading "8051 Microcontroller: Memory Organization and ALU" »

Digital Sound Features

Sample Rate: The number of samples per second taken from a continuous analog signal to make a discrete digital signal. For example, CD-quality digital audio uses 44,100 Hz.

Channels: The number of audio channels in a sound recording. Mono = 1, Stereo = 2, 5.1 = 5 channels.

Sample Size: Indicates the number of bits of information in each sample. CD-quality audio uses 16 bits.

Formula: Size = Frequency x Sample Size x Number of Channels x Time (in seconds).

Audio Formats

WAV: A digital audio format without compression. It supports mono and stereo files, and its extension is .wav. It is seldom used on the internet. Microsoft and all programs recognize it.

MIDI: A protocol for communication between digital musical instruments and... Continue reading "Digital Sound and Video: Formats, Properties, and Tools" »