Database Systems 6th Edition by Ramez Elmasri, Shamkant B. Navathe

تمرين 5

Consider the following relation:
TRIP (trip_id, start_date, cities_visited, cards_used)
This relation refers to business trips made by salesmen in a company. Suppose the trip has a single start_date but involves many cities and one may use multiple credit cards for that trip. Make up a mock-up population of the table.
a. Discuss what FDs and / or MVDs exist in this relation.
b. Show how you will go about normalizing it.