AnsweredAssumed Answered

Modification or starting over?

Question asked by heatherwilliams on Nov 7, 2016
Latest reply on Jan 17, 2017 by Malcolm

I work for an office that offers funding to students interested in conducting research with our institution's faculty members. The office has many faculty, who mentor many students through a variety of programs. Our office office has been tracking student participation in each program, but we would like to also know more about faculty involvement in each program. I'm not sure that our current FM database was built in a way that can support this. If you were to start from scratch, what would your tables be and how would you setup the relationships?