Load training databases: ZOO HOSPITAL Connection panel: Open Or create: Personal connection Queries part Relational algebra testing commands: The queries in RA are experimental and serve as example solutions, not complex solutions of relational algebra. It is supported by: Simple projection whole Entity[*] or partial projection Entity[A1...An] Simple selection Entity(E.a = < > ! AND, OR value) Simple selection and projection over the Entity(condition E.a = < > ! AND, OR value)[A1...An] Simple Natural Join operation * with n Entities and we are working on left and right natural join and anti-join between 2 Entities Renaming operator E[A -> new NAME] * <* *> | { } ( ) ( ) [ ] [ ] -> | AND OR = < > ! | ∪ ∩ \ × RA query: Be carefull on {} parenthensis order. Correct is in example: {E1(id = 1)[PID,DID]} * {E2} OR {{E1} * {E2}} Execute RA Translate RA to SQL SQL query: Execute Query Save query as type A - Simple (positive) query with at least two joined tables (list of patients - name, address who were examined by doctor Braun)B - Simple (negative) query (list of patients - name, address who were not visiting doctor Braun) (select all doctors who had patients,...)C - Choose all records, which have relation for "X" only …(list of patients - name, address who were examined by doctor Braun ONLY - the patients didn't have visit at another doctor).D1 - Select all records which are at the relation with all.General quantified query (list of doctors - name, address who were visited by EACH patient, who visited doctor Braun)D2 - The result validity check from category D1. For example if query {list of teachers, who had lecture during ALL semesters begin at winter 2001/2002 till summer semester 2008/2008 included} shows the teacher "123 Josef Pavlicek", so the validity check will be query {{list of all semester at the season, where was teaching Pavlicek }\ (Except){list of all semester at the season}} and the result must be empty.F1 - JOIN - JOIN ONF2 - NATURAL JOIN or JOIN USINGF3 - CROSS JOINF4 - LEFT or RIGHT OUTER JOINF5 - FULL (OUTER) JOING1 - Subquery inside WHEREG2 - Subquery inside FROMG3 - Subquery inside SELECTG4 - Correlated subquery (EXISTS | NOT EXISTS)H1 - Set union query - UNIONH2 - Set substraction query - EXCEPT or MINUS (v Oracle)H3 - Set intersection - INTERSECTI1 - Aggregation functions (count | sum | min | max| avg)I2 - Aggregations with GROUP BY (HAVING) clauseJ - The same query using three different formulations in SQLK - All select clauses - SELECT FROM WHERE GROUP BY HAVING ORDER BYL - Make VIEWM - VIEW used queryN - Insert statement for inserting list of records - INSERT without clause VALUES use, for example ( add customer ID 6 all green boats reservation for all needed time intervals)O - UPDATE statement with subquery in WHERE/SETP - DELETE statement with subquery in WHERE clauseINSERT_SCRIPT - Insert script that fills all tables with dataDDL_SCRIP - DDL script that creates all tables in the schema SQL ouput: System status: