Databases Coursework Example | Topics and Well Written Essays - 2250 words

Databases - Coursework Example 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. Records for four patients were created, two for each clinic. Patient ID is chosen as a combination of clinic number of the clinic at which the registration is performed and a patient number incremented by one upon each entry. SQL statements and screenshot of populated table is shown below: Two rows are created for two vaccines: One for typhoid and another for yellow fever. VaccineID for each vaccine are chosen as an integer which increments by one upon every entry. Invoice cost is populated by querying the vaccine table for vaccine cost based on the vaccine id for which the invoice is created. The SQL statements and screen shot of populated table are shown below: Four invoices were recorded for two registered patients one for each clinic. Invoice ID are chosen as numbers incremented by one upon each entry. SQL statements and screen shot of populated table are shown below: Four rows were inserted, two for each clinic. Appointment ID is chosen as a combination of date on which the appointment is fixed and an appointment number incremented by one upon each entry for the day. The SQL statements and the populated table are shown