|
1-
|
Which is/are derived sttribute(s):
|
|
|
A -
|
Name.
|
|
|
B -
|
All of these answers.
|
|
|
C -
|
Interest.
|
|
|
D -
|
Social number.
|
|
2-
|
Which of the following is not correct?
|
|
|
A -
|
Entity Relationship Diagrams use four items; rectangles, circles, lines, degree of relation (such as one to many).
|
|
|
B -
|
Entity Relationship Diagrams show entities, how the entities interact and the attributes.
|
|
|
C -
|
Entity Relationship Diagrams are a graphical approach to modeling that helps the user design systems.
|
|
|
D -
|
In transforming Entity Relationship Diagrams to a database, entities become tables.
|
|
3-
|
Which of the following is not true regarding decision tables?
|
|
|
A -
|
Structured English is more useful than decision tables when modeling the complicated logic of a process.
|
|
|
B -
|
Decision tables can model the relatively complicated logic of a process.
|
|
|
C -
|
Decision tables allow you to check for the extent to which your logic is complete, consistent, and not redundant.
|
|
|
D -
|
Decision tables are compact.
|
|
4-
|
Which of the following is not correct with regards to creating tables?
|
|
|
A -
|
A primary key can be made from more than one attribute
|
|
|
B -
|
All fields in a table need to depend upon (are identified by) the primary key or the foreign key.
|
|
|
C -
|
The 1st Normal form requires that only flat (rectangular) files exist.
|
|
|
D -
|
One rule of designing tables for a database is to store the smallest meaningful value in a field.
|
|
5-
|
Which following are the different phases of software development?
|
|
|
A -
|
System study
Feasibility study
System analysis.
|
|
|
B -
|
System design
Coding
Testing.
|
|
|
C -
|
Implementation
Maintenance.
|
|
|
D -
|
All of these answers.
|
|
6-
|
Which of the following processes can Structured English represent?
|
|
|
A -
|
repetition.
|
|
|
B -
|
conditional statements.
|
|
|
C -
|
sequence.
|
|
|
D -
|
All of the others answers.
|
|
7-
|
With of the following is not true with regards to logical data diagrams?
|
|
|
A -
|
a logical DFD will remain relative constant over time relative to its physical nature.
|
|
|
B -
|
they document the physical structure of an existing system or proposed system.
|
|
|
C -
|
they document the processes in an existing or proposed system.
|
|
|
D -
|
Logical Data flow diagrams typically have lower levels (below the level-0 diagram) to show details about the processes.
|
|
8-
|
A Computer file or database, a transaction file, a set of tables, a manual file of
records are examples about:
|
|
|
A -
|
data stores
|
|
|
B -
|
data
|
|
|
C -
|
entity
|
|
|
D -
|
process
|
|
9-
|
A conceptual schema is:
|
|
|
A -
|
a complete logical view of the database
|
|
|
B -
|
not a complete logical view of the database
|
|
|
C -
|
a complete physical view of the database
|
|
|
D -
|
None of these answer
|
|
10-
|
A context diagram is a:
|
|
|
A -
|
top level (I)
|
|
|
B -
|
level 0 (II)
|
|
|
C -
|
level 1
|
|
|
D -
|
(I) and (II)
|
