Hi Everyone,
I could really use some advice. I'm interning for a non-profit and am creating a database to hold all their grant competition data. This is the kind of info i'm dealing with:
5 different grants (GrantName) (there's repetition in this column)
Several investigators (ApplicantName) (there's repetition in this column)
Several Institutes (InstitutionName) (there's repetition in this column)
The Province,City where the institution is located (there's repetition in this column)
Grant numbers (these are unique, but only given to successful applicants)
I have a column indicating successful/unsuccessful applicants (s/u)
I also have financial data linked to the successful applications (funded amounts)
I just don't know how to build the database and what relationships I should establish, which relationships should I maintain referential integrity.
Its difficult for me because the all the applicants don't have unique identifiers (primary keys).
I've tried having a sheet for all applicants (both successful and unsuccessful) that collects all the data above and then a second sheet with only successful applicants, but then I have to replicate the same data twice in two separate sheets.
I wanted to create the second successful applicant sheet because then the GrantNumber column could be used as the primary key, and I could then create a relationship with that sheet and the financial information sheet (the two sheets will have the same number of rows). But I don't know how to link the successful applicant sheet to the all applicant sheet (what relationship should I use?)
If anyone has any suggestions as to how I should build this database, please let me know, I'd really appreciate it.
Thanks for the help,
Maria
I could really use some advice. I'm interning for a non-profit and am creating a database to hold all their grant competition data. This is the kind of info i'm dealing with:
5 different grants (GrantName) (there's repetition in this column)
Several investigators (ApplicantName) (there's repetition in this column)
Several Institutes (InstitutionName) (there's repetition in this column)
The Province,City where the institution is located (there's repetition in this column)
Grant numbers (these are unique, but only given to successful applicants)
I have a column indicating successful/unsuccessful applicants (s/u)
I also have financial data linked to the successful applications (funded amounts)
I just don't know how to build the database and what relationships I should establish, which relationships should I maintain referential integrity.
Its difficult for me because the all the applicants don't have unique identifiers (primary keys).
I've tried having a sheet for all applicants (both successful and unsuccessful) that collects all the data above and then a second sheet with only successful applicants, but then I have to replicate the same data twice in two separate sheets.
I wanted to create the second successful applicant sheet because then the GrantNumber column could be used as the primary key, and I could then create a relationship with that sheet and the financial information sheet (the two sheets will have the same number of rows). But I don't know how to link the successful applicant sheet to the all applicant sheet (what relationship should I use?)
If anyone has any suggestions as to how I should build this database, please let me know, I'd really appreciate it.
Thanks for the help,
Maria