Fetch tatch instruction from main memory

.
-

Decode - decode the instruction

-

Execute- execute the instruction

#
Yo
↑#
M
E
geter
Instruction -

(Decode)

Toperand
↓ opcode
.

(Execute)
# ↓
12 values are obteness
 a
lit

im dat
Reg-current

CPU .

· -

Network.

IP 10 Intere Protoco
locate O
unique
MACXIP + into.

4 layers TCP/IP

Applicatio :
ports .
HTTP/FTP
TCP
Transport
:

-2 E
Internet : IPr4 ,
IPv6
/
4(0 255) -

Ox(F
32 bit 128 bit
4 layers TCP/IP
Applica
Applicatio
Transport
:
:

TCP
ports .
HTTP/FTP
[ Presentation
Sessi

Transport
-

-2 E

↓
Internet : IPr4 ,
IPv6 - Network
/
4(0 255) -

Ox(F
32 bit 128 bit

physical
Darka
Network Accous -
.
-
in

&
/Q - travemit
O -
disassemble file into upackets

↓
TCP

& -assemble tile .

Failed) packet

S
① > I
-

Q cient -
reg
-
> server

① resend packets
Small packets
 Health issues

O Eye strain

② Repetitive strain injury. &

Server to client

I authorized source safe

↑ ident .

P2P-Peer to Peer

unident
[ (n)
.
>
-

authorized : Virus ·

① Open-source
code
modify
collaborative
in faster .
rate
improving
closetsour---
is source code is not avail
for
public.
① Commercial software.

license +
(activation key) (paid)
supporting service

help desk

patches .

Q Share were >

-
admare
free trial.

limited time + fund

.

he to remove restriction ?

pay
luninstall it not
pay

⑨ Freeware >
-
can be admare .

4 Free of change
.
unlimite period ,

X tech support .

individual licence

commercia purpose (pazy)

 Malware

O Virus >
- lies on other
progam

Characteristics. Method.

self-replicating email

cause damage Internet

(data) us

② Worm >
-
self-contain
pryam
Char.

self-replicating Method .

consume interat.
bandwidth

Damages
backdoor
remote control
delete tile

① Dod .

external commo

blocked normal traffic

④ Trojan Horse

X replicate itself .

destructive actions.
(delete files)

tile)
(open .
must

steal data /bachdood

SOL
.
2 TABLE
CREATE [TABLES (

tiled
datatypes,
- r

1;

3. ALTER TABLE [TABLE]

ADD [field-name datatype] ; ITABLE] (tiel)

.
2 UPDATE [TABLE]
SET [Field] =
"

WHERE [cord]

4
. INSERT INTO Estable]

Lid) VALUES (rl ,

-
,

9 DROP TABLE

I
① ② Domain (IN)
Entity integrity. (N) integrity
PK can't
repeat
. targe
.
Col exist
(DATH TYPE /Range
[INSERT (01) -- Entry ...

③ Referential (Exe)

PK
(0)
↓ FK
Co)
CO2 Cos
X
EN Ne
repeating groups -
functivial dependencies

INF m AZST
CS.

↓ ↓ i
Th

I SE
I
CID SNNNE CD

&
Col
Col
CO2
" Co)

SNF

② transitive dependencies
~ non-prime attributes
-

- & -
OID CID CNAME ODATE LAddr .

181 cool Alice 23-0115 NY

-

Los 23 0166 HK
CO2 Bob
-

23-0117
103 Cool Alice NY

- -
 /7
SELECT

Union
TI SID
.

T2 8ID .

+2
From T

LEFT
T
T2 T
JOIN

=TISI
ON
#SID

Union
TI

A-3s
I
Except

ip
.

A
T1 -T2