[Jack]

Hi all,

This week's extra work is more of a research task to look into joins on tables. We have covered the INNER JOIN, however I recomend that you go and research about OUTER JOINS, and more about the cartesian product.

Also, based on what was covered last night, I need you to add into the students table, 3 fields about their medical record (for example a few boolean fields about "asthma" and "currentlyinjured"). Next you need create a VIEW of those students, that could be used for admin staff to work with - thus excluding the medical information and only providing information such as name and email. Expand on the current fields to add in data such as a phone number (will it be varchar or int?) and other "office" related information. This is going to be our first mini project.

Thats all - hopefully it wont take to long and as always you can email me or post below for any help or problems you might have.