1. Write SQL statement to create a student table. The table has student name, ID, major, age, address. ID is the primary key, and name and age cannot be null. Age is a positive number and not greater than 70.
2. Write SQL statement to create an employee table. The table has name, ID, department, title, birthday, and salary. The minimum salary for all employees are 30,000$, and only manager can have salary greater than 150,000$.
3. Create a view CS_Student for CS students which includes ID, name, and address.