SQL help

Homework #1-Creating Tables Create a database with the following tables, correctly identifying the data type for each field and implementing constraints as described. Primary keys and relationships will be added in the next assignment. Operators (Seniority Number, First Name, Last Name, Hire Date). All fields are required. Seniority number is four digits. Hire date must be less than tomorrow. Trips(Route Number, Start Location, Start Time, End Location, End Time, Effective Date) All fields are required. End Time must be greater than Start Time. Effective Date must be on or after January 1, 2000. Vehicle(Manufacturer, Model, Model Year, Purchase Date). Default value for Manufacturer is Gillig'; default value for Model Year is the current year. Model year must be less than or equal to the current year Turn in this file with your SQL code and screen prints