a logical representation of the structure of the database
D -
All of these answers
2-
A DBMS is a good tool for all of the following reasons except
A -
Enforces data and procedural standards
B -
Improves data security and integrity
C -
Reduces data redundancy
D -
Ensures data independence
3-
A decision table is:
A -
divided into four parts, condition stub, action stub, condition entry, and action entry(II)
B -
a table with various conditions and their corresponding action (I)
C -
a two dimensional matrix
D -
(I) & (II)
4-
A library includes books and borrower.
At any time a book may be borrowed by a single borrower.
A record is kept of the current location of each book and its borrowing history.
Select the ER diagram which best represents this scheme.
A -
e
B -
d
C -
a
D -
b
5-
A person, place, object, event, or concept in the user environment about which
the organization wishes to maintain data refers to a(n):
A -
entity
B -
relationship
C -
data element
D -
process
6-
A persons name, birthday, and social security number are all examples of
A -
Descriptors
B -
Entities
C -
Relationships
D -
Attributes
7-
A relation is not allowed to have
A -
Two columns with the same values
B -
None of the others answers
C -
Two columns with the same domain
D -
Two columns with the same names
8-
A system flowchart is primarily useful in analyzing and designing transaction
processing systems because it:
A -
show relationships among the document, procedures and files
B -
shows the detailed processing steps
C -
supersedes the other documentation of the system
D -
shows decisions affecting the systems
9-
A type of documentation that contains the definition and the characteristics of
the data elements within a data base is known as a:
A -
entity-relationship model
B -
data model
C -
data dictionary
D -
data flow diagram
10-
ACME places orders with their suppliers using the following purchase order
form. A buyer (an employee in the company) will fill the order form to order one or more
items from a supplier. Each such order us placed with a single supplier and can be for one
or more items. Based on the information, an E-R diagram is draw below to represent the connectivity,
cardinality, and optionality of the relationships. (Note: In the ERD below, "order-line"
represents each line of item in the order form.)
If you want to map the above ER Diagram into tables, how many tables do you need?