Difference between IDE SCSI and SATA interfaces

Characteristics	IDE	SATA	SCSI
Acronym For	(IDE) interface	Serial ATA	Small Computer System Interface
Developed in	1986	2003	developed in 1978 and publicly disclosed in 1981
Pins Used	40 Pins	7 Pins (3 grounds and 4 active data lines in two pairs)	50-pin, 68 pin, and 80-pin
Data Transfer Rate	16 MB/s originally later 33, 66, 100 and 133 MB/s	SATA 1.0–> 150 MB/s, SATA 2.0–>300 MB/s,SATA 3.0 –>600 MB/s	Ultra-640 SCSI: 640 MB/s or 5120 Mbit/s
Supported Devices per Cable	Two	One	Sixteen

SCSI-1,SCSI-2,SCSI-3

SCSI (Pronounced as Skuzzy) is an Acronym for Small Computer System Interface. It is a set of standards for connecting and transferring data between Computer and Peripheral devices. It was developed by Shugart Associates Company in 1981 as a universal and intelligent disk drive interface.

This Interface is generally used for connecting Hard Disk Drives and Tape Drives but can also be used to connect wide range of other devices. This Interface is derived from Shugart Associates System Interface (SASI pronounced as sassy). SASI Controller works as bridge between Disk Drive’s Low level interface and Host Computer. Larry Boucher is considered to be the father of SASI and SCSI. Up to February 1982, ANSI developed this specification as SASI and “Shugart Associates System Interface”. Committee documenting this Standard did not allow it to be named after a company name and after a full day discussion named as SCSI (Small Computer System Interface).

Intel 8255 (Programmable Peripheral Interface)

Intel 8255 is a PPI (Programmable Peripheral Interface) and is used to interface Peripheral devices to microcomputers. It can be programmed in a variety of ways as per Programmer Requirements. It has two versions 8255A and 8255B. Both of them are similar in general description but are different in their electrical characteristics.

Intel 8255 Consists of Three 8 Bit Ports: Port A, Port B and Port C. The Port C is further divided into two 4 Bit Ports: Port C_UPPER and C_LOWER. These three ports are divided into two groups for the purpose of Programming:

Group A: This Includes Port A (PA₀-PA₇) and 4 MSBs of Port C (PC₄-PC₇).

Group B: This Includes Port B (PB₀-PB₇) and 4 LSBs of Port C (PC₀-PC₃).

Features of 8255A (PPI)

It is a 40 pin IC.
It Operates on single +5V_DCsupply.
Power Dissipation=1 watt.
Ambient Temp. =0- 70 °C
Input Low Voltage (V_IL) = Min. 0.5V, Max. 0.8V.
Input High Voltage (V_IH) =Min. 2V, Max. V_CC.
Output Low Voltage (V_OL) = 0.45V
Output High Voltage (V_OH)= 2.4V
Voltage on any pin 0.5V to 7V.
Darlington Drive Current= Min. 1mA, Max. 4mA.

Pin Description of 8255A

Pin	Description
D0-D7	8 Bit Bidirectional Data Bus and goes to tri state condition if CS is high.
	Chip Select Signal. 8255 is Selected if this pin status is low.
A0-A1	Used to select port from which data is to be transmitted or to which data is to be transmitted.
	Port/Control Word Register	Port/Control Word Register Address
	Port A	00
	Port B	01
	Port C	02
	Control Word Register	03
	To indicate read operation
	To indicate write operation.
PA0-PA7	8 Pins of Port A
PB0-PB7	8 Pins of Port B
PC0-PC3	4 Pins of Port C LOWER
PC4-PC7	4 Pins of Port C UPPER
VCC	+5V DC Supply.
GND	Ground Signal

Operating Modes of 8255A

Database Management System (DBMS) Interfaces

DBA Interface: This interface is used by the database administrator to create databases, Users, to set system parameters for changing database schema etc. Fig. given below shows admin menu where DBA is can create new user and can assign privileges to him.

Graphical User Interface: This interface represents database