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...
If your computer is connected to the Internet, the contents of the Help page reflect both the ____ installed on the computer and material from Microsoft's website.
A. anti-virus software B. apps C. reference folders D. local help files
A data ________ is assigned a unique color or pattern represented in the chart legend
A) series B) range C) point D) marker
By adding the __________ method within event handler code, you prevent touch actions on specific elements from also triggering interface gestures.
Fill in the blank(s) with the appropriate word(s).
Please briefly describe each of the following important features of Internet Explorer: Address bar and search box, webpage tab, Home button, Favorites button, Tools button, and Document window.
What will be an ideal response?