Question
( 1 mark ) Questions: 1. Describe process modeling and data modeling in the analysis phase respectively. 2. Give another example of weak entity as
(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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started