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.
Please let us know your comments regarding the correct answer to the question. Each of your comments will be evaluated by us and correct comments will be shared.