Consider the following relation definition and sample data in picture. Assume
that all of the functional dependencies and constraints are apparent in this data.
Which of the following statements is NOT true?
A -
(TaskID.Phone->(TotalHours, ProjectID)
B -
EmployeeName->ProjectID
C -
(EmployeeName.ProjectID)->TaskID
D -
EmployeeName->TotalHours
2-
Consider the following relation definition and sample data in picture. Assume
that all of the functional dependencies and constraints are apparent in this data.
The set of candidate keys in this table are:
Consider the table VEHICLES.(RegistrationNO, Owner, Model, Manufacturer,
NoCylinder) have primary key is RegistrationNo, with the following functional
dependencies:
RegistrationNo -> Owner, Model, Manufacturer
(Model, Manufacturer) -> NoCylinder
RegistrationNo -> NoCylinder
What is the HIGHEST normal form that this table, VEHICLES, is now in?
A -
3NF
B -
2NF
C -
BCNF
D -
1NF
4-
Data contained on a customer order form would be represented on a data flow
diagram as a:
A -
data flow
B -
source
C -
sink
D -
relationship
5-
Data stores name should be a:
A -
verb
B -
noun
C -
adjective
D -
adverb
6-
Designers generally start with lists and then move to sketches of the tables and
the relationships among them, called data-structure or ____ diagrams.
A -
SE
B -
Codd
C -
R-E
D -
Primary-key
7-
DFDs are categorized as either:
A -
logical(I)
B -
physical(II)
C -
(I) and (II)
D -
None of these answers
8-
Entity integrity is when:
A -
Referential integrity has been upheld
B -
Primary key values are unique
C -
Entity relationship diagram is correct
D -
There are no composite primary keys
9-
External entities may be:
A -
A person
B -
A company or organization
C -
Another system or subsystem
D -
All of these answers
10-
External Entity is:
A -
a holding place for information within the system
B -
a source or destination of a data flow which is outside the area of study
C -
represented by a line, with arrowheads showing the direction of flow
