Re: About Entity Relation Diagram

Well if you wanted to read some theory here on people argue about different database types, well there you have it.

Whomever said you shouldn't even be thinking about your schema yet is exactly correct. In the ER diagram you create and brainstorm over, you will eventually convert to tables. If you are thinking about tables in order to create the ER diagram, well theres no point in drawing one up. If you run into problems, bo back to your ER diagram and reorganize; there are probably some relationships that you can clean up/make easier.

As far as your table situation mentioned; the PerfectPartner table sounds like a many to many table between members. Therefore at a minimum PerfectPartner should have unique pairs of members.PK -- members.PK sets. (making sure that you apply constraints so that 4 -- 2 is different than 2 -- 4) Received on Mon Dec 20 2004 - 01:10:11 CST