Filter_FIR_Data 
Logical Entity Name  Filter_FIR_Data 
Default Table Name  Filter_FIR_Data 
Definition  Coefficients of a FIR filter 

Filter_FIR_Data Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
fir_id(PK)(FK)    NUMERIC(8, 0)  NO  FIR Filter identifier. Each FIR filter is assigned a unique integer which identifies it in a database 
coeff_nb(PK)    NUMERIC(8, 0)  NO  The numerator/denominator number 
type    VARCHAR(1)  NO  This attribute denotes whether a value is associated with a numerator/denominator 
coefficient    FLOAT  NO  The numerator/denominator coefficient value 
error    FLOAT  YES  This attributes denotes the numerator/denominator error 

Filter_FIR_Data Keys 
Key Name  Key Type  Keys 
FFD00  PrimaryKey  fir_id, coeff_nb 

Filter_FIR_Data Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Filter_FIR  Identifying  One To Zero or More        fir_id  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 

Filter_FIR_Data Check Constraints 
Check Constraint Name  CheckConstraint 
FFD01  coeff_nb >= 1 
FFD02  type IN ('N','D')