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

Sort by
Subject
Level

Relational Database Concepts: Keys, Views, and SQL

Classified in Computers

Written on in English with a size of 14.08 KB

Relational Keys

Superkey: Set of attributes with all those needed to ID a particular row. Candidate key: Minimal superkey; removing any attribute means it is no longer a superkey; can be multiple per relation; "UNIQUE". Strict: Candidate key + at least 1 extra attribute. Primary: Default candidate key, reference for foreign keys; automatically unique; "PRIMARY KEY". Foreign: "Logical pointer" in a dependent relation that refers to the candidate key in the parent relation (not always primary). Natural: Represent conceptual uniqueness constraints external to the DB, e.g., name, address. Artificial: Introduced solely for the DB, no external meaning, e.g., auto-generated ID; single attribute, simple data type. Surrogate: If artificial is used as
... Continue reading "Relational Database Concepts: Keys, Views, and SQL" »

OSI Model and TCP/IP: Understanding Network Layers

Classified in Computers

Written on in English with a size of 3.85 KB

The Open Systems Interconnection Model

The Open Systems Interconnection (OSI) model is an abstract, layered representation created as a reference for network protocol design. The OSI model divides the process of networking into different logical layers, each of which has unique functionality and to which specific services and protocols are assigned.

Application Layer

The application layer, the seventh layer, is the top layer of both the OSI and TCP/IP models.

Presentation Layer

The presentation layer has three main functions:

  • Coding and data conversion of the application layer to ensure that data from the source device can be interpreted by the appropriate application on the target device.
  • Compression of the data in a way that can be decompressed
... Continue reading "OSI Model and TCP/IP: Understanding Network Layers" »

Network Protocol Fundamentals and Performance Analysis

Classified in Computers

Written on in English with a size of 10.64 KB

Layered Protocols: Advantages and Disadvantages

Layered protocols are a fundamental concept in network design. Understanding their benefits and drawbacks is crucial for efficient system development.

Reasons for Using Layered Protocols

Using layered protocols offers several benefits, including:

  • Breaking up the design problem into smaller, more manageable pieces.
  • Allowing protocols to be changed without affecting higher or lower layers, promoting modularity and flexibility.

Disadvantages of Layered Protocols

Potential drawbacks of using layered protocols include:

  • More overhead: This is due to added information or operations performed in each layer, which can increase processing and transmission costs.
  • Information hiding: Information useful for other layers
... Continue reading "Network Protocol Fundamentals and Performance Analysis" »

Adobe Fireworks CS4: Features and Capabilities

Classified in Computers

Written on in English with a size of 3.53 KB

Adobe Fireworks CS4: A Powerful Tool for Web Graphics

Fireworks was originally created in 1998 by Macromedia. Since the company was acquired by Adobe Systems Incorporated, it has been part of the Adobe family. The most recent and improved version is Fireworks CS4.

Fireworks is a software from the multimedia family, and it is a versatile application. Images for the web can be created, designed, edited, and optimized easily. The use of this software is not exclusive to people who work in this area. Those who enjoy design and creating their own images or editing their favorite pictures can use the program. Company logos, advertising banners, and even animations are developed with it. This way, web pages become more attractive and receive more visits.

... Continue reading "Adobe Fireworks CS4: Features and Capabilities" »

Operating System Fundamentals: Functions, Versions, and Desktop Components

Classified in Computers

Written on in English with a size of 5.08 KB

Operating System Fundamentals and Definition

An Operating System (OS) is a program or set of programs that help manage the resources of a computer. It begins working when the computer is turned on, allowing user interaction. The OS is responsible for the installation, configuration, usage, and maintenance of both software and hardware.

Major Operating System Versions

There are several major operating system families:

  • Windows: This is a commercial operating system owned by Microsoft. Microsoft has developed a family of operating systems that have evolved significantly, from the early Windows 3.11 to Windows Vista and subsequent modern versions.
  • Linux: This operating system is typically distributed free of charge, making it a popular alternative to
... Continue reading "Operating System Fundamentals: Functions, Versions, and Desktop Components" »

Adobe Fireworks: Interface and Tools Explained

