How to approach the following T-SQL requirements!

Hi guys,

I'm quite new to T-SQL and honestly started to take online classes 2-3 days ago. I've some tasks to complete, and it would be really great if someone could help or guide me on how to approach the following tasks:

Requirements:

• For each student, we need a student ID, Social insurance number, firstname, lastname, email address, phone number, and start date.
• Student ID & Social Insurance numbers should be unique
• Social insurance number format must be: NNN-NNN-NNN: Example: 123-456-789

• For each program, we need the program code, program name, program contact email address, program contact name, and program start-date
• A program should be unique by name and start-date
• A student cannot exist without being part of a program
• A student can only belong to one program at a time.
• There should be at least 10 programs
• There should be at least 20 students
• Create a stored procedure for adding students
• Create a stored procedure for adding programs