The notion of database normalization was developed to
A -
reduce data intefrity.
B -
increase data integrity.
C -
increase data redundancy.
D -
reduce data redundancy.
2-
The notion of database ____ was developed to reduce data redundancy.
A -
schema
B -
key
C -
normalization
D -
redundancy check
3-
The relationship between two entity types A and B is 1:1, and the relationship is
optional at the A end. Only 50% of B entities are related to an A entity. Now consider
mapping these entity types into relations. Select the best statement from the following
list:
A -
A and B should kept separate with the foreign key in the A relation.
B -
A and B should kept separate with the foreign key in the A and B.
C -
A and B should kept separate with the foreign key in the B relation.
D -
B should be subsumed by A
4-
This is:
A -
DFD level 0 (I)
B -
Context diagram (II)
C -
DFD level 1
D -
(I) and (II)
5-
Use a Data Flow Diagram (DFD) to:
A -
show the relationships among the business process within an organization to external systems
B -
show the relationships among the business process within an organization to external organizations
C -
show the relationships among the business process within an organization to customers
D -
All of these answers
6-
What are Data Flow Diagram?
A -
Data flow diagrams illustrate how data is processed by a system in term of inputs and outputs.
B -
Data flow diagrams illustrate how data is processed by a system in term of inputs.
C -
Data flow diagrams illustrate how data is processed by a system in term of outputs.
D -
None of these answers.
7-
Which of the following is not basic rule of normalization?
A -
specify a unique field in each table to act as the primary key.
B -
prevent values in a table from being relational.
C -
minimize redundant data in individual tables.
D -
create a separate entity table for each set of related data.
8-
Which of the following is correct about referential integrity?
A -
(I) and (III) are true
B -
(II) ensures tables are up to date
C -
(I) show how tables are related to each other
D -
(III) prevents data tables from having orphans
9-
Which of the following is not correct with regards to creating tables?
A -
The 1st Normal form requires that only flat (rectangular) files exist.
B -
A primary key can be made from more than one attribute
C -
All fields in a table need to depend upson (are identified by) the primary key or the foreign key.
D -
One rule of designing tables gor a database is to store the smallest meaningful value in a field.
10-
Which of the following is not a function of the requirements phase of building a
database system?