Question

Sports Physical Therapy Case: 8-10

8. Add to the PAtient table a new character field named Overdue that is one character in length. On all records, change the value for the Overdue field to N. (2 SQL statement)

9. Change the value in the Overdue field in the Patient table to Y for the patient named Tobey Short. (1 SQL statement)

10. Change the length of the LastName field in the Patient table to 25 (1 SQL statement)

Answer 1

8. Add to the PAtient table a new character field named Overdue that is one character in length. On all records, change the value for the Overdue field to N. (2 SQL statement)

ALTER TABLE PATIENT ADD Overdue char(1);

UPDATE PATIENT SET Overdue="N";

9. Change the value in the Overdue field in the Patient table to Y for the patient named Tobey Short. (1 SQL statement)

UPDATE PATIENT SET Overdue="Y" where FirstName="Tobey" and LastName="Short";

10. Change the length of the LastName field in the Patient table to 25 (1 SQL statement)

ALTER TABLE PATIENT MODIFY LastName varchar(25);