Dear Ladies & Gentlemen of the forum,
this is the first time I am doing database.
I have done up an ERD for school assignment, but certain aspects of the EERD was not covered in the textbook and I have nowhere else to turn to for help. Assignment deadline is nearing; would greatly appreciate any help. Thanks in advance.
The EER is as attached.
The question is, is it mandatory for the superclass, Employee, to participate in at least a relationship with other entities ?
My textbook says an entity cannot be modelled unrelated to any other entity as stated in the Conceptual Database Design Methodology.
However, because only the HirePointEmp will register HireRecord, I do not want the Employee entity to be associated.
Can any kind soul offer an advice ?
Thank you very much !
