Relational Schema Design

Continuing at the corrected version of part #1,

• Specify the domains of each attribute listed by relations. If you have special considerations such as Nullness and uniqueness, please point out.
• Add semantic checks. SSN must be exactly nine digits, and hourPay must be at least $7.50.
  
• Convert your ER/EER diagram into relational tables.
• Specify the entity constraints (by underlining) and referential integrity constraints (by FK-PK relationship arrows).