Data Dependency, Data Hazard, Forwarding

Consider the pipeline diagram below.

$(\frac{y}{n})$ The forwarding in RED shown below is not useful for reducing any stall cycles.

$(\frac{y}{n})$ If instructions $x$ and $Y$ are NOPs, any data dependency between $W$ and $Z$ cannot be

a data hazard that requires extra stall cycles.

@

W

WB

$x$

IF

ID

EX

Y

IF

ID

IF

Zis the breaking of one large data table into several smaller tables by eliminating redundant $($repeating$)$ data within each table. Atomic key creation Primary key creation Foreign key creation Data dependency Data independence Hierarchy processing Normalization Using an E$$R diagram