Discussion
Home ‣ Database ‣ Data Modeling with ER Model See What Others Are Saying!
- Question
A maximum cardinality is the maximum number of entity instances that can participate in a relationship instance.
Options- A. True
- B. False
- Correct Answer
- True
- 1. 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
- 2. We have done an RFM analysis on our customer data. Mary Jones has a score of "1 1 5". This series means that Mary ________ .
Options- A. Has ordered recently, orders frequently, and places a large order when she orders.
- B. Hasn't ordered recently, orders infrequently, but places a large order when she orders.
- C. Has ordered recently, orders frequently, but doesn't place a large order when she orders
- D. Hasn't ordered recently, orders infrequently, and doesn't place a large order when she orders. Discuss
- 3. A supertype/subtype hierarchy has which of the following features?
Options- A. Subtypes at the lower lever in the hierarchy inherit attributes only from their immediate supertype.
- B. Attributes are assigned at the highest logical level.
- C. Subtypes at the higher lever in the hierarchy inherit attributes only from their immediate subtype.
- D. Attributes are assigned at the lowest logical level. Discuss
- 4. CASE tools do not include which of the following features?
Options- A. Help to draw data models
- B. Help to generate code
- C. Help to manage people
- D. Create an information repository Discuss
- 5. When a foreign key column is created without a corresponding foreign key constraint, we have created a "casual relationship" between the two tables.
Options- A. True
- B. False Discuss
- 6. When an entity instance must be a member of only one subtype, it is which of the following?
Options- A. Disjoint with total specialization
- B. Disjoint with partial specialization
- C. Overlap with total specialization
- D. Overlap with partial specialization Discuss
- 7. A database application can perform which of the following activities?
Options- A. Add records
- B. Read records
- C. Update records
- D. All of the above. Discuss
- 8. Structured Query Language (SQL) is an internationally recognized standard language that is understood by all commercial database management system products.
Options- A. True
- B. False Discuss
- 9. Typically, there should be at least two different copies of the database schema used in the redesign process.
Options- A. True
- B. False Discuss
- 10. A primary key is which of the following?
Options- A. Any attribute
- B. An attribute that uniquely identifies each row
- C. An attribute that uniquely identifies each column
- D. A derived attribute Discuss
More questions
Correct Answer: BCNF.
Correct Answer: Has ordered recently, orders frequently, but doesn't place a large order when she orders
Correct Answer: Attributes are assigned at the highest logical level.
Correct Answer: Help to manage people
Correct Answer: True
Correct Answer: Disjoint with total specialization
Correct Answer: All of the above.
Correct Answer: True
Correct Answer: False
Correct Answer: An attribute that uniquely identifies each row
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.