Analyze a collection of incorrectly designed relational schemas listed below. To find what is wrong with the relational schemas listed below use a method of row insertions explained in a presentation 01 Database Design Quality. Insert into the relational tables with the schemas (headers) listed below from 3 to 5 rows that demonstrate the redundancies. Include into a file solution2.pdf the drawings of relational tables with redundancies and briefly explain the reasons behind each redundancy. The scanned neat hand drawings are acceptable.

TRIP(driver-licence, truck-rego, capacity) A relational table TRIP contains information about the trips performed by the drivers (driver-licence) using the trucks (truck-rego), that have a given capacity (capacity). A driver is allowed to use many trucks and a truck can be used by many drivers.

RESTAURANT(city, street, bldg-num, population) A relational table RESTAURAT contains information about the restaurants located in different cities (city) at different addresses (street, bldg-num). A relational table RESTAURANT also contains information about population (population) of each city.

TRANSPORT(company, car-rego, truck-rego) A relational table TRANSPORT contains information about the registration numbers and of the cars (car-rego) and trucks(truck-rego) owned by the transportation companies (company). Each company owns many cars and many trucks.