Complete 9 page APA formatted essay: Databases.
The insert statements used for the creation of two rows are shown below along with the screen shot of populated table.
Four staffs were added, two for each clinic. One staff is assumed to a nurse and the other as manager. ID for each staff is populated as a combination of year of joining, the clinic number and staff number. The city for each staff is populated with the same value as the city in which the clinic (they are employed) is located. Two managers were then updated in the clinic table. The SQL statements and the screen shot of populated table are shown below.