Hi,
For this only RDBMS came into being.
You keep your master data in a table with relevent descriptions,
codify the item. Use the code in other location. In qa web page always
search against/show the full desc of what others require. Add a
category like school/university/pre-matric etc. this coul
Don't think "file" think "table"! ;-)
CREATE TABLE universitysynonyms (
ID int auto_increment primary key,
synonym varchar(40) not null,
university_id int not null,
UNIQUE(Synonym, university_id)
)
Each time you run into something you don't have in your "universit
I need help on the best way to handle a field that could have many
different ways of naming something.
For instance, school name
Let's take Saint Joseph's University
This could be Saint Joseph's Univeristy, U. of St. Joe, SJU, Univ. St.
Joe, etc...
In this case, I don't think I can always get w