Show how you will go about normalizing


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 it.

Request for Solution File

Ask an Expert for Answer!!
Basic Computer Science: Show how you will go about normalizing
Reference No:- TGS01399838

Expected delivery within 24 Hours