Victoria Becu

Write 3 update and delete statements

Someone got into the college's database and things have gone awry - they reset the course section, reassigned student ID, and renamed a dept

• December 16, 2016 at 10:05 PM
• Visible to public

UPDATE  `Student` SET  `ID_#`=2046207;

UPDATE  `Course` SET  `Section`=0;

UPDATE  `College` SET  `Major`='Industrial Engineering';

DELETE FROM `Student`
WHERE `ID_#`=2046207;

DELETE FROM `Course`
WHERE `Section`=0;
 
DELETE FROM `College`
WHERE `Department`='Industrial Engineering';