Chat with AI
Database Systems 6th Edition by Ramez Elmasri, Shamkant B. Navathe
Edition 6ISBN: 0136086209Database Systems 6th Edition by Ramez Elmasri, Shamkant B. Navathe
Edition 6ISBN: 0136086209 Exercise 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.
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.
Explanation
Verified
Verified
a. The TRIP relation has the following F...
Database Systems 6th Edition by Ramez Elmasri, Shamkant B. Navathe
Why don’t you like this exercise?
Other Minimum 8 character and maximum 255 character
Character 255
