create a tabel in SQLWorkbench for this info

students a) Attribute, type and length: snum: integer, ssn: integer, name: varchar(10), gender: varchar(1), dob: datetime, c_addr: varchar(20), c_phone: varchar(10), p_addr: varchar(20), p_phone: varchar(10) b) Primary key: ssn c) Candidate key: snum d) Foreign key: N/A