Classified in Computers

Written on in English with a size of 4.49 KB

Understanding the Adobe Fireworks Interface

Before getting started, let's define Object as any element within Fireworks, such as a circle, line, picture, or text.

The Fireworks Interface is simple. It's essential to identify each element, as you'll be using them throughout this course.

Start Page

Upon launching Fireworks, and before opening any document, the Start page appears. Here, you can open an existing document, create a new one, access recent documents, or visit Fireworks Exchange to enhance certain Fireworks functions.

Workspace

Workspace refers to the arrangement of elements like the Tools panel, Property Inspector, menus, and windows. The following image illustrates its layout.

Title Bar or Application Bar

Located at the top, it displays

... Continue reading "Adobe Fireworks: Interface and Tools Explained" »

Proprietary File Analysis: Keystream Recovery and Resource Extraction

Classified in Computers

Written on in English with a size of 5.58 KB

C Implementation for Proprietary File Decryption (The Glide Utility)

This C source code outlines a utility, likely named glide, designed to analyze and decrypt data stored in a proprietary file format (possibly a PWL file). The process involves reading the file, recovering parts of the encryption keystream based on known offsets and user input, and then decrypting embedded resources.

Core Data Structures and Global Declarations

The program utilizes several global arrays to manage file data, the derived keystream, and resource pointers.

unsigned char Data[100001];
unsigned char keystream[1001];
int Rpoint[300];
  • Data: Stores the entire content of the input file.
  • keystream: Holds the recovered encryption key stream used for XOR decryption.
  • Rpoint: An
... Continue reading "Proprietary File Analysis: Keystream Recovery and Resource Extraction" »

Mastering Vector Drawing Tools and Basic Shapes

Classified in Computers

Written on in English with a size of 3.48 KB

Freeform Vector Drawing Tools

In the Toolbar, within the Vector group, you will find the tools that allow you to draw freely: the Line and Pen tools.

To use them, simply select the desired tool from the Toolbar and move the mouse to the work area. Click the mouse where you wish to start and keep the button pressed until you reach the end point.

The Line Tool

The line is the simplest vector element, as it is composed of only two points and the line that connects them.

With this tool, you can form different lines to create the desired figure. Example of Line Tool usageTo deselect a line, click in the negative area of the document. To select it again, grab the Pointer Tool from the Select group in the Toolbar. Example of selecting and deselecting a line

Using the Properties Inspector

Always remember to observe the Properties

... Continue reading "Mastering Vector Drawing Tools and Basic Shapes" »

Understanding Computer Hardware, Software, and Core Concepts

Classified in Computers

Written on in English with a size of 3.22 KB

PC Hardware: Essential Components

Hardware refers to the set of physical elements, machinery, and components (such as the microprocessor, monitor, and keyboard) that constitute a personal computer (PC).

Software, on the other hand, consists of programs or applications, along with the data or information they process and store.

Understanding Data and Information

Data serves as the raw material input that computers transform into information. Processed data, or information, is the result, distinguished by its usefulness.

Key Characteristics of Useful Information:

  • Relevant: The information is applicable to the current situation.
  • Current: Information is updated and available precisely when needed.
  • Accurate: Data entered into a computer and the resulting
... Continue reading "Understanding Computer Hardware, Software, and Core Concepts" »

Importing Bitmap Images into Fireworks: Supported Formats

Classified in Computers

Written on in English with a size of 2.59 KB

Importing Bitmap Images into Fireworks

Defining the Canvas

The first step is defining the work area or canvas (remember to have the negative area visible). Then, select the import option from the File menu.

A window like the one below will open.

Locating and Selecting the Image

In the Look in option, you'll search the folder where your image is saved. In the Files of type menu, the formats that Fireworks recognizes are shown. Once you select the file, click Open.

Placing the Image

The following mark will be displayed on the canvas, which means Fireworks is ready to bring in the selected image.

Simply click with your mouse or try to trace the desired size of the image.

That way, the image will appear on the canvas.

Image Properties

This image's properties... Continue reading "Importing Bitmap Images into Fireworks: Supported Formats" »