SQL and Erwin Project for University (ON, Canada)

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.

Beceriler: MySQL, SQL

Daha fazlasını gör: searching employee, mysql erwin, erwin mysql, needs and wants, university list research, sql support, sql and c, project leader, email and phone, c university, sql database relationship, sql different, mysql number sql, research university, employee mysql, database research topic, Funding REsearch, relationship list topics, project funding available, university database project, employee relationship, crc code, email list database 2013, research project names, email database university

İşveren Hakkında:
( 1 değerlendirme ) orlando, Canada

Proje NO: #4395731



I am Ready to Start this Course Work

%selectedBids___i_period_sub_7% gün içinde 50%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(1 Yorum)

Bu iş için 2 freelancer ortalamada $58 teklif veriyor


Hi, I can do this work. Thanks

in %bids___i_period_sub_35% gün içinde66%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)