Consider the ER diagram below The relational reduction resu

Consider the E-R diagram below –

The relational reduction results in three relations, one each for the entity sets and one for the relationship set. The relationship relation is given by

stu_adv(student_id, inst_id)

Under some conditions, this schema can be simplified. If we do not allow any null attribute values in the relations, can this schema be simplified?

student PK student Id name Stu adv advisor dept name

Solution

Yes, in the above ERD ,there are two entities student_id and inst_id both are prikary keys that means it can\'t allow repeated values ...without redundancy of attribute values we can simplify the schema.