(1 mark) Questions:

1. Describe process modeling and data modeling in the analysis phase respectively.

2. Give another example of weak entity as well as its owner entity.

3. Give another example of associative entity. Explain why it should be considered as an

associative entity rather than a relationship.

4. Give another example of specialization/generalization with the constraints

(mandatory,or). Draw the ER diagram for it.

5. Write an SQL statement to select the rooms booked by some guests from Mars.

6. Write an SQL statement to find out the guest who has booked at least two rooms in the

same hotel.

You should put your answers to these questions.

Page 3

(2 marks) Practices:

I. (1 mark) SAD system proposal. Combine all work done in the planning

analysis phase so far. Create a system proposal for the MICT course planning

system. The system proposal should include, but not limited to:

a) Summary

b) System request

c) Work plan formalized in Gantt chart

d) Feasibility analysis

e) Requirements definition

f) Use cases at least 3 from different roles of users

g) Process model at least 3 level 0 processes from different roles

of users.

h) Data model to be created in the next week