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.

Selected t-account balances for bloomfield company are shown below as of january 31, which reflect its accounting adjustments. the firm uses a calendar-year accounting period, but prepares monthly accounting adjustments.suppliesjan. 31 bal. 1,800 1,800 jan. 31 bal.supplies expensejan. 31 bal. 1,920 1,148 jan. 31 bal.prepaid insurancejan. 31 bal. 1,148 1,148 jan. 31 bal.insurance expensejan. 31 bal. 164 164 jan. 31 bal.wages payablejan. 31 bal. 1,400 1,400 jan. 31 bal.wages expensejan. 31 bal. 6,400 6,400 jan. 31 bal.truckjan. 31 bal. 17,376 17,376 jan. 31 bal.accumulated depreciation -truckjan. 31 bal. 5,068 5,068 jan. 31 bal.a. if the amount in supplies expense represents the january 31 adjustment for the supplies used in january, and $1,240 worth of supplies were purchased during january, what was the january 1 beginning balance of supplies? $answerb. the amount in the insurance expense account represents the adjustment made at january 31 for january insurance expense. if the original insurance premium was for one year, what was the amount of the premium, and on what date did the insurance policy start? amount of the premium $answerthe policy began on answerjune 1july 1august 1september 1october 1november 1 of the previous year.c. if we assume that no beginning balance existed in either in either wage payable or wage expense on january 1, how much cash was paid as wages during january? $answerd. if the truck has a useful life of four years (or 48 months), what is the monthly amount of depreciation expense, and how many months has bloomfield owned the truck? answermonths