Discussion
Home ‣ Database ‣ Data Models into Database Designs Comments
- Question
Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship?
Options- A. MUST COVER
- B. MUST NOT
- C. Both of the above.
- D. None of the above is correct.
- Correct Answer
- MUST COVER
- 1. Each answer below shows example data from a table. Which answer is an example of the missing values problem?
Options- 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. Discuss
- 2. When assessing the table structure of an acquired set of tables with data, counting the number of table rows is (part of) the:
Options- A. first step.
- B. second step.
- C. third step.
- D. fourth step. Discuss
- 3. If a table has been normalized so that all determinants are candidate keys, then that table is in:
Options- A. 1NF.
- B. 2NF.
- C. 3NF.
- D. BCNF. Discuss
- 4. Most of the time, modification anomalies are serious enough that tables should be normalized into:
Options- A. 1NF.
- B. 2NF.
- C. 3NF.
- D. BCNF. Discuss
- 5. Using the SQL GROUP BY phrase with a SELECT statement can help detect which of the following problems?
Options- A. The multivalue, multicolumn problem
- B. The inconsistent values problem
- C. The missing values problem
- D. The general-purpose remarks column problem Discuss
- 6. A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n):
Options- A. primary key.
- B. foreign key.
- C. composite key.
- D. surrogate key. Discuss
- 7. For every relationship, how many possible sets of minimum cardinalities are there?
Options- A. Two
- B. Three
- C. Four
- D. Six Discuss
- 8. Which of the following data constraints would be used to specify that the value of cells in a column must be one of a specific set of possible values?
Options- A. A domain constraint
- B. A range constraint
- C. An intrarelation constraint
- D. An interrelation constraint Discuss
- 9. A foreign key is:
Options- A. a column containing the primary key of another table.
- B. used to define data types.
- C. used to define null status.
- D. all of the above are above correct. Discuss
- 10. For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?
Options- A. Two
- B. Three
- C. Four
- D. Six Discuss
Data Models into Database Designs problems
Search Results
Correct Answer: Three rows have the values Brown, NULL, and Blue in the same column.
Correct Answer: first step.
Correct Answer: BCNF.
Correct Answer: BCNF.
Correct Answer: The inconsistent values problem
Correct Answer: surrogate key.
Correct Answer: Four
Correct Answer: A domain constraint
Correct Answer: a column containing the primary key of another table.
Correct Answer: Six
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.