I am a novice at creating databases as well as Sql. Can anyone help by pointing me in the right direction by way of table and column names for the following problem. Me being a rookie thought that I would need just 3 tables but I have been told that 6 or 7 will be needed to stop many to many relationships occurring.
The tables need to contain the following information:
· The first and surname of each pupil
· A pupil id...