Please answer the question in sequential order.

QUESTION 1

1. The __________ rule of GUI design states users like to explore an interface and often learn effectively by trial and error. Therefore, user interface accommodates user exploration and mistakes without pain

	1.	Feedback
	2.	User control
	3.	Forgiveness
	4.	Tolerance

QUESTION 2

1. Which of the following is a benefit of the distributed computing architecture over the centralized computing architecture?

	1.	No single point of failure
	2.	Better performance
	3.	Less complexity
	4.	1) and 2)
	5.	1), 2) and 3)

QUESTION 3

1. Which of the following is NOT true about ER model?

	1.	It was developed by Peter Chen
	2.	It is one of the best approaches to data modeling
	3.	It is one of the major deliverables from the system analysis phase
	4.	Its two components are "Process" and "Data"

QUESTION 4

1. Today's most popular database management systems are based on the ____________.

	1.	Object model
	2.	Hierarchical model
	3.	Relational model
	4.	Network model

QUESTION 5

1. Which of the following provides an example of entity in a clinical system?

	1.	Height
	2.	Pulse
	3.	Patient
	4.	Test date

QUESTION 6

1. The UID (Unique Identifier) in the ER Model is equivalent to ___________ in the Relational Model.

	1.	Foreign key
	2.	Master key
	3.	Relation
	4.	Primary key

1. Which data integrity constraint did the following table violate? EMPLOYEE

PK: EmpID FK: Spervisor (refers to EmpID)

EmpID	EName	City	Supervisor
111
222	Lee	LR	333
333	Tom	LR
333	Mary	Conway
555	John	Pine Bluff	333
666	June	Conway

	1.	Entity integrity constraint
	2.	Key constraint
	3.	Referential integrity constraint
	4.	None

QUESTION 8

1. What is the purpose of relational modeling?

	1.	To define data objects and document business rules
	2.	To specify the right structure of database
	3.	To define data types for the attributes used in the database
	4.	All of the above
	5.	None of the above

QUESTION 9

1. What's the degree of the following business rule?

"An employee may (or may not) is assigned to more than one project. Each project is assigned many employees."

	1.	One-to-many
	2.	Many-to-Many
	3.	Optional
	4.	Binary

QUESTION 10

1. One of the most popular tools for designing UI dialogue sequence is __________.

	1.	Sequence diagram
	2.	ER model
	3.	Dialogue diagram
	4.	Unified modeling language

QUESTION 11

1. What is the degree of the following table?
3. EMPLOYEE (EmpID: PK)

EmpID	EName	City	Supervisor	DeptNo
111
222	Lee	LR	333	1
333	Tom	LR		1
444	Mary	Conway		2
555	John	Pine Bluff	111	1
666	June	Conway		3

	1.	Five (5)
	2.	Six (6)
	3.	Seven (7)
	4.	Thirty (30)

QUESTION 12

1. What is the goal of ER modeling?

	1.	To define the information contents to be included in the database
	2.	To specify the structure of database
	3.	To define data types for attributes used in the database
	4.	All of the above
	5.	None of the above

QUESTION 13

1. Which of the following is NOT true about "RELATION" in the relational model?

	1.	A relation takes a form of table with rows and columns
	2.	A relation is the single data structure of the relational model.
	3.	A relation can be one-to-one, one-to-many, or many-to-many.
	4.	Users can view data only through (a) relation(s)

QUESTION 14

1. In the ER model, a (an) _____________ documents business rules.

	1.	Constraint
	2.	Entity
	3.	Attribute
	4.	Relationship

QUESTION 15

1. Which data integrity constraint did the two tables violate?

EMPLOYEE

(EmpID: PK, DeptID:FK)

EmpID	EName	City	Supervisor	DeptNo
111
222	Lee	LR	333	1
333	Tom	LR		1
444	Mary	Conway		2
555	John	Pine Bluff	111	1
666	June	Conway		3

DEPARTMENT (DeptNo: PK, ManagerID: FK)

DeptNo	DName	Budget	Location	ManagerID
1	MIS	2000000	LR	333
2	ACCT	1000000	LR
3	HR	1500000	Conway	666

	1.	Entity integrity cosntraint
	2.	Key constraint
	3.	Referential integrity constraint
	4.	None

