|
1-
|
Advantages of logical DFDs is/are:
|
|
|
A -
|
Better communication with users
|
|
|
B -
|
More stable systems, since the design is based on a business framework
|
|
|
C -
|
Increased understanding of the business by analysts
|
|
|
D -
|
All of these answers
|
|
2-
|
Advantages of logical DFDs:
|
|
|
A -
|
Better communication with users. More stable systems
|
|
|
B -
|
Better understanding of the business by analysts. Flexibility and maintenance
|
|
|
C -
|
Elimination of redundancies and easier creation of the physical model
|
|
|
D -
|
All of these answers
|
|
3-
|
An entity type whose existence depends on another entity type is called a(n)
____ entity.
|
|
|
A -
|
Weak
|
|
|
B -
|
Strong
|
|
|
C -
|
Co dependent
|
|
|
D -
|
Variant
|
|
4-
|
An entity that associates the instances of one or more entity types and contains
attributes specific to the relationships is called a (n)
|
|
|
A -
|
Intersectional entity
|
|
|
B -
|
All of the others answers
|
|
|
C -
|
Associative entity
|
|
|
D -
|
Connecting entity
|
|
5-
|
An Context Flow Diagram we have
|
|
|
A -
|
None of the other answers
|
|
|
B -
|
Many entities and many processes
|
|
|
C -
|
One process and more entities
|
|
|
D -
|
One entity and more processes
|
|
6-
|
Based on the Entity-Relationship model given below, which of the following is
true?
|
|
|
A -
|
enroll:CLASS ::1:0
|
|
|
B -
|
CLASS is optional in the STUDENT-CLASS relationship
|
|
|
C -
|
CLASS:TEACHER::1:M
|
|
|
D -
|
STUDENT:CLASS::1:0
|
|
7-
|
Based on the Entity-Relationship model given above, which of the following is
false?
|
|
|
A -
|
During the step in translating this E-R model to a set of relational tables, it is necessary to create a table corresponding to the entity "CLASS"
|
|
|
B -
|
During the step in translating this E-R model to a set of relational tables, it is necessary to create a table corresponding to the entity "STUDENT"
|
|
|
C -
|
During the step in translating this E-R model to a set of relational tables, it is necessary to create a table corresponding to the entity "TaughtBy"
|
|
|
D -
|
During the step in translating this E-R model to a set of relational tables, it is necessary to create a table corresponding to the entity "enroll"
|
|
8-
|
Based on the ER-diagram, which of the following are true?
|
|
|
A -
|
(II) There can be multiple videos of the same movie
|
|
|
B -
|
(III) There can be blank videos(i.e..video without movies)
|
|
|
C -
|
(I) and (II) are true
|
|
|
D -
|
(I) One customer can rent multiple videos.
|
|
9-
|
Breaking down the functions of a business into progressively finer detail is
called
|
|
|
A -
|
Function decornposition
|
|
|
B -
|
Business functional explosion
|
|
|
C -
|
All of the others answers
|
|
|
D -
|
Business detailing
|
|
10-
|
Components of Data Flow Diagrams:
|
|
|
A -
|
External entities, Process Flows, Datastores, Stores
|
|
|
B -
|
External entities, Process Flows, Datastores
|
|
|
C -
|
External entities, Process Flows, Stores
|
|
|
D -
|
None of these answers
|
