Relational Algebra

• Generate relational algebra to answer the queries below.
• Use standard notation and replace all underlined(Bold) terms with your own values and maintain the intent of the search. For instance: replace Yankee Stadium with another location and replace Monday with another day.
• Create descriptive attribute labels.

1. Identify available appointment slots on March 1 at Yankee Stadium. Display the location, date and time slots available.
2. Identify patients with appointments today at Yankee Stadium. Display the patient name, vaccine manufacturer, patient address and email.
3. Identify patents that cancelled or didnt show up for appointments yesterday at Yankee Stadium. Display the patient name, vaccine manufacturer, appointment date, time and location.
4. Identify staff assigned to the Yankee Stadium vaccine administration site on March 1. Display the staff name.
5. Identify eligible patients without appointments. Eligible could be based on age, occupation, pre-existing medical conditions. Display the patient name, age address, pre-existing conditions and occupation.
6. Identify the number of vaccine doses available by borough now. Display two columns: Borough and number of vaccine doses available. Display one row for each distinct Borough. Use an aggregate function and grouping operation to answer this question.
7. Identify the number of appointments scheduled by borough tomorrow. Display two columns: Borough and number of appointments requested. Display one row for each distinct Borough. Use an aggregate function and grouping operation to answer this question.
8. There are insufficient available vaccine dosages to satisfy all the appointments tomorrow. Identify appointments of patients less than age 65 in Brooklyn. Display the patient name, address and email.
9. Identify vaccine dosages administered in the last 6 months by patient zip-code. Display two columns: Patient zip code and number of dosages administered. Display one row for each distinct patient zip-code. Use an aggregate function and grouping operation to answer this question.

10. Identify vaccine dosages administered in the last 6 months by vaccine manufacturer. Display two columns: Vaccine manufacturer and number of dosages administered. Display one row for each distinct vaccine manufacturer. Use an aggregate function and grouping operation to answer this question