Suppose the advisor relationship set were one-to-one. What extra constraints are required on the relation advisor to ensure that the one-to-one cardinality constraint is enforced?
In addition to declaring as primary key for advisor, we declare as a superkey for advisor (this can be done in SQL using the UNIQUE constraint on ).