Stephen Kairys
asked on
Is NORMALIZE the correct term here?
Hi,
Looking to confirm terminology here.
Scrubbed example: Suppose I have two tables for a running stats database.
Runners, containing fields such as name, address, DOB, team affiliation.
Races, containing fields such as runnerID, date, distance.
In what I think is flawed design, the UI for entering race info contains an entry field for the runner's hometown. If you change it from (e.g.) "New York" to "Chicago" in one race, it will display "Chicago" for all races.
IMO, this field should be display-only on the Race info UI and should be modifiable only on the Runner UI.
Now, to my question: Is "normalize" the correct term I should use to convey this concept?
Thanks.
Looking to confirm terminology here.
Scrubbed example: Suppose I have two tables for a running stats database.
Runners, containing fields such as name, address, DOB, team affiliation.
Races, containing fields such as runnerID, date, distance.
In what I think is flawed design, the UI for entering race info contains an entry field for the runner's hometown. If you change it from (e.g.) "New York" to "Chicago" in one race, it will display "Chicago" for all races.
IMO, this field should be display-only on the Race info UI and should be modifiable only on the Runner UI.
Now, to my question: Is "normalize" the correct term I should use to convey this concept?
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER