Exam 5: Data Modeling With the Entity-Relationship Model
Exam 1: Introduction100 Questions
Exam 2: Introduction to Structured Query Language SQL100 Questions
Exam 3: The Relational Model and Normalization100 Questions
Exam 4: Database Design Using Normalization100 Questions
Exam 5: Data Modeling With the Entity-Relationship Model100 Questions
Exam 6: Transforming Data Models Into Database Designs103 Questions
Exam 7: SQL for Database Construction and Application Processing105 Questions
Exam 8: Database Redesign101 Questions
Exam 9: Managing Multiuser Databases102 Questions
Exam 10: Managing Databases With SQL Server 2008 R2100 Questions
Exam 11: Managing Databases With Oracle Database 11g100 Questions
Exam 12: Managing Databases With MySQL 55100 Questions
Exam 13: The Web Server Environment110 Questions
Exam 14: Database Processing With XML100 Questions
Exam 15: Database Processing for Business Intelligence Systems101 Questions
Exam 16: Microsoft Access 201048 Questions
Exam 17: Getting Started With Systems Analysis and Design35 Questions
Exam 18: E-R Diagrams and the Idef1x Standard35 Questions
Exam 19: E-R Diagrams and the UML Standard36 Questions
Exam 20: Getting Started With MySQL Workbench Data Modeling Tools37 Questions
Exam 21: Getting Started With Microsoft Visio 201036 Questions
Exam 22: the Semantic Object Model35 Questions
Exam 23: Data Structures for Database Processing35 Questions
Exam 24: Getting Started With Web Servers php and the Eclipse PDT35 Questions
Select questions type
A relationship's minimum cardinality indicates the number of entity instances that must participate in the relationship.
(True/False)
4.9/5
(37)
A hash mark across the relationship line near an entity indicates ________.
(Multiple Choice)
4.8/5
(39)
There are three types of recursive relationships: 1:1,1:N and N:M.
(True/False)
4.8/5
(44)
Entities with an IS-A relationship should have the same identifier.
(True/False)
4.8/5
(42)
-You are given an E-R diagram with two entities,ORDER and CUSTOMER,as shown above,and are asked to draw the relationship between them.If a given customer can place only one order and a given order can be placed by at most one customer,which of the following should be indicated in the relationship symbol between the two entities?

(Multiple Choice)
4.9/5
(40)
For a relationship to be considered a binary relationship it must satisfy which of the following conditions?
(Multiple Choice)
4.7/5
(40)
An attribute that determines which subtype is appropriate is called a discriminator.
(True/False)
4.9/5
(35)
Entities containing optional sets of attributes are often represented using subtypes.
(True/False)
4.8/5
(31)
All weak entities must have a minimum cardinality of 1 on the entity on which it depends.
(True/False)
4.9/5
(38)
To represent an association pattern in an E-R model,________.
(Multiple Choice)
5.0/5
(39)
A weak entity is an entity that cannot exist in the database without (and is logically dependent upon)another type of entity also existing in the database.
(True/False)
5.0/5
(36)
To represent a multivalued attribute in an E-R model,________.
(Multiple Choice)
4.9/5
(32)
The principle difference between an entity and a table is that you can express a relationship between entities without using foreign keys.
(True/False)
4.8/5
(38)
One example of a database design using an ID-dependent relationship is the association pattern.
(True/False)
4.7/5
(44)
The degree of a relationship is expressed as the relationship's maximum cardinality.
(True/False)
4.9/5
(38)
One example of a database design using an ID-dependent relationship is the archetype/instance pattern.
(True/False)
4.9/5
(35)
Showing 21 - 40 of 100
Filters
- Essay(10)
- Multiple Choice(32)
- Short Answer(0)
- True False(58)
- Matching(0)