EECS3421 A3
Requirements:
There are three user roles that interact in an academic conference management system:
学术会议管理系统中有三种交互的用户角色
• Program Committee Chair (or PC Chair), which oversees the enactment, coordination and monitoring of the necessary tasks.
计划委员会主席（或PC主席），负责监督必要任务的制定，协调和监控。
• Regular Program Committee Member (or Reviewer), which evaluates the overall quality of a paper that usually falls in his or her area of expertise.
正常计划委员会成员（或审稿人），负责评估通常属于其专业领域的论文的整体质量。
• Contact Person (or Author), which submits documents (papers) of recent research.
联系人（或作者），负责提交最近研究的文件（论文）。
Each of the user roles can register to the system by providing a login name, email and password information. Once logged in, they can provide further information about their profile, such as real name and demographics (e.g., institute they belong to, telephone, address, etc.). Reviewers can provide further information about their topics of expertise to help the PC Chair to assign them research papers that they are capable of reviewing.
每个用户角色都可以通过提供登录名，电子邮件和密码信息来注册到系统。 登录后，他们可以提供有关其个人资料的更多信息，例如真实姓名和人口统计信息（例如，他们所属的机构，电话，地址等）。 审稿人可以提供有关其专业知识主题的更多信息，以帮助PC主席分配他们能够审阅的研究论文。
The organization of a conference might be separated in four main phases; setup, submission, reviewing and decision phase, as follows:
• Setup phase: During the setup phase, the PC Chair provides functional information about the conference such as:
设置阶段：在设置阶段，PC主席提供有关会议的功能信息，例如：
o defining administrative conference information (dates, description, etc.)
定义行政会议信息（日期，描述等）
o defining the topics of the conference (each conference has several topics)
定义会议主题（每个会议都有多个主题）
o defining additional PC chairs (if any)
定义其他PC主席（如果有）
o defining the program committee members
定义计划委员会成员
o defining the review form (each conference has a review form that reviewers use to submit their assessment)
定义审核表（每个会议都有一个审核表，供审阅者用来提交评估）
o defining specific administrative settings (e.g., what is the number of reviewers assigned per paper?)
定义特定的管理设置（例如，每篇论文分配多少位审阅者？）
• Submission phase: During the submission phase, authors submit papers. For an author to submit a paper he must first create an account to the conference. An author can submit more than one research paper to a conference. The submission of a paper is a three-step process. First the author submits the abstract of a paper along with information about at least the paper title, co-authors, and topics of the conference that the paper falls into. Then, he uploads the full version of the paper. Finally, if the paper is eventually been accepted, then the author would need to upload the camera-ready paper as well. During the submission, authors have also the option to provide information about conflicts of interest (COI). A COI occurs when a co-author of the submitted paper participates to the same conference as a reviewer.
提交阶段：在提交阶段，作者提交论文。 要使作者提交论文，他必须首先为会议创建一个帐户。 作者可以向会议提交多篇研究论文。 论文的提交分为三个步骤。 首先，作者提交论文摘要以及至少与论文标题，合著者以及论文所属的会议主题有关的信息。 然后，他上传了论文的完整版本。 最后，如果论文最终被接受，那么作者也需要上传相机专用的论文。 在提交过程中，作者还可以选择提供有关利益冲突（COI）的信息。 当提交论文的共同作者与审稿人参加同一会议时，即发生COI。
• Reviewing phase: During the reviewing phase, each submitted paper goes through a reviewing process, where the program committee makes suggestions about which papers are accepted or rejected to appear in the conference’s proceedings. Decisions are based on at least several reviews per paper, so one of the tasks of the PC Chair is to assign each paper to a number of knowledgeable reviewers (usually 3). To help in the assignment task, reviewers are asked to define preferences to specific submitted papers through a bidding process and by expressing interest to review papers that fall on specific topics of the conference.
审阅阶段：在审阅阶段，每份提交的论文都要经过审阅过程，程序委员会将就哪些论文被接受或拒绝出现在会议程序中提出建议。 决策是基于对每篇论文的至少几次审阅，因此，PC主席的任务之一是将每篇论文分配给许多知识渊博的审稿人（通常为3名）。 为了帮助完成任务，要求审阅者通过招标过程和表达对与会议特定主题相关的审阅论文的兴趣来定义对特定提交论文的偏好。
• Publishing/Decision phase: During the decision phase, the PC Chair makes decisions about whether a paper should be accepted or rejected based on the reviews submitted by reviewers about each paper. A notification letter is then sent to the author for notifying them about the outcome of their submission.
发布/决策阶段：在决策阶段，PC主席根据审阅者针对每篇论文提交的评论来决定是应接受还是拒绝论文。 然后将通知函发送给作者，以通知他们提交结果。
———————————————————————————————————————
Part A [10%]: A detailed description of the assumptions you made about the system’s functionality (minimum 10 assumptions, maximum 1 page).
详细描述您对系统功能的假设(最少10个假设，最多1页)。
在构建ER关系图时，您可能会有几个关于系统应该支持什么的问题。例如，当您定义一个实体参与关系的最小或最大基数时，您可能无法在提供的描述中找到答案。在这种情况下，你需要做一个假设，把它写在a部分，然后在B部分和作业的其余部分。假设还可以与实体、关系、属性等相关。
• Part B [40%]: An Entity Relationship Diagram (ERD) of the system. Do not include any isa relationships or weak entities (these should be restructured to a final ERD). Your diagram should be computer-generated and not handwritten AND/OR scanned. You can choose to follow any of the notation conventions used in the slides but need to be consistent.
系统的实体关系图(ERD)。不要包含任何isa关系或弱实体(这些应该被重构为最终的ERD)。您的图表应该是计算机生成的，而不是手写的和/或扫描的。您可以选择遵循幻灯片中使用的任何符号约定，但需要保持一致
• Part C [40%]: A translation of your ERD to a Relational Schema.
将ERD转换为关系模式。
• Part D [10%]: A definition of your Relational Schema following the PostgreSQL syntax.
遵循PostgreSQL语法的关系模式定义。
Reviews
There are no reviews yet.