Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.filemaker > #1462

Re: relationship diagram

Show all headers | View raw

JayBee schreef op 20-10-2013 00:29:
> Hello
> I'm using FMProAdvanced11 version 3.
>
> I was reading an article on designing a relational databases recently and normalisation.  I think it described normalising a database to 3rd normal form.  It said that you must not have any many to many to many relationships and you must correct this by adding a new entity in between the many to many relationship.
> When I checked the relationship diagram for my company's database in FMPro11 there seemed to be quite a lot of many to many relationships in there .
>
>
> How bad is this?  Our database works as we need it to.
>
>
> Does anybody know what this actually means in practice?
>
> Many Thanks
>
Jenny,

Although I understand what they are trying to do, you shouldn't be 
overly concerned about what others are saying. If your current set up 
works and you understand why it works then by all means keep it that 
way. In all my databases I have only one that got so cluttered that I 
had to rebuild (and use multiple occurances for the same table), but all 
the others have simple many-2-many relationships. (also referred to as a 
spider-graph)

-- 
met vriendelijke groeten,
Erik Appeldoorn

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

relationship diagram JayBee <Jennifer_Beecroft@hotmail.com> - 2013-10-19 15:29 -0700
  Re: relationship diagram Martin Τrautmann <t-usenet@gmx.net> - 2013-10-20 04:34 +0000
  Re: relationship diagram "E. Appeldoorn" <ursus.kirk@ziggo.nl> - 2013-10-20 12:19 +0200
    Re: relationship diagram Helpful Harry <HelpfulHarry@BusyWorking.com> - 2013-10-21 09:11 +1300
      Re: relationship diagram "E. Appeldoorn" <ursus.kirk@ziggo.nl> - 2013-10-21 10:54 +0200

csiph-web