Part1:
Create the tables and insert the data shown in the attached file in a database
named Student1 and perform the following queries.
1. Write the SQL command to add MATH SCORE to the
STUDENT table.
2. Write the SQL command to add SUBJECT to TUTOR. The only
values allowed for SUBJECT will be Reading, Math, and ESL.
3. What do you need to do if a tutor signs up and wants to
tutor in both reading and math?
4. Write the SQL command to find any tutors who have not
submitted a report for July.
5. Where do you think student and tutor information such as
name, address, phone, and e-mail should be kept? Write the
necessary SQL commands to capture this information.
6. List all active students in June by name. (Make up names
and other data if you are actually building a prototype database.)
Include the number of hours students received tutoring
and how many lessons they completed.
7. Which tutors, by name, are available to tutor? Write the SQL
command.
8. Which tutor needs to be reminded to turn in reports? Write
the SQL command.