We use the innodb database engine.
The blue sky music database is not configured to force referential integrity.
I was only referring to referential integrity because that is the only real benefit to defining the relationship in the database.
using the myisam database engine, that benefit is lost.