QUESTION 16

1. What's the cardinality of the following business rule? " An employee may be married to another employee"

	1.	One-to-One
	2.	Optional
	3.	Unary
	4.	Binary

QUESTION 17

1. In the 3-tier client/server computing, an application server manages ______________.

	1.	Data management
	2.	User interface
	3.	Business logic
	4.	Data storage

QUESTION 18

1. Which of the following is true about Process Specification?

	1.	All processes in a DFD require process specifications
	2.	Only the processes on Level 0 DFD require process specifications
	3.	Only the processes on Context DFD requires process specifications
	4.	Only the primitive processes of DFDs require process specifications

QUESTION 19

1. The computing architecture in which all computing tasks are performed by one computer best defines

	1.	Distributed computing
	2.	Centralized computing
	3.	Two-tier client server computing
	4.	Three-tier client server computing

QUESTION 20

1. What is an input to system design?

	1.	ER model
	2.	Data flow diagram
	3.	Process specification
	4.	All of the above
	5.	None of the above

QUESTION 21

1. Each of the following provides an example of attribute in the ER model EXCEPT:

	1.	Customer name
	2.	Student GPA
	3.	Video Rental
	4.	Product price

QUESTION 22

1. A degree in an ER model is the number of __________.

	1.	Entities participating in a relationship
	2.	Attributes
	3.	Relationships (e.g., one to many)
	4.	Business rules involved QUESTION 23

1. Which of the following is true about Structured English?

	1.	It is used only for the decision making structure
	2.	It uses a set of English key words to specify the process logic
	3.	It is a matrix representation of the logic which specifies the possible conditions and the resulting actions
	4.	It is a graphical representation of process logic (e.g., conditions and actions) that uses lines organized like branches of a tree QUESTION 24

1. If a process logic includes multiple branching, _________ is the most effective process specification technique.

	1.	Decision tree
	2.	Decision table
	3.	Structure English
	4.	DFD

QUESTION 25

1. An entity in the ER Model is equivalent to a (an) _____________ in the data flow diagram.

	1.	Data flow
	2.	Process
	3.	Data store
	4.	External entity

QUESTION 26

1. What is the input to the relational modeling?

	1.	Tables
	2.	Relational model
	3.	Entity-relationship model
	4.	Data flow diagram

QUESTION 27

1. If there are hundreds of clients and three database servers involved, then this is an example of _____________ client/server computing?

	1.	Two-tier
	2.	Three-tier
	3.	n-Tier
	4.	Dynamic

QUESTION 28

1. A relationship in an ER model is mapped to a ___________ in a relational model.

	1.	PK
	2.	FK
	3.	Column
	4.	Row

QUESTION 29

1. Trends in UI design includes __________.

	1.	Use of multi-media
	2.	Object-orientation
	3.	Event-driven control
	4.	All of the above

QUESTION 30

1. In GUI (Graphical User Interface) design, the principle of __________ means that appearance of any control should suggest its functionality intuitively and naturally so that users don't have to stop and figure out how to use it.

	1.	Forgiveness
	2.	Visibility
	3.	Directness
	4.	Consistency

QUESTION 31

1. Which of the three computing tasks handles the job of "Validating input data"?

	1.	User Interface
	2.	Business logic
	3.	Data management
	4.	Data Insert

QUESTION 32

In the three-tier client/server computing architecture, where are the application (business) logics placed?

	1.	Database server
	2.	Application server
	3.	Web browser
	4.	Web server

QUESTION 33

Of the three computing tasks we discussed in the application computing architecture, which of the following handles the presentation of input and output to human beings?

	1.	User interface
	2.	API (application program interface)
	3.	Application logic
	4.	Data management

QUESTION 34

Which of the following is true about UI design?

	1.	"Ease of learning" and "Ease of use" features may be conflicting
	2.	Users may evaluate the quality of the system solely based on UI because UI can be the system itself to them
	3.	UI includes input design, out design and navigation (dialogue) design
	4.	All of the above
	5.	None of the above

QUESTION 35

1. In UI design, __________ is important because it allows users to predict what is going to happen.

	1.	Directness
	2.	User control
	3.	Forgiveness
	4.	Feedback
	5.	Consistency