The following relational model represents a HRM system of a consultancy firm. The primary keys are underlined while foreign keys are in italic font. Consultant ( ConsultantID, Date of Birth, Expertise)

Assigned_to ( ConsultantID, ProjectID)
ConsultantID refers to ConsultantID in Consultant
ProjectID refers to ProjectID in Project

Project ( ProjectID, Description, Type, Company)
Company refers to Name in Company

Company ( Name, Location)

Suppose a new consultant is hired and immediately assigned to a new training project at a new firm and to 2 other, already existing projects. How many rows (tuples) must be added to the database to reflect this change?
A. 1
B. 3
C. 5
D. 6

Given the following relation:

Wine ( ID, name, grape, region, country)

Which statement is correct?
A. The relation is not in 1NF.
B. The relation is in 1NF but not in 2NF.
C. The relations is in 2NF but not in 3NF.
D. The relation is in 3NF but not in BCNF.
Given the following relational model (primary keys are underlined, foreign keys in italics):

STUDENT( studentnumber, studentname, street name, street number, zip code, city)
ENROLLED( student_number, course_number)
COURSE( course number, course name)
PROFESSOR( professor number, professor name)
TEACHES( course number, professor number)

Which statement is CORRECT?
A. The model does not allow a course to be taught by multiple professors.
B. The model can be further normalized.
C. The model does not allow a professor to teach multiple courses.
D. The model does not allow a course to be followed by multiple students.

Each of the following scenarios is based on facts in anactual fraud. categorize each scenario as primarily indicating (1) anincentive to commit fraud, (2) an opportunity to commit fraud, or(3) a rationalization for committing fraud. also state your reasoningfor each scenario.a. there was intense pressure to keep the corporation ' stock from declining further. this pressure came from investors, analysts,and the ceo, whose financial well-being was significantly dependent on the corporation ' s stock price.b. a group of top-level management was compensated (mostly in the form of stock-options) well in excess of what would be considered normal for their positions in this industry.c. top management of the company closely guards internal financial information, to the extent that even some employees on a “need-to-know basis” are denied full access.d. managing specific financial ratios is very important to the company, and both management and analysts are keenly observant of variability in key ratios. key ratios for the company changed very little even though the ratios for the overall industry were quite volatile during the time period.e. in an effort to reduce certain accrued expenses to meet budget targets, the cfo directs the general accounting department to reallocate a division’s expenses by a significant amount. the general accounting department refuses to acquiesce to the request, but the journal entry is made trough the corporate office. an accountant in the general accounting department is uncomfortable with the journal entries required to reallocate divisional expenses. he brings his concerns to the cfo, who assures him that everything will be fine and that the entries are necessary. the accountant considers resigning, but he does not have another job lined up and is worried about supporting his family. therefore, he never voices his concerns to either the internal or external auditors.f. accounting records were either nonexistent or in a state of such disorganization that significant effort was required to locate or compile them.

Gary becker's controversial the economics of discrimination concludes that price discrimination has no effect on final profits. price discrimination benefits monopolies. labor discrimination in hiring results in more efficient allocations of production. discrimination in hiring practices has no effect on final profits. labor discrimination harms firms that practice it due to increased labor costs. price discrimination harms monopolies, which refutes over two centuries of economic theory.

Calculate riverside’s financial ratios for 2014. assume that riverside had $1,000,000 in lease payments and $1,400,000 in debt principal repayments in 2014. (hint: use the book discussion to identify the applicable ratios.)