Certain species of animals mate for life. That is, they have only one mate. We are not interested in tracking this species once a mate dies. Given the ERD below, what will be the constraints on the foreign key column? The ERD models the following rules. The species member may have a maximum of one mate but may not have a mate at all. The species member may be a mate to at most one other species member but may not be a mate to any other species member. SPECIES Mate Of ID Weight DOB Mate To O The foreign key column will require unique values but a value is NOT required for every row. O The foreign key column will NOT require unique values but a value is required for every row. O The foreign key column will require unique values and a value is required for every row. O The foreign key column will NOT require unique values and a value is NOT required for every row