Questions from Database Management

Q: Add a subtype discriminator for each of the supertypes shown in Figure

Add a subtype discriminator for each of the supertypes shown in Figure 3-10. Show the discriminator values that assign instances to each subtype. Use the following subtype discriminator names and valu...

Q: Write the SQL command to add column MATH SCORE to the STUDENT

Write the SQL command to add column MATH SCORE to the STUDENT table.

Q: Write the SQL command to add column SUBJECT to TUTOR. The

Write the SQL command to add column SUBJECT to TUTOR. The only values allowed for SUBJECT will be Reading, Math, and ESL.

Q: What do you need to do if a tutor signs up and

What do you need to do if a tutor signs up and wants to tutor in both reading and math? Draw the new ERD, create new relations, and write any SQL statements that would be needed to handle this develop...

Q: Write a SQL query to identify all students who have been matched

Write a SQL query to identify all students who have been matched in 2018 with a tutor whose status is Temp Stop.

Q: Write the SQL query to find any tutors who have not submitted

Write the SQL query to find any tutors who have not submitted a report for July.

Q: Where do you think student and tutor information such as name,

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.

Q: Write an SQL query to determine the total number of hours and

Write an SQL query to determine the total number of hours and the total number of lessons Tutor 106 taught in June and July 2018.

Q: Write an SQL query to list the Read scores of students who

Write an SQL query to list the Read scores of students who were ever taught by tutors whose status is Dropped.

Q: List all active students in June by name. (Make up

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...