Sensor 
Logical Entity Name  Sensor 
Default Table Name  Sensor 
Definition  Summary information on a sensor 

Sensor Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
sensor_id(PK)    NUMERIC(8, 0)  NO  Sensor identifier. Each sensor is assigned a unique integer which identifies it in a database 
name    VARCHAR(80)  YES  This attribute denotes a descriptive name for a sensor 
serial_nb    VARCHAR(80)  YES  This attribute denotes a serial number of a sensor 
ondate    DATE  NO  This attribute denotes the start date 
offdate    DATE  YES  This attribute denotes the end date 
nb_component    NUMERIC(8, 0)  NO  This attribute denotes the number of components of a sensor 
lddate    DATE  YES  Load date. Date and time that the record was created or last modified, in Oracle date datatype 

Sensor Keys 
Key Name  Key Type  Keys 
Sensor00  PrimaryKey  sensor_id 

Sensor Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
Sensor_Component  Identifying  One To Zero or More          NO 
Station_Sensor  Non-Identifying  One To Zero or More          NO 

Sensor Check Constraints 
Check Constraint Name  CheckConstraint 
Sensor01  nb_component >= 0