Convert the above ER diagram to relations in the normal mann

Convert the above ER diagram to relations in the normal manner, and then identify which of the following is a relation schema.

Teaches (ID, semester)

Professors(ID, name, semester)

Teaches (ID, ID, semester)

Courses(ID, Name)

	a.	Teaches (ID, semester)
	b.	Professors(ID, name, semester)
	c.	Teaches (ID, ID, semester)
	d.	Courses(ID, Name)

SID name Courses semester ID name M Teaches N Professors

Solution

Relation schema :

Option d is correct choice.