mardi 2 décembre 2014

ERD Table and Field Questions


ERD


My question is two-fold.


First, this is my first design and I am using the Mere Mortals book to help me. He states, "...each table represents a single, specific subject." So should I combine the Statistics table and Designer tables into the Project table since the subject is Project?


Secondly, the two fields of WhyClientChoseUs and ClientLossReason are opposed to one another and only one of these two fields would be filled out. Is that OK? And should this go in the Project table and not the Client table.


Thanks in advance.





Aucun commentaire:

Enregistrer un commentaire