Write a SQL query based on their data structure to identify those who have not attended classes there. Avoid using set operations and subqueries (use an outer join).

Write a SQL query using their schema to find out who hasn't taken a course at the university. There should be no subqueries or set actions (use an outer join).

Write SQL queries DDL Queries to implement the following Relational  Model i.e. create the Nurse and Care_Center relations (including primary key  and foreign key). Intelligently write data types.

Considering Vaccination Database, write queries to: Display the Subject CNIC, Name, Contact, Dose1 Center, and Dose2 Center as shown below: CNIC Name Contact Dose1 Center Dose2 Center 22401-6645321-1 Nasir 3409991112 Lachi Kohat 2 14301-6045321-5 Shahab 3409991112 kohat 3 Dara The subjects who have been vaccinated different types in Dose1 and Dose2. For instance, subjects who were vaccinated ‘Sinovac’ in the first dose, while Pfizer in the second dose.How many Viles of each type have been consumed so far. How many subjects are vaccinated from expired viles. Suggest the name of Incharge for the best performance award based on the highest number of subjects vaccinated on a single day