Kizspy | Question: 44
(Choose 1 answer)
If our user interface (i.e., like iTunes) has repeated strings on one column of the user interface, how should we
model this properly in a database?
A. Put the string in the first row where it occurs and then put NULL in all of the other rows
B. Put the string in the first row where it occurs and then put that row number in the column of all of the rest of
the rows where the string occurs
C. Put the string in the last row where it occurs and put the number of that row in the column of all of the rest
of the rows where the string occurs
D. Make a table that maps the strings in the column to numbers and then use those numbers in the column
E. Encode the entire row as JSON and store it in a TEXT column in the database
