UML notations that can be used to model the hardware and software elements
of a system are
A -
Activity diagrams
B -
Class diagrams
C -
Deployment diagrams
D -
All of these answers
2-
Use Case Model provides:
A -
None of these answers
B -
blacks-box
C -
Outside-in view of system functionality
D -
All of these answers
3-
Use Case Model consists of:
A -
Actors
B -
Use Cases
C -
Relationships
D -
All of these answers
4-
Using relational notation, an attribute of relation that is the primary key of
another relation is indicated by:
A -
italics
B -
a dashed underline
C -
an underline
D -
a circle
5-
When changing the minimum cardinality on the parent side of the relationship
from zero to one, the foreign key ____.
A -
must be changed to a composite key
B -
must changed to a surrogate key
C -
must be changed from NOT NULL to NULL
D -
must be changed from NULL to NOT NULL
6-
When dropping a primary key column from a table, which of the following step
are NOT include in the process [the order of the steps listed below is not relevant, only
the steps themselves]?
A -
drop the foreign keys in other tables based on the primary key column
B -
drop the primary key constraint from the table
C -
drop the doreign key column from the table
D -
drop the primary key column from the table
7-
When designing the tables from an E-R diagram, the ____ becomes the table
name
A -
Entity, Entity class
B -
None of these answers
C -
Attribute
D -
Relationship
8-
When transforming an Extended E-R model into a relational database design
and creating a table for a weak entity that is not ID-dependent, ____.
A -
a composite primary key must be created for that dependent
B -
a composite primary key must be created for the weak entity
C -
deletions and updates must cascade drom the parent the child
D -
the primary key of the strong entity must be placed as part of the primary key in the weak entity
9-
When transforming an E-R diagram into normalized relations, the identifier of
the entity type becomes:
A -
a secondary key in the corresponding relation
B -
the foreign key in the corresponding relation
C -
a nonkey attribute in the corresponding relation
D -
the primary key of the corresponding relation
10-
Which of following is not a UML diagram used creating a system nalaysis
model?
