Q1:

You have three tables in your relational database: Movie, Star, and RolePlayed.

(1) Movie				(2) Star
MovieID	Title	Rating		StarID	Name	YearBirth
M1	Castaway	PG-13		St1	Tom Hanks	1956
M2	Youve Got Mail	PG		St2	Meg Ryan	1961
M3	City of Angels	PG-13		St3	Nicolas Cage	1964

(3) RolePlayed
MovieID	StarID	CharacterName
M1	St1	Chuck Noland
M2	St1	Joe Fox
M2	St2	Kathleen Kelly
M3	St2	Maggie Rice
M3	St3	Seth

If the goal is to retrieve the title and rating of each movie in which Meg Ryan played a role, what errors, if any, exist in the following SQL statement?

SELECT *

FROM RolePlayed

WHERE StarID=Meg Ryan;

Q2:

For, at least 6 events of the revenue business process, specify:

Type of the event,

brief description which shows how that event relate to other events,

resources affected and with which type of relationships,

names of agents participating,

and documents associated (if any)

N.B. the 6 events have to belong to different types (for example, do not propose two increment economic event)

Answer:

Event	Type	Description	Resources	Agents	Documents

Q3:

A- What is the overall objective of the Acquisition/Payment process? and identify four sub-goals of this objective ?

B- Explain how the Acquisition / Payment process fits into the value system level ? and draw the part showing the connection at the value system level

C-

Based on the Acquisition/Payment business process level REA Model answer the following questions and post your answer in the table below :

1-Give 1 example for each Event

2-What are the Event type?

3-Who is the internal and External Agent for specified Event?

4-Hint ( Event type could be instigation, Mutual commitment, Economic increment, and so on.. )

Event	Event Type	Internal Agent	External Agent