Given the following tables:

students(sid,name,age,gpa)

courses(cid,deptid, description)

professors(ssn,name,address,phone,deptid)

enrollment(sid,cid,section,grade). cid makes reference to the courses table.

teaches(cid,section,ssn). cid, section makes reference to the enrollment table

Provide SQL instructions for each of the following questions

1. Create the database schema.

2. Find the name of professors that work for the cs department.

3. Find those students (sid) enrolled in courses in the cs department.