Consider the following relation: TRIP (Trip_id, Start_date, Cities_visited, Cards_used) This relation refers to business trips made by
Fantastic news! We've Found the answer you've been seeking!
Question:
Consider the following relation:
TRIP (Trip_id, Start_date, Cities_visited, Cards_used)
This relation refers to business trips made by company salespeople. Suppose the TRIP has a single Start_date but involves many cities and salespeople may use multiple credit cards on the 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 the relation.
Related Book For
Fundamentals of Database Systems
ISBN: 978-0136086208
6th edition
Authors: Ramez Elmasri, Shamkant Navathe
Posted Date: