Worksheet #2 for Week 5 CSC 343 Winter 2021 University of Toronto Mississauga
February 11/12, 2021
SQL: Data Manipulation Tasks
From the ERD you generated two classes ago, and the DDL you generated last week for S.H.I.E.L.D. to track Superhereos and Villians, you are now asked to make some modifications/query some information.
1. Every free (non-imprisoned) villain has just killed 5 more people, update the records.
2. We just found out that Stephen Strange was born in Philadelphia, update his record.
3. We discovered a new citizen, Bulgarian Tony Stark is 42 years old and weighs about 175 pounds. Also known as, ¡®Iron Man¡¯, ¡®Michael¡¯, and ¡®Mr. Stark¡¯, he has saved 500 people so far, last seen in New York City. His archenemy is ¡®Thanos¡¯ and his power rating is as follows:
I: 10 EP: 7 D: 8 S: 7 S: 8 FS: 9
4. Actually, ¡®Michael¡¯ is not really an Alias for Tony Stark, delete that entry!
Note: Make sure you only delete ¡®Michael¡¯ as an alias for Stark and not anyone else.
5. Write a statement which would show every Superhero who has saved more than 400 people not more than 1000.
6. Write a statement to show every extraordinary citizen¡¯s name which is over 45 years old but under 290 pounds.
7. Delete James Howlett from your records.