Is there a name for when 2 entities can have multiple relationships between them?
If I want to describe a column as one of the following: Surrogate key Natural key Foreign key Attribute etc. then what do I call this list? Relational roles? I don't think "column type" quite cuts ...
I am doing more extensive work with supertyping and subtyping as it solves some problems in a very useful way. In particular, I am enhancing a web application where many things need to be subject to ...
I have some tables (users, jobs, customers) that are each tied to 'groups'. As each table is linked to 'groups', I feel inclined to call the actual group tables user_groups, job_groups and ...