Yes, the connection script allows me to change the server, database and login information on just one page.
One normally leaves the student info intact. Whether you leave his history intact you can decide. But for purposes of this prac, if you delete the course, and I select a student which previosuly was linked to this course, then that course should be unlinked from the student, i.e. you' delete a course, you delete all references to that course. But if you want to take it further, then you're welcome. But then you'll have to make it clear what is shown.
Year of registration - all current entries will be 2006, but since oen would like to use the system in future, the code will automatically get the date and use the year. i.e. if I use it now, registration is 2006. Next year the system will use 2007. Now you can get away with it and just hardcode the date for purpose of this assignment. But I check what you did and adjust your mark accordingly.