6.9

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 \(s\_ID\) as primary key for advisor, we declare \(i\_ID\) as a superkey for advisor (this can be done in SQL using the UNIQUE constraint on \(i\_ID\)).