Build the design using a data modeling tool

Assignment Help Basic Computer Science

Reference no: EM131054195

Consider a CONFERENCE_REVIEW database in which researchers submit their research papers for consideration. Reviews by reviewers are recorded for use in the paper selection process. The database system caters primarily to reviewers who record answers to evaluation questions for each paper they review and make recommendations regarding whether to accept or reject the paper. The data requirements are summarized as follows:

¦ Authors of papers are uniquely identified by e-mail id. First and last names are also recorded.

¦ Each paper is assigned a unique identifier by the system and is described by a title, abstract, and the name of the electronic file containing the paper.

¦ A paper may have multiple authors, but one of the authors is designated as the contact author.

¦ Reviewers of papers are uniquely identified by e-mail address. Each reviewer's first name, last name, phone number, affiliation, and topics of interest are also recorded.

¦ Each paper is assigned between two and four reviewers. A reviewer rates each paper assigned to him or her on a scale of 1 to 10 in four categories: technical merit, readability, originality, and relevance to the conference. Finally, each reviewer provides an overall recommendation regarding each paper.

¦ Each review contains two types of written comments: one to be seen by the review committee only and the other as feedback to the author(s). Design an Entity-Relationship diagram for the CONFERENCE_REVIEW database and build the design using a data modeling tool such as ERwin or Rational Rose.

Reference no: EM131054195

Questions Cloud

Result of an increase in interest rates : A fixed income security whose price has fallen as a result of an increase in interest rates in the market place is said to be subject to:

Mike roa for the year : "Mike Smith has the following financial data. Investment Assets at Year End $475,000 Investment Assets at Beginning of the Year $392,000 Savings Made During the Year by Mike $27,000 Employer Match to Mike s 401(k) Plan $5,000 Total Assets on Endin..

Piece of equipment that can be leased or purchased : Connors Construction needs a piece of equipment that can be leased or purchased. The equipment costs $50. One option is borrow $50 from the local bank and use the money to buy the equipment. The other option is to lease the equipment. The company'..

How they can be represented in an er schema diagram : There are several composite keys for section, and some attributes are components of more than one key. Identify three composite keys, and show how they can be represented in an ER schema diagram.

Build the design using a data modeling tool : build the design using a data modeling tool

Design an entity-relationship diagram for the mail order : Design an Entity-Relationship diagram for the mail order database and build the design using a data modeling tool such as ERwin or Rational Rose.

How might an awareness of the communication process : Keeping in mind all of our course material to date, describe the communication skills you feel are needed to be an effective interviewer AND also an effective interviewee.

Design an er schema for keeping track of information : Design an ER schema for keeping track of information about votes taken in the U.S. House of Representatives during the current two-year congressional session

What premium is associated with the warrants : If investors pay $1,200 for each bond, what is the value of each warrant attached to the bond issue? What is the component cost of these bonds with warrants? What premium is associated with the warrants?

User Account

All Pages