3. Create the 4 tables in the provided diagram shown at the end of the assignment instructions.
   1. As you will see in the diagram, primary keys (PKs) and foreign keys (FKs) are indicated. Ensure that you implement the constraints as specified, including the composite PK.
   2. All name and address type columns should not be null.
   3. Data types for student and professor IDs should be a numeric data type.
   4. Date columns should be a date data type.
   5. All other columns should be a variable character data type of an appropriate length.

4. Next, you will make up some sample data that you will insert into each table.
   1. Add 3 students to the student table.
      1. All student IDs should be at least 5 digits long and start with the same number.
   2. Add 2 professors to the professor table.
      1. All professor IDs should be at least 4 digits long and start with the same number. It should not begin with the same number as the student IDs.
   3. Add 2 courses to the course table.
   4. Add each student to one of the courses. All students must have the same professor and start date.

STUDENT PK student_id first_name last_name phone COURSE PK course_number course_name street city CLASS PK,FK1 student_id state zip PK,FK2 course_number PK,FK2 prof_id start_date PROFESSOR PK prof_id first_name last_name