Normalisation

Question

Difference between composite and compound key??

Answer 1

 

In this relation ENO is a primary key for employee table and Pno is a primary key for projects table

the relation is many-many

for clear image : https://drive.google.com/open?id=12NRaE5r0Zo5K7wajVmoapAGj_cd2z2oa

Comments

Each attribute that makes up the compound key is a simple key in its own right,where as in composite key at least one such attribute is not a key in its own right.

Correct me if I am wrong..