UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Looking For Options, Any Versions    
 
   
ordnance1
post Aug 30 2019, 10:47 AM
Post#1



Posts: 695
Joined: 7-May 11



I am creating a database for my local Fraternal Order of Eagles. There are 2 sides men are in an Aerie and women in an Auxiliary.
I will collect the same information for both sides, so is it better to create separate tables for both sides or create a single table and add a field that differentiates between Aerie and Auxiliary?
Go to the top of the page
 
theDBguy
post Aug 30 2019, 10:57 AM
Post#2


UA Moderator
Posts: 76,822
Joined: 19-June 07
From: SunnySandyEggo


I think the second one.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
GroverParkGeorge
post Aug 30 2019, 12:19 PM
Post#3


UA Admin
Posts: 36,172
Joined: 20-June 02
From: Newcastle, WA


People are people. They belong in a table of People.

Some people participate in one group, other people participate in a different group. That is to say, "Group Affiliation" is a characteristic, or attribute, of each person. The fact that there is a non-mutable aspect to that attribute doesn't change its essential nature.


--------------------
My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
arnelgp
post Aug 30 2019, 12:29 PM
Post#4



Posts: 1,510
Joined: 2-April 09
From: somewhere out there...


1 table, as suggested.
there are only 2 affiliates.
and it will never change in a 1000 years.
you can have it as combo value list.

--------------------
Never stop learning, because life never stops teaching.
Go to the top of the page
 
GroverParkGeorge
post Aug 30 2019, 12:32 PM
Post#5


UA Admin
Posts: 36,172
Joined: 20-June 02
From: Newcastle, WA


One thing I NEVER do is predict that nothing will change, ever.

--------------------
My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
nvogel
post Aug 30 2019, 01:55 PM
Post#6



Posts: 1,036
Joined: 26-January 14
From: London, UK


One table makes the most sense. There is something called the Principle of Orthogonal Design that says (roughly speaking) that two tables should not duplicate the same set of attributes. There are lots of good reasons to follow that rule, most obviously, it is simpler to write queries and other code for one table than two. Also in principle gender ought to be mutable.
Go to the top of the page
 
ordnance1
post Aug 30 2019, 07:45 PM
Post#7



Posts: 695
Joined: 7-May 11



Thank you everyone
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    8th December 2019 - 01:08 AM