Problem 6

In order to predict the local demand for IT graduates a marketing agency has conducted a simple survey within young IT companies based on the form questionnaire presented below.

Provide an adequate sub-type structure for the data collected from the survey.

Question	The Next Question
1) Year you company has been established Brfore 1995 1995-2000 2001-2005 2006-	2 2 3 3
Do you operate your own IT department ? YES NO	Thank you for your time 6
Do you plan to hire a new IT staff this year? a. YES b. NO	4 5
What type of specialists do you plan to hire? Software Engs DB experts, DBAs Security experts Java Programmers Other	Thank you for your time 6 Thank you for your time Thank you for your time Thank you for your time
What is the size of your current IT department? less than 5 people between 5 -10 people more than 10 people	Thank you for your time Thank you for your time 7
What database system you deployed in your company (even if you outsource the IT services)? Oracle Sybase Informix Ms SQL server Other, specify ……………………….	Thank you for your time
When do you plan to hire new staff? next yeat I don't know	Thank you for your time

Problem 7

a) Surveying become a popular way of gathering information about a large population to identify needs, trends, behaviour and other properties and to use that information to help in a decision making process.

In the case where the respondents are not required to answer all questions in the survey questionnaire, there could be a need to provide efficient storage of data collected in the survey, which can be achieved by subtyping the responses.

Provide only the object-role matrix for the following (generic) questionnaire (the semantics of questions is ignored). Subtype graph is not required.

Assume that each question pertains to a fact type.

Q1	a)		3		Q7	a)		11
	b)		3				b)		11
	c)		2				c)		T
	d)		2				d)		T
Q2	a)		5			Q8	a)		9
	b)		8				b)		11ab
	c)		5				c)		11ab
	d)		8			Q9	a)		12
Q3	a)		4				b)		12
	b)		10				c)		12
	c)		4				d)		12
Q4	a)		6			Q10	a)		12
	b)		6				b)		12
	c)		7cd				c)		12
	d)		6				d)		12
Q5	a)		7			Q11	a)		T
	b)		7				b)		T
	c)		7				c)		12
	d)		7				d)		12
Q6	a)		10			Q12	a)		T
	b)		10				b)		T
	c)		7				c)		T
	d)		10				d)		T
	e)		T

Notes and explanations. Each respondent starts from providing (ticking) an answer to question 1. Only one answer could be selected for each question. The number of the next question, a respondent is directed to, is in the line of his/her last answer. 'T' means that the respondent is thanked and not required to answer more questions. '7cd' as the direction from answer 4c means that the respondent answering as the next question 7 will pick either answer 7c) or 7d).

The navigation graph is as follows

Paths :

1 2, 1 2 6, 1 3 5, 1 3 5 7, 1 3 4, 1 3 4 6

7

6

5

3

4

2

1

B~>A, C~>A, D~>C, E~>C, F~>A, G~>E

G

F

B

C

D

E

A

The metrix of patterns:

The following are the subsets relationships:

G

F

E

D

C

B

A

x

x

x

x

x

x

x

x

x

x

x

x

x

x

x

x

x

x

x

7

6

5

4

3

2

1

12

ab

11ab

cd

7cd

9

11

10

4

6

7

5

8

3

2

1

1,2,8,9,12

1,2,8,11,12,

1,2,8,11,

1,2,5,7

1,2,5,7,11,12,

1,2,5,7,11

1,3,4,7

1,3,4,6,7,

1,3,4,6,7,11,12,

1,3,4,6,7,11

1,3,4,6,10,12,

1,3,10,12

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

x

X

X

X

X

X

X

X

X

X

X

X

X

X

x

x

X

X

X

X

X

X

X

X

x

X

X

X

12

11

10

9

8

7

6

5

4

3

2

1

---