The Canadian Research Council (CRC) wants to track the research being undertaken by faculty in Canadian Universities. It needs a database to support the following parameters. It has established a list of some 500 different research topics and assigned each one a code. For each topic there is a brief description and then associated with each topic can be up to 10 key words for cross referencing and searching. Each Canadian university is retained in the database to be referenced by a standard abbreviation. Also retained is the full name of the university. Each university will supply research faculty information to be retained in this database. The information will be the employee id, name, rank, email and phone number of all faculty engaged in research as well as the research topics they are involved with. A researcher may be involved in more than 1 topic and obviously a topic may be being researched by many researchers. There may be some topics in the database that have no active researchers at any one time. Where possible the CRC will designate one researcher per topic as the leading authority in that topic. There can be only one leader per topic and it is extremely important from a database integrity viewpoint that this relationship is accurately maintained. Also held in the database will be information on all the research funding organizations in Canada. Retained will be their names and an estimate of the total research grant funds available to each of them. Recorded will be any amounts granted to a researcher by any particular organization in any given year. A record will be retained on such yearly funding for up to 10 years. In any given year a researcher may receive funds from many organizations and an organization in turn may fund many researchers. Some funding organizations are administered by other funding organizations and this hierarchical structural relationship between funding organizations needs to be represented in the database.