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

Why do you have a primary key?

A primary key ensures UNIQUE DATA.

Form Design Views

In Form View, you cannot make any design changes to a form.

Checking Field Lengths

Martha is concerned that her form data may be longer in length than the size of the field control. To check this, she should use Print View.

Handling Primary Key Changes

If you choose the Cascade Update Related Fields Option, Access permits the change in value to the primary key and changes the appropriate foreign key values in the related table, thereby eliminating the possibility of inconsistent data in Yuka's database.

Resizing Columns

You can resize columns easily in Layout View.

Activating the Find Command

You can activate the Find command from the button on the Home tab.

Saving Database

Understanding Pointers in Programming

A pointer is a variable whose value is the memory address of another variable. Like any variable or constant, you must declare a pointer before you can work with it.

C++ Pointer Example

#include <iostream>
using namespace std;

int main ()
{
    int var = 20; // Actual variable declaration.
    int *ip;      // Pointer variable declaration.

    ip = &var;    // Store address of var in pointer variable.

    cout << "Value of var variable: " << var << endl;

    // Print the address stored in ip pointer variable
    cout << "Address stored in ip variable: " << ip << endl;

    // Access the value at the address available in pointer
    cout << "Value of *

Four Servers Reside in the DMZ

• Mail
• WWW
• DNS
• Log Servers

DMZ Mail Server (a Separate Machine)

When an Email Message is Received from the Internet:

1. Reassembles the message.
2. Checks for malicious content.
3. Changes the addresses of the outer firewall (which is how the mail server is known to the outside world) to that of the internal mail server and forwards the mail to the internal mail server.

To Send a Message from the Internal Network to the Internet:

1. Reassembles the message.
2. Checks for malicious content (and maybe for proprietary information).
3. All internal addresses are replaced with "drib.org" (the name of the outside firewall).

DMZ WWW Server (a Separate Machine)

• Does not contact any servers or information sources on the internal network and it contains

Operating System Scheduling

1. The OS enables running multiple programs simultaneously. Several programs can reside in RAM concurrently, yet the CPU processes only one at a time. Only one process can be active at any given moment. CPUs are incredibly fast; even brief processing periods yield significant results. The OS determines the optimal method for switching between running, runnable, and waiting processes. It manages which process the CPU executes and distributes CPU access among processes. The task of determining when to switch processes is termed scheduling.

Disk Defragmentation

2. A disk defragmenter reorganizes files on a disk, ensuring they are stored contiguously. It arranges files on the disk into adjacent locations. This enhances... Continue reading "Understanding Operating Systems, Software, and Computer Hardware" »

Printer Types: A Comparative Analysis

Understanding the differences between various printer types is crucial for making informed decisions. Here's a comparison of common printer technologies:

• Laser Printers: Generally faster than plotters.
• Color Laser Printers: Offer significant advantages over standard monochrome laser printers, especially for vibrant outputs.
• Inkjet Printers: Typically slower than laser printers but often excel in photo quality.
• Dot Matrix Printers: Surprisingly, these can be more expensive than plotters, especially for specialized industrial models.
• Sublimation Printers: Often considered to have lower print quality compared to inkjet printers for general use, but excel in specific applications like photo printing or fabric.
• Plotters:

Fundamental Database Concepts

What is a datasheet?

When you first open a datasheet, Microsoft Access selects the first field value in the first record.

What is a table?

All fields for a specific individual or place can be grouped together as a table.

How can a field be described?

A field can be described as an attribute.

What is a primary key?

A field, or a combination of fields, that has a unique value is a primary key.

What is a requirement for a primary key?

A primary key must contain a unique value for each record within the table.

What is a foreign key?

A field that is defined in one table and is also a primary key in a different table is a foreign key.

What is a requirement for a foreign key?

Every foreign key must match the field value of a primary

Database Design Fundamentals

Key Concepts and Definitions

Data Type

The data type determines what field values are allowed and what other properties the field will have.

Saving a Table

You can specify a name for a table after you click the Save button on the Table Design toolbar.

Table Structure

The final step in the creation of a table is to save the table structure to disk.

Primary Key

A primary key uniquely identifies each record in a table.

Identifying Fields

When designing a database, you need to identify the fields that will be required.

Data Redundancy

Storing the same data field in multiple tables is called data redundancy.

Composite Key

A primary key that consists of more than one field is called a composite key.

Avoiding Data Redundancy

When designing... Continue reading "Database Design: Mastering Data Types, Keys, and Queries" »

Building Information Modeling (BIM)

BIM is a complete representation or depiction of a building that aids in its design, construction, and continuous management. This is an evolving concept that changes as technological capabilities improve.

Revit Elements

An element in Revit is a discrete building block or piece of data, such as an object or drawing sheet. The four basic types of elements are:

• Model Elements: Walls, doors, roofs.
• Datum Elements: Levels, grids, reference planes.
• Annotation Elements: Tags, text, dimensions.
• View Elements: Plans, sections, schedules.

Views and Drafting

• Detail Line: Designed to appear only in the view in which it is placed. It is treated as an embellishment to that particular view and is not added physically to the building

Design patterns offer proven solutions to recurring software design challenges, promoting code reusability, maintainability, and efficiency. They can be categorized into three main types:

Behavioral Design Patterns

These patterns focus on communication and interaction between objects, enhancing flexibility. Examples include:

• Observer Pattern: Enables one-to-many dependencies, where changes in one object automatically notify dependent objects.
• Iterator Pattern: Provides sequential access to elements within a collection without exposing its underlying structure.

Creational Design Patterns

These patterns address object creation mechanisms, ensuring suitable instantiation processes. Examples include:

• Singleton Pattern: Restricts object creation to a single