Context diagram contains one process node that generalizes the functiob of the entire system in relationship to external entities.
B -
Context diagram havent process node that generalizes the function to the entire system in relationship to external entities.
C -
Context diagram contains two process node that generalizes the function of the entire system in relationship to external enties.
D -
Context diagram contains many process node that generalizes the function of the entire system in relationship to external entities.
2-
Select the right option(s):
A -
Normalization is the process of efficiently organizing in a database.
B -
The notion of database normalization was developed reduce data redundancy as much as possible.
C -
All of these answers.
D -
There are two goals of the normalization process: eliminating redundant data (for example, storing the same data in more than one table) and ensuring data dependencies make sense?(only storing related data in a table).
3-
Select the true statement:
A -
External entities represent people or organizations outside of the system being studied.
B -
External entities shows the initial source and final recipient of data and information.
C -
External entities should be named with a noun, describing that entity.
D -
All of these answers.
4-
Suppose you have a table with fields CAR_ID, CAR_NAME,
STICKER_PRICE, QUOTE_PRICE and DEALER, and that the following functional
dependencies exist:
CAR_ID -> CAR_NAME
CAR_ID -> STICKER_PRICE
CAR_ID -> DEALER
DEALER -> QUOTE_PRICE
Which attribute(s) may be key attributes for a 3NF table?
A -
CAR_ID and DEALER
B -
CAR_ID
C -
CAR_NAME, STICKER_PRICE, and DEALER
D -
None of the others answers
5-
Suppose you have a table with fields A, B, C and D. The functional
dependencies in the table are as follows:
A,B -> C
A,B -> D
D -> C
A -
BCNF
B -
3 NF
C -
2 NF
D -
1 NF
6-
Suppose you have a table with fields A, B, C and D. The functional
dependencies in the table are as follows:
A -> B,C,D
C -> A,B,D
B -> A
What is the highest normal form this table can be in?
A -
BCNF
B -
3 NF
C -
1 NF
D -
2 NF
7-
Suppose you have a table with fields A, B, C and D. The functional
dependencies in the table are as follows:
B,C -> A,D
C -> D
What is the highest normal form this table can be in?
A -
1 NF
B -
3 NF
C -
2 NF
D -
BCNF
8-
The conservation of inputs and outputs and outputs to a data flow diagram
process when that process is decomposed to a lower level defines:
A -
Decomposition
B -
Conservation
C -
Data flow structuring
D -
Balancing
9-
The DFD Figure Bookstores Text book Inventory System is known as a ____.
A -
Context level DFD
B -
ERD
C -
Bottom level DFD
D -
Level 1 DFD
10-
The field used to id records in a database table is known as the: