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

Databases - Coursework ExampleThe insert statements used for the creation of two rows ar shown below along with the test shot of live table.Four staves were added, two for distributively clinic. One staff is assumed to a nurse and the other as manager. ID for each staff is dwell as a combination of year of joining, the clinic number and staff number. The city for each staff is populated with the same shelter 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 elect as a combination of clinic number of the clinic at which the registration is performed and a patient number incremented by one and only(a) upon each entry. SQL statements and screenshot of populated table is shown belowTwo rows are created for two vaccines One for typhoid and another for yellow fever. Vacc ineID for each vaccine are chosen as an integer which increments by one upon every entry. Invoice appeal is populated by querying the vaccine table for vaccine cost based on the vaccine id for which the story is created. The SQL statements and screen shot of populated table are shown belowFour 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 belowFour 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