Jump to content

Self join Relationship or New Table?


Dimitrios Fkiaras
 Share

This topic is 2301 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello,

In my solution, I have a "Personell" table which includes about 400 records.

Personell is distinguished, according to its specialty to :

  • mechanic
  • electrician
  • driver

Some fields in this table hold attributes that are common to all records(Personell) like:

  • DOB
  • Address
  • Phone number
  • Email et.c.

On the other hand, each specialty has its own unique attributes. For example "drivers" have:

  • licence ID
  • licence type
  • Total hours behind wheel et.c.

 

Should I put the fields that hold specialty-unique attributes, to my main table ?

OR

Put them on  a related table that holds only the _pk of each Person , and make a script to populate

the new table each time I have a new entry on the old?

 

Thanks!

Link to comment
Share on other sites

Both solutions are valid and which one you choose depends on details that we don't have - and to a large extent on your personal preference.

Implementing the second solution (a.k.a the supertype/subtype model) in Filemaker is not trivial, and if the number of the specialty-specific fields is not very large, you may well prefer to keep them all in the same table.

There's also a third alternative in the form of an entity-value-attribute table: https://en.wikipedia.org/wiki/Entity%E2%80%93attribute%E2%80%93value_model

 

  • Like 1
Link to comment
Share on other sites

This topic is 2301 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.