A Garbage Truck company collects garbage from the local neighborhood. The company sends out TRUCKS to all the STREETS of the neighborhood, though each HOUSE has to be registered for garbage collection. Each TRUCK has its own ID, but can have different DRIVERS operating it.
Not every driver is assigned to a truck. Some trucks do not have drivers assigned to them.
- List ALL the STREETS that each TRUCK services
- List ALL the STREETS and HOUSES that each TRUCK services
- List ALL the STREETS and HOUSES that a single TRUCK services
- List ALL the DRIVERS that each TRUCK has
- List ALL the DRIVERS that a single TRUCK has
- Insert 2 new TRUCKS that DON'T have DRIVERS assigned to them
- List ALL the TRUCKS that don't have DRIVERS assigned to them
- Insert 3 new DRIVERS that aren't assigned to TRUCKS
- List ALL the DRIVERS that aren't assigned to TRUCKS
- Delete a DRIVER and all information related to him down the relationship tree