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. part2: choose a topic from the topics done in the class. get it approved by the instructor. 1) do a research on the internet and write about the topic explaining it with examples (min 200 words) 2) create a powerpoint presentation on the above topic and present it to class (min 10 slides)



Answer :

Other Questions