Consider the following relation:
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.
a. The TRIP relation has the following FDs and MVDs:
trip_id ? start_date
trip_id ?? cities_visited
trip_id ?? cards_used
b. Because there are no interdependencies, this relation can be trivially decomposed to conform to 4NF:
TRIP_DATE (trip_id, start_date)
TRIP_CITIES (trip_id, cities_visited)
TRIP_CARDS (trip_id, cards_used)
You might also like to view...
________ view allows alteration of the report design while viewing the data
A) Layout B) Output C) Design D) Report
Which of the following would NOT be included in the data portion of an Ethernet frame on an IP network?
A. the data being sent B. the IP addresses of the sending and receiving systems C. sequencing numbers D. the length of the data being transmitted