CSE :: Database System 2 - CS
- Each answer below shows example data from a table. Which answer is an example of the missing values problem?
- When assessing the table structure of an acquired set of tables with data, determining functional dependencies is (part of) the:
- Each answer below shows example data from a table. Which answer is an example of the multivalue, multicolumn problem?
- When assessing the table structure of an acquired set of tables with data, counting the number of table rows is (part of) the:
- If a table has been normalized so that all determinants are candidate keys, then that table is in:
- Needing to assess the validity of assumed referential integrity constraints on foreign keys is a(n) ________ of normalization.
- When assessing the table structure of an acquired set of tables with data, determining primary keys is (part of) the:
- Each answer below shows example data from a table. Which answer is an example of the inconsistent values problem?
|
A.
Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row. |
|
B.
Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column. |
|
C.
Three rows have the values Brown, NULL, and Blue in the same column. |
|
D.
One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column. |
Whatsapp
Facebook
|
A.
Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row. |
|
B.
Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column. |
|
C.
Three rows have the values Brown, NULL, and Blue in the same column. |
|
D.
One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column. |
|
A.
Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row. |
|
B.
Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column. |
|
C.
Three rows have the values Brown, NULL, and Blue in the same column. |
|
D.
One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column. |