For this assignment you will create SQL queries use the following database schema:Patient—PatientID, Name, DOBDoctor—DoctorID, Name, MedLicenseNumber, PhoneMedication—MedicationID, BrandName, GenericNamePrescription—PrescriptionID, Date, PatientID, PrescriberID, MedicationIDSpecify the SQL queries to retrieve:A list of all doctors.The number of patients who were born before 01/01/1994.The patient information along with the ID of any prescribing doctor for each patient.The prescription information along with patient name, DOB, medication brand name, and prescribing doctor name sorted by most recent date.The most prescribed generic medication name.

For this assignment, you will write a medium size paper (~1250 words) about a recent (within the past 5-8 years or so) and specific incident related to a software or computerized system failure. Please read the PDF

You are given a software that takes the Social Security Number (SSN) of an individual and checks it with the records in its database to verify it.Please discuss, with examples, what can constitute threats against each of the given requirements for the software and the server it is running on (1 example for each is enough):Confidentiality IntegrityAuthenticityAccountabilityAvailabilityExample:A DDoS attack would constitue a threat against Availability of the server.(Not asking for the explaination of the requirements, but examples of threats like the given example above)