In my Entity Relationship Diagram, an entity type
TEACHER had a relationship of
TEACH with another entity type called
CLASS was a
week entity type of
TEACHER,so when mapping to a Relational Data Model, I had introduced the Primary Key, named
CLASS as a Foreign Key.
Now, the relation named CLASS contains the following attributes:
Primary Key is composite of ICode, CDate, CStartTime.
Following partial dependency exists here: CStartTime -> CEndTime
I need some help on how to convert this into 2NF. I have read up and seen examples of customers and shops etc. etc. but I could not map the understanding into my example.
I'll appreciate if somebody can tell what to do and why?