Answer Happy

DATA MANAGEMENT SHORTAND NOTATION FOR RELATIONAL SQL TABLES Notation Meaning Example A or A. B Underlined Superscript name A or A, BR The attribute(s) is (are) a primary key The attribute(s) is (are) a foreign key referencing relation R of relation A <any SQL type>, B <any SQL type>, C<any SQL type>, D <any SQL type>, E <any SQL type>, PRIMARY KEY(A), As an example, the schema FOREIGN KEY (E) REFERENCES S(F) R(A, B, C, D, ES) S(E, G, H) F <any SQL type>, G <any SQL type>, corresponds to the following SQL tables: H <any SQL type>, PRIMARY KEY(F)) EXERCISE Consider the following relational schema, representing six relations describing flight-related information [the used notation is explained above]. PERSON (Person, City) AIRPORT (Airport, City, Category) TICKET (Ticket, Emission_Date, Agency, Cost, Person PERSON, Departure AIRPORT, DestinationAIRPORT, AirlineAIRLINE, Date) CHECKEDBAGGAGE (Ticket TICKET, Baggage_Items) AIRLINE (Airline, Country) SERVICE (Airline AIRLINE, AirportAIRPORT, Service) 1) Answer the following questions considering the domain described by the previous relational schema: 1.1. How many airports can an airline operate at? (provide the minimum and the maximum number) 1.2. How many tickets can refer to a given airline? (provide the minimum and the maximum number) 2) Write the SQL query representing the following request: 2.1. Determine the total number of German airlines for which no ticket has been emitted in May, 2021. CREATE TABLE R ( ); CREATE TABLE S (