Re: er-diagram

> Looks correct but you should also identify foreign keys in the table
> attributes list. You have them there but there not identified as such.
> Good habit to get into. Makes it real easy for someone else to work
> with the database later.

It depends. How is the er model going to be used?

Classical er modeling leaves the foreign keys out. Relationships are identified in the model, but not implemented as data items. In the classical era, this had the advantage of allowing a single er model to be used as the basis for a relational logical model, and also a network logical model. Nowadays, that consideration may be moot, if only one logical model is going to be derived from the er model.

--
Regards,
    David Cressey
    www.dcressey.com