Q1: You have three tables in your relational database: Movie , Star , and RolePl
ID: 3822097 • Letter: Q
Question
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
You’ve 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
(1) Movie
(2) Star
MovieID
Title
Rating
StarID
Name
YearBirth
M1
Castaway
PG-13
St1
Tom Hanks
1956
M2
You’ve Got Mail
PG
St2
Meg Ryan
1961
M3
City of Angels
PG-13
St3
Nicolas Cage
1964
Explanation / Answer
1.
This is what you are trying to do:
SELECT * // This statement will show all the columns
FROM RolePlayed // from RolePlayed table, * refers to all columns
WHERE StarID=”Meg Ryan”; // StarID in this table has numeric values and you are trying to compare it with string(text), so this would generate an error
This is what you should do:
SELECT M.Title , M.Rating
FROM Movie M, Star S, RolePlayed R
WHERE M.MovieID=R.MovieID
AND S.StarID=R.StarID
AND S.Name= 'Meg Ryan' ;
SELECT M.Title , M.Rating // Will show only title and rating, which is asked
FROM Movie M, Star S, RolePlayed R // because the name of the star is in Star table, title and rating are in Movie table and the RolePlyed table maps the 2 tables(which actor played which role in which movie)
The rest of the two questions seems to be from some other subject. Please ask them in appropriate section.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.