Database Management System
Entity Relationship (ER) Modeling
Q. Which of the following can be addressed by enforcing a referential integrity constraint?
A.  All phone numbers must include the area code B.  

Certain fields are required (such as the email address, or phone number) before the record is accepted

 C.  Information on the customer must be known before anything can be sold to that customer D.  

Then entering an order quantity, the user must input a number and not some text (i.e., 12 rather than ‘a dozen’)
Similar Questions
1. In the relational modes, cardinality is termed as:
A.  Number of tuples. B.  Number of attributes. C.  Number of tables. D.  Number of constraints.
2. . In an E-R diagram attributes are represented by
A.  rectangle B.  square C.  ellipse D.  triangle
3. In an E-R diagram an entity set is represent by a
A.  rectangle B.  ellipse C.  diamond box. D.  circle
4. E-R model uses this symbol to represent weak entity set ?
A.  Dotted rectangle. B.  Diamond C.  Doubly outlined rectangle D.  None of these
5. What is a relationship called when it is maintained between two entities?
A.  Unary B.  Binary C.  Ternary D.  Quaternary
6. A set of possible data values is called
A.  attribute B.  degree C.  tuple D.  domain
7. Which of the following is another name for weak entity?
A.  Child B.  Owner C.  Dominant D.  All of the above
8. In E-R Diagram relationship type is represented by
A.  Ellipse B.  Dashed ellipse C.  Rectangle D.  Diamond
9. In E-R diagram generalization is represented by
A.  Ellipse B.  Dashed ellipse C.  Rectangle D.  Triangle
10. A relational database consists of a collection of
A.   Tables B.   Fields C.   Records D.   Keys
DATABASE MANAGEMENT SYSTEM TOPICS