logo image

INF2603 Ch7 – Data Modeling with ERD – True/False

An ERM is dependent on the database type.
False
The word “entity” in the ER model corresponds to a table.
True
The Crow’s Foot model is less implementation-oriented than the Chen model.
False
The ER diagram represents the conceptual database as viewed by the end user.
True
The ER model refers to a specific table row as an entity instance.
True
In both the Chen and Crow’s Foot models, an entity is represented with a rectangle containing the entity’s name.
True
The ER model refers to a specific table row as an entity occurrence.
True
Attributes are types of entities.
False
In the original Chen model, each attribute is represented using an oval with the attribute name connected to the entity with a line.
True
Software vendors have adopted the Chen representation because of its compact representation.
False
Attributes have a domain that specifies the data type of the attribute.
False
Attributes cannot share a domain.
False
In an ER diagram, primary keys are usually bolded.
False
Ideally, a primary key is composed of several attributes.
False
A composite identifier is a primary key composed of more than one attribute.
True
All attributes are either simple or composite.
True
All simple attributes are also single-valued.
False
In the Chen model, a multivalued attribute is connected to the owning entity with a double line.
True
The DBMS can easily handle multivalued attributes.
False
Derived attributes are stored in a special database table.
False
A relationship is identified by a name that describes the relationship.
True
Cardinality expresses the minimum and maximum number of entity occurrences associated with one occurrence of the related entity.
True
In Chen notation, there is no way to represent cardinality.
False
Connectivities and cardinalities are established by business rules.
True
A weak relationship exists if the primary key of the related entity contains at least one primary key component of the parent entity.
False
You should always load data from the 1 side of a 1:M relationship.
True
A weak entity has a primary key that is partially or totally derived from the parent entity in the relationship.
True
The existence of a mandatory relationship indicates that the minimum cardinality is 0 or 1 for the mandatory entity.
False
Relationships operate only in one direction.
False
A recursive relationship is one in which a relationship can exist between occurrences of the same entity set.
True

Need essay sample on "INF2603 Ch7 – Data Modeling with ERD – True/False"? We will write a custom essay sample specifically for you for only .90/page

Can’t wait to take that assignment burden offyour shoulders?

Let us know what it is and we will show you how it can be done!
×
Sorry, but copying text is forbidden on this website. If you need this or any other sample, please register
Signup & Access Essays

Already on Businessays? Login here

No, thanks. I prefer suffering on my own
Sorry, but copying text is forbidden on this website. If you need this or any other sample register now and get a free access to all papers, carefully proofread and edited by our experts.
Sign in / Sign up
No, thanks. I prefer suffering on my own
Not quite the topic you need?
We would be happy to write it
Join and witness the magic
Service Open At All Times
|
Complete Buyer Protection
|
Plagiarism-Free Writing

Emily from Businessays

Hi there, would you like to get such a paper? How about receiving a customized one? Check it out https://goo.gl/chNgQy