The deletion anomaly refers to a situation where 

Consider the following ER diagram, how many tables do you need to create (i.e. database schema) to store all the data and relationships in the diagram? 

Given the same table X(A,B) and descriptions as in previous question.  The following two queries are equivalent (i.e., will return the same set of results.)  1. select distinct B from X; 2. select B from X group by B;

ETL (extract, transform, load) is only required when we are combining several sources of data into data warehouse. In another word, when the only source of data for a company’s data warehouse is its operational database, then ETL is not necessary.    

An OTA works at an assisted living facility where the main focus is developing a monthly newsletter using a computer. The OTA assigned residents a specific job and time of day to work on his or her task with strict deadlines. Many residents do not complete their tasks and refuse to attend other leisure activities. The OTA should:

Of the following, the activity that is MOST likely to provide the greatest opportunity for development of decision-making is:

The COTA is working with a patient who has difficulty attending to a task and sustaining attention for a reasonable length of time. Which of the following activities would be MOST appropriate for the patient?

The COTA is working a man with impaired memory. When the client is unable to follow verbal instructions, the COTA changes her approach to demonstration. This is an example of:

An OTA is experiencing tension headaches, backaches, and insomnia. The OTA should:

The OTA is discussing leisure with an individual to determine intervention. Using a client-centered approach, the OTA should first: