Question 1 (1 point)

What is the first thing you do in the systems development life cycle?

Question 1 options:

	A) Planning
	B) Analysis
	C) Design
	D) Coding

Question 2 (1 point)

What is the most important step in the systems development life cycle?

Question 2 options:

	A) Planning
	B) Analysis
	C) Design
	D) Coding

Question 3 (1 point)

What do you use to describe your conceptual understanding of an organization's data?

Question 3 options:

	A) An ER diagram
	B) A relational data model
	C) A data flow diagram
	D) A systems development life cycle

Question 4 (1 point)

What is the purpose of a foreign key?

Question 4 options:

	A) As documentation for the analyst
	B) To implement the ER relationships in a relational data model
	C) As a multi-valued attribute
	D) To link primary keys together

Question 5 (1 point)

How many primary keys can a relation have?

Question 5 options:

	A) 1
	B) 2
	C) 3
	D) 4

Question 6 (1 point)

In Excel, what is the result of =concatenate(A,

Question 6 options:

	A) AB
	B) A B
	C) A,B
	D) AA

Question 7 (1 point)

What is a possible result of the Excel function =Randbetween(1,10) ?

Question 7 options:

	A) 0
	B) 1
	C) 100
	D) 1000

Question 8 (1 point)

What do you use to create a conceptual model of a business process?

Question 8 options:

	A) ER daigram
	B) Data flow diagram
	C) Data description diagram
	D) process flow entity diagram

Question 9 (1 point)

What is the relationship between Customers and Orders?

Question 9 options:

	A) one to one
	B) one to many
	C) many to many
	D) something else

Question 10 (1 point)

How do we get data from Excel into Access?

Question 10 options:

	A) Type it in by hand
	B) Export from Excel
	C) Import from Excel
	D) Export from Access

Question 11 (1 point)

Somewhere along the line I accidentally deleted my customer table. What can I do?

Question 11 options:

	A) Undo the delete
	B) Nothing. It's gone. You have to re-create it.
	C) You can copy it from the items table
	D) Just copy and paste from the excel spreadsheet