Problem 6

(1)

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 a. Brfore 1995

b. 1995-2000 c. 2001-2005 d. 2006-

2 2 3 3 2) Do you operate your own IT department ?

a. YES b. NO

Thank you for your time 6

3) Do you plan to hire a new IT staff this year?

a. YES b. NO

4 5 4) What type of specialists do you plan to hire?

a. Software Engs b. DB experts, DBAs c. Security experts d. Java Programmers e. Other

Thank you for your time 6

Thank you for your time Thank you for your time Thank you for your time 5) What is the size of your current IT department?

a. less than 5 people b. between 5 –10 people c. more than 10 people

Thank you for your time Thank you for your time 7

6) What database system you deployed in your company (even if you outsource the IT services)?

a. Oracle b. Sybase c. Informix d. Ms SQL server

e. Other, specify ……….

Thank you for your time

7) When do you plan to hire new staff?

a. next yeat b. I don’t know

Thank you for your time

(2)

1

2

4

3 5

6

7

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

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

A

E D

C

B F

G

1 2 3 4 5 6 7

x x

x x x

x x x x

x x x

x x x x

A B C D E F G

The metrix of patterns:

The following are the subsets relationships:

(3)

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).

(4)

1 2 3 4 5 6 7 8 9 10 11 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

1 2 3

8

5

7

6

4

10

11

9 7cd

cd

11ab

ab

12 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