Consider the following relation: TRIP (trip_id, start_date, cities_visited, cards_used) This relation refers to business trips made by

Question:

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.
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  answer-question

Fundamentals of Database Systems

ISBN: 978-0136086208

6th edition

Authors: Ramez Elmasri, Shamkant Navathe

Question Posted: