should be cid
course dont have total participation ...so what will you put in front of CID in tuple ??please help @ Shaik Masthan
if you want to take ssn as key then two tables required
if you make cid as key then only one table is sufficient....
The one table look like as (cid,Cname,ssn,name)
which cid doesn't map to ssn ===> put NULL
check this https://gateoverflow.in/218954/what-an-interesting-dbms-question
what is causing the problem if we take ssn as the key ? all in one table
we will make ssn as the key, <ssn, name, cid, cname>
wherever courses is not participating in relation corresponding to ssn, we will put NULL.
by seeing NULL, we come to know it is not participating in relation.
its my view, correct me if im wrong
@smsubham, it is 1:1 relationship, having full participation on Professor entity side.