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