Transform the provided ER diagram for the Student Registration System to relations\ using the techniques discussed in Chapter 4. For composite attributes, use Method 1 (e.g.,\ transform name into fname and lname) to perform the transformation. For each\ relation:\ underscore the key\ specify other candidate and foreign keys (if any)\ specify the constraints associated with this relation, including all the constraints that are\ described in the Requirements Document