Consider the table ACCOUNTS (AccountNo, Name, TimeStamp, Balance,
Address), with the following functional dependencies:
(primary key of this table is [AccountNo, TimeStamp] )
AccountNo -> Name, Address
(AccountNo, TimeStamp) -> Balance
What is the HIGHEST normal mform that this table, ACCOUNTS, is now in?
A -
BCNF
B -
None of the others answers
C -
2NF
D -
3NF
2-
In Data Flow Diagram, SOURCE
A -
represents a table within a database. It cannot transform data, and usually contains one inflow and one outflow. A store should be named with a noun that reflects its purpose.
B -
indicates a flow of data(but not physical objects, such as a book). It should connect at each end directly to its source and destination with one arrowhead, and should not cross other arrows.
C -
provides the inflow to a process. It should be named as a person, place or thing. A source can only be connected a process.
D -
transforms data, and must have at least one inflow and one outflow. It should be named with an active verb followed by a noun that reflects what transformation the process is making to the data passing through it A process.
3-
If each employee can have more than one skill, then skill is referred to as a:
A -
repeating attribute
B -
multivalued attribute
C -
gerund
D -
nonexclusive attribute
4-
In Data Flow Diagram, STORE
A -
indicates a flow of data(but not physical objects, such as a book). It should connect at each end directly to its source and destination with one arrowhead, and should not cross other arrows.
B -
transforms data, and must have at least one inflow and one outflow. It should be named with an active verb followed by a noun that reflects what transformation the process is making to the data passing through.
C -
provides the inflow to a process. It should be named as a person, place or thing. A source can only be connected a process.
D -
represents a table within a database. It cannot transform data, and usually contains one inflow and one outflow. A store should be named with a noun that reflects its purpose.
5-
In picture, (i) is:
A -
Extend
B -
Include
C -
Communicate
D -
Generalization
6-
In picture, (ii) is:
A -
Generalization
B -
Include
C -
Extend
D -
CommunicateCâu
7-
In picture, (iv) is:
A -
Communicate
B -
Include
C -
Generalization
D -
Extend
8-
In sequence diagram, this is:
A -
Iterations
B -
Recursion
C -
Assignments
D -
Conditional Message
9-
In sequence diagram, this is:
A -
Recursion
B -
Assignments
C -
Codition
D -
None of these answers
10-
In terms of generalization hierarchies, the characteristic of "inheritance" means
that:
A -
the attributes of an instance of the supertype include the attributes of the subtype
B -
an instance of the supertype must belong to one of the subtypes
C -
there is a redundant relationship among instances of the subtype
D -
the attributes of an instance of the subtype include the attributes of the supertype
