Question

The employee is table, the best candidate for primary key is
Select one:
a. Department ID
b. Employee hiredate
c. Employee ID
d. Employee salary
Question 2
A primary key can be composed of more than one attribute.
Select one:
True
False
Question 3
A foreign key allows you to join two tables.
Select one:
True
False
Question 4
Given two tables, department (dept_id, dept_location, dept_name) and EMPLOYEE(emp_id, emp_name, emp_dept_id, emp_name, emp_salary), which attribute (column) is the foreign key?

Select one:
a. DEPARTMENT table, dept_id column
b. DEPARTMENT table, dept_location column
c. DEPARTMENT table, dept_name column
d. EMPLOYEE table, dept_id column
e. EMPLOYEE table, emp_id column
f. EMPLOYEE table, emp_name column
g. EMPLOYEE table, emp_salary column
Question 5
In the relationship, a PHYSICIAN cares for many PATIENTS, where/what is the foreign key?
Select one:
a. PHYSICIAN table, physician_certification column
b. PHYSICIAN table, physican_id column
c. PHYSICIAN table, physician_name column
d. PATIENT table, physician_id column
e. PATIENT table, patient_id column
f. PATIENT table, patient_name column
Question 6
CASE tools will automatically perform many steps in the conversion of ER diagrams to relations. Which of the following is true about CASE conversions?

Select one:
a. It is better to allow these tools to work without human involvement to ensure complete accuracy of the conversion
b. CASE tools are rare and specialized so all modelers must do their own conversions
c. CASE tools cannot model complex data relationships and you must make choices between legitimate alternatives
d. CASE tools were created because the conversion steps are too complex for most modelers
Question 7
What are the steps involved in transforming an EER diagram into relations?

Select one:
a. first normal form, second normal form, third normal form, Boyce-Codd normal form, forth normal form, fifth normal form
b. identify the entities, identify the attributes document the relationships, define associative entities, create supertypes/subtypes
c. map regular entities, map weak entities, map binary entities, map associative entities, map unary relationships, map ternary (and n-ary) relationships, map supertype/subtype relationships
d. remove repeating groups, select the primary key, remove transitive dependencies
Question 8
The first normal form for relations definition that a relation must contain no multivalued attributes has an equivalent form for ER: all attributes must be single-valued.
Select one:
True
False
Question 9
A relation may be in second normal form without being in first normal form.
Select one:
True
False
Question 10
How do you fix a problem with second normal form?
Select one:
a. combine relations
b. create a new relation
c. delete the offending attributes from the model
d. you can't, you have to start all over
Question 11
A relation in which a nonkey attribute is dependent on another non-key attribute is in third normal form.
Select one:
True
False
Question 12

Which of the attributes in the following table is a problem because it is a homonym?
Select one:
a. person_id
b. person_name
c. person_date
d. person_age
e. person_height
Question 13
Which of the attributes in the following table is a problem because it is derived data?
Select one:
a. person_id
b. person_name
c. person_birthdate
d. person_age
e. person_height
Question 14
How do you implement a many-to-many relation?
Select one:
a. using an associative entity
b. with the relations exactly as diagrammed
c. you have to go back and revise the business rules
Question text
A relation is in second normal form when a non key attribute is functionally dependent on part (but not all) of the primary key.

Select one:
True
False
Question 16

Third normal form is important because

Select one:
a. It eliminates partial functional dependencies
b. It eliminates transitive dependencies that can create anomalies
c. It removes multivalued dependencies
d. It requires that a primary key be defined to uniquely identify each row

Answer 1

Question 1)

The employee is table, the best candidate for primary key is
Select one:
a. Department ID
b. Employee hiredate
c. Employee ID
d. Employee salary

Answer) c. Employee ID

Explanation: Since Employee ID is unique for all the employees, it is the best candidate for primary key.

----------------------------------------------------------------------------------------------------------------------------------
Question 2
A primary key can be composed of more than one attribute.
Select one:
True
False

Answer) True

Explanation: Fore example, consider the table WORKS_ON tables (this table stores the details the projects and the employees who worked on it). The primary key for this table is (Employee ID, Project ID).

----------------------------------------------------------------------------------------------------------------------------------
Question 3
A foreign key allows you to join two tables.
Select one:
True
False

Answer) True

Explanation: The foreign key to used to maintain the child tables of a parent table. Hence, it is used to join parent and child tables.

----------------------------------------------------------------------------------------------------------------------------------
Question 4
Given two tables, department (dept_id, dept_location, dept_name) and EMPLOYEE(emp_id, emp_name, emp_dept_id, emp_name, emp_salary), which attribute (column) is the foreign key?

Select one:
a. DEPARTMENT table, dept_id column
b. DEPARTMENT table, dept_location column
c. DEPARTMENT table, dept_name column
d. EMPLOYEE table, dept_id column
e. EMPLOYEE table, emp_id column
f. EMPLOYEE table, emp_name column
g. EMPLOYEE table, emp_salary column

Answer) d. EMPLOYEE table, dept_id column

Explanation: The EMPLOYEE table is a child table of DEPARTMENT and it contains a reference to dept_id column.

----------------------------------------------------------------------------------------------------------------------------------
Question 5
In the relationship, a PHYSICIAN cares for many PATIENTS, where/what is the foreign key?
Select one:
a. PHYSICIAN table, physician_certification column
b. PHYSICIAN table, physican_id column
c. PHYSICIAN table, physician_name column
d. PATIENT table, physician_id column
e. PATIENT table, patient_id column
f. PATIENT table, patient_name column

Answer) d. PATIENT table, physician_id column

Explanation: In this scenario, PHYSICIAN is the parent table and PATIENT is the child table which needs to contains a foreign key reference to the Primary key of PHYSICIAN table.

NOTE: As per HOMEWORKLIB POLICY, I am allowed to answer only 4 questions on a single post. I have gone ahead and answered 5. Kindly post the remaining questions separately and I will try to answer them. Sorry for the inconvenience caused.