PLEASE PROVIDE EXACT SQL MANAGEMENT STUDIO QUERIES (please include commas, parenthesis, indents as applicable).

1A)Create a table that can store teacher information including the teachers last name, teacher subject and salary. Use a surrogate key and make sure it is impossible to create a record without the teacher subject being included.

1B)All students are assigned by exactly one teacher. Based on your answer from Q1A, create a table that enforces this relationship and can store student data including their student ID number, first name, last name, and date of birth.