| CourseID | Title | Credits |
|---|---|---|
| 101 | Intro to Python | 4 |
| 102 | Database Systems 1 | 3 |
| 103 | Web Development | 4 |
| EnrollmentID | CourseID | StudentID |
|---|---|---|
| 52 | 101 | 8 |
| 53 | 102 | 8 |
| 54 | 103 | 9 |
| StudentID | Firstname | Lastname |
|---|---|---|
| 8 | Alice | Smith |
| 9 | Bob | Jones |
The course with the title Database Systems 1 has been entered incorrectly into the database and should have the title Database Systems 2.
Write the SQL statement to make this change.
25 exam-style questions on AQA GCSE Computer Science Structured query language (SQL). Each one has a worked solution and a mark scheme showing where the marks go.