There is Er Diagram of project which is already prepared Relational Schema Below;

This is Relational Schema of Er Diagram that given above.

I want you to write sample queries given below about relational schema;

• Implement the following types of queries in SQL ( at least 2 queries for each category):

1. A Subquery.
2. A Corelated Subquery.
3. UNION.
4. UNION ALL.
5. INTERSECT.
6. EXCEPT

ssn blood_grp name weight date etime name OUTSIDER mtime bp OUTSIDER (1,1) HEALTH RECORD purpose (1,1) has meets b temp mdate (1,1) (0,1) crld DOB start_date duration sex cr date cr time type Wld CRIMINAL (1,N) commits CRIME (1,N) (1,N) amount case_ld (0,N) do WORK Fname Lname (1,1) w_type Jall_ld cell ld (0,N) Has CELL JAIL ph_no (1,1) (1,1) Capacity e-mail jaller Ladd |_name CRIMINAL = (cr id, DOB, start_date, sex, Fname, Lname) JAIL = (jail id, ph_no, email, j_add, j_name, jailer) CELL = (cell id, capacity) WORK = (w id, amount, w_type, duration) HEALTH RECORD = (b_temp, bp, weight, blood grp, date) OUTSIDER = (ssn, name) CRIME = (type, case id) has = (date, cr_id, blood_grp) do = (duration, cr_id, w_id) occupy = (cr_id, jail_id) has = (cell_id, jail_id) commits= (cr_date, cr_crime, case_id, cr_id) meets = (purpose, mtime, etime, mdate, ssn, cr_id)