这个作业是针对竞赛相关的数据库系统进行查询、操作等

DATABASE SYSTEMS

CMPT 354 Final Project

Important Note: Before you begin, please read carefully the policy on Academic misconduct, in particular about the publication of assignments and tests in online repositories.

Students may work in teams up to 3 people. You may NOT provide or use any solution, in whole or
in part, to or by another student/team. Students are not allowed to publish tests, assignments and their
solutions (e.g., put them on an open public repository).

In this project, you are allowed (and even encouraged) to share the techniques of how to establish
connectivity, and overcome potential technical problems, but you are not allowed to share your team’s
programs. Sharing unrelated to the questions in this project “dummy” or “prototype” programs is fine.

You are NOT allowed to share SQL solutions for the queries.

Description (slightly modified from the first SQL/Lab assignment). A research grant council
provides grants to researchers to run research projects. It holds basic information about each grant
competition, submitted grant applications, grant reviewers and about awarded applications. It also has
information about the scheduled meetings to decide on the submitted proposals, for each competition.

• The database stores information about all researchers. For each researcher, the database should
keep the first and last name and the email address, and the organization (university) they work for.

• Each call for grant proposals has a number, title, application deadline, a short description, and an
area, e.g., biology, computer science, etc., and the current status of the competition (open/closed).

• Each submitted grant proposal has its number, the requested amount, which call (competition)
it is for, a principle investigator, and other collaborators (researchers). It also has an application
status, e.g., submitted, awarded, not awarded, and the amount of money, if awarded, all for a
specific date. Note that the awarded amount can be the same, bigger or smaller than the
requested amount (usually, smaller).

• Researchers not only submit research proposals to grant competitions, but also sometimes act as
reviewers for grant applications. Each reviewer has records about which grant applications they
reviewed, and who their co-reviewers were for each grant. Their records also include conflicts of
interests, i.e., the names of other researchers whose grants they are not allowed to review. For
example, this happens if they are from the same department, or they co-authored a paper in the
past two years.