Understanding 8085 and 8086 Microprocessors: Architecture, Addressing Modes, and Evolution

8085 Addressing Modes

Addressing modes define how operands are specified in instructions. The 8085 microprocessor utilizes the following addressing modes:

1. Immediate Addressing Mode

Data is embedded directly within the instruction. Instructions with ‘I’ in their mnemonics often use this mode.

Examples: MVI A, 05H; ADI 55H; LXI H, C000H

2. Register Addressing Mode

Data resides in a register, and the instruction references that register.

Examples: MOV A, B; ADD B; ANA C

3. Direct Addressing Mode

The instruction

Read More

PL/SQL Triggers, Procedures, Views, and Concurrency Control in Database Systems

PL/SQL Row-Level Trigger Example

To create a PL/SQL row-level trigger in Oracle that displays the old salary, new salary, and salary difference whenever a modification to the salary column of the emptable occurs, you can follow this syntax:

  1. CREATE OR REPLACE TRIGGER salary_change_trigger
  2. BEFORE UPDATE OF salary ON emptable
  3. FOR EACH ROW
  4. DECLARE old_salary NUMBER; new_salary NUMBER; salary_diff NUMBER;
  5. BEGIN old_salary := :OLD.salary; new_salary := :NEW.salary; salary_diff := new_salary – old_salary; DBMS_
Read More

A Guide to Computer Expansion Cards: Types and Functions

Graphics Cards

Types of Video Memory

DRAM: Were the predominant channels for a long time. Provide low output values.

EDO DRAM: Have been used for quite some time, less expensive than VRAM, is used in middle-low-end cards.

VRAM: You can write to it and read it at the same time. It is much faster than the previous, but memory is a type face.

WRAM: Is a modified version of the VRAM that improves performance and is cheaper.

SGRAM: Currently the most widely used because they offer very good performance. It

Read More

Database Modeling Concepts

Data Model

A set of concepts that can describe different levels of abstraction of the structure of a database, which we call a scheme. (External: For the user view; Global: Joint; and Internal: For the computer.) A set of concepts, rules, and conventions that allow us to describe and manipulate real-world data that you want stored in the database.

Entity

An object which we store information about in the database.

Type of Entity

  • Regular or Heavy: The occurrences of this entity have their own existence.
Read More

Understanding SQL Server Architecture, Constraints, and Relationships

SQL Server Architecture and Data Management

Q: What is the role of the architecture of SQL Server in maintaining metadata and data values?

A: SQL Server uses a special type of database called the system database to maintain metadata. Metadata includes information about the structure of other databases, the data types they contain, and the constraints applied to them. SQL Server stores data values in user databases created for specific applications. The architecture separates system databases from

Read More

File I/O and Classes in C++

Chapter 12

1. What capability does the fstream data type provide that the ifstream and ofstream data type do not?
The fstream data type allows both reading and writing, while the ifstream data type allows only for reading, and the ofstream data type allows only for writing.

2. Which file access flag do you use to open a file when you want all output written to the end of the file’s existing contents?
ios::app

3. Assume that the file data.txt already exists, and the following statement executes. What

Read More