Er diagram indicates the name and data type

Assignment Help Accounting Basics
Reference no: EM13927361

Assignments

1. Create an ERD for 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. Cut and paste the diagram into the space below.

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 only 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).

3. Give the DDL commands to create the family database described below.
The family database has four tables, twenty fields, four 1:N relationships and one 1:1 relationship. Use Oracle to build the database.

  • Data Fields
  • The ER diagram indicates the name and data type for each of the fields. You must use the table and field names (and capitalization) indicated in the diagram.
  • All but five of the fields must contain data (i.e., not null). Only the WifeID and DOM (i.e., Date of Marriage) fields in tblMan, the MaidenName field in tblWoman, and the FatherID and MotherID fields in tblChild are allowed to have missing data (i.e., nulls).
  • Primary Keys
  • ManID, WomanID and ChildID should be simple primary keys for tblMan, tblWoman and tblChild, respectively. ChildID1 and ChildID2 should be a composite primary key for the tblSiblingPair bridge table.
  • Secondary Indices
  • Six secondary indices need to be defined in order to improve the database performance (speed) once thousands of records have been inserted into the tables:
  • LastName and FirstName should be a composite index for tblMan. (Note: LastName, FirstName is the classic phonebook sort order. It is not the same as FirstName, LastName.) The index should be named idxManName.
  • LastName and FirstName should be a composite index for tblWoman. The index should be named idxWomanName.
  • LastName and FirstName should be a composite index for tblChild. The index should be named idxChildName.
  • FatherID should be a simple index for tblChild. The index should be named idxFather.
  • MotherID should be a simple index for tblChild. The index should be named idxMother.
  • DOB (in descending order) should be a simple index for tblChild. (Note: Descending date order means the youngest children will appear first.) The index should be named idxChildDOB.
  • A seventh index needs to be defined in order to handle the 1:1 spousal relationship:
  • WifeID should be a simple unique secondary index for tblMan. This index will prevent two men from identifying the same woman as their wife. The index should be named idxMarriage.
  • All indices except the child's DOB should be in ascending order.
  • Data Validation
  • A number of data validation rules (i.e., check constraints) need to be defined in order to ensure a high level of data quality:
  • All FirstNames and LastNames in tblMan, tblWoman and tblChild must have lengths of at least two. (B is not a name, but Bo is.)
  • MaidenName can be blank (null). If it isn't blank, then it must have a length of at least two.
  • Gender in tblChild must either be F or M. (Note: SQL is case insensitive, so it isn't necessary to check for f and m.)
  • No dates (DOB and DOM) in tblMan, tblWoman and tblChild can be in the future. All dates have to be less than or equal to today's date.
  • ManID, WomanID and ChildID must be greater than or equal to 1001.
  • If WifeID is blank, then DOM must also be blank. If WifeID is non-blank, then DOM must also be non-blank.
  • A child does not have to have a father. A child does not have to have a mother. But, every child must have at least one parent in the database.

Reference no: EM13927361

Questions Cloud

Calculate the mean, median, mode, standard deviation : This learning activity consists of a variety of problems from Chapters 13-15. Include a title page with your assignment in current APA. Answers must be clearly labeled and appear in consecutive order. Submit your assignment (answers only) as a Wor..
Create a java application using swing components : Create a java application using Swing Components. The java program should consist of showing values of cars depending upon the year and model selections, for a vehicle.
Formulate a linear programming model for the problem : The company wants to know the amount of each ore to use per ton of the alloy that will minimize the cost per ton of the alloy. a. Formulate a linear programming model for this problem.
Recommended action to address a recent e-commerce threat : In this project, you will research a solution to address the recent threat to the security of an ecommerce operation that you defined in Research Project 1 in Week 3. This is the continuation of your Week 3 project, and your revised Week 3 work wi..
Er diagram indicates the name and data type : Create an ERD for 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 rec..
Determine the probability of running out of cash : Buy-Low is considering a change in its capital structure that would increase its annual fixed charges by $10 million. Determine the probability of running out of cash during the recession if change in capital structure is undertaken.
Calculate hurricane lamps degree of combined leverage : Calculate Hurricane Lamp's degree of combined leverage (DCL) using the The definitional formula (Equation 14.5) and The simpler computational formula (Equation 14.7)
Demonstrate an understanding of the materials : Assume the role of Marketing Manager. Select a product (good or service) that is sold in the United States and has sales opportunities in a foreign market. Apply your critical thinking skills and the knowledge you have acquired throughout this cou..
Implement runge-kutta integration scheme : Implement Runge-Kutta integration scheme with Δ = 0:005 for system (2),(3).Plot the phase curves (trajectories x(t); y(t) in the phase/state space).

Reviews

Write a Review

Accounting Basics Questions & Answers

  Which account may contain a transposition error

A trial balance has total debits of $197,900 and total credits of $199,700. Which account may contain a transposition error?

  Calculate the amount of the interest expense for each option

Calculate the amount of the interest expense for each option. Determine the proceeds received by the borrower in each situation. Which alternative is more favorable to the borrower? Explain.

  The proceeds were recorded in a capital projects fund

The proceeds were recorded in a capital projects fund

  Evaluate the price and efficiency variances

Compute the flexible-budget variance and compute the price and efficiency variances.

  Complete the four right most columns

Complete the four right most columns of the table by first entering information for the four closing entries (keyed 1 through 4) and second by completing the post  closing trialbalance.

  Which one of following statements describes the rules about

which one of the following statements describes the rules about posting transactions into t-accounts in the ledger? for

  Ironwood corporation has ordinary taxable income of 40000

1. which of the following items would be includable in the gross income of the recipient?a. insurance payments for

  Prepare the journal entry to record giltz wages

Assuming a 6.2 percent social security tax rate and a 1.45 percent Medicare tax rate, prepare the journal entry to record Giltz's wages and related liabilities. Round to the nearest penny

  Te fats domino company uses a two-column general journal

the fats domino company uses a two-column general journal a cash recipts journal a cash payments journal a sales

  Journal entry to replenish the account

A $142 petty cash fund has cash of $24 and receipts of $121. Which of the following would be the credit in the journal entry to replenish the account?

  Identify the challenges one face in becoming more creative

What are the characteristics of an effective business model?

  Prepare the following budgets for march 2012a revenues

budgetschedulesforamanufacturer.logospecialtiesmanufacturesamongotherthingswoolen blankets for the athletic teams of

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd