Please nobody copy my answer .. 1. You have three tables in your relational data

Question

Please nobody copy my answer ..

1.

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”;

2.

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

          

3.A,What is the overall objective of the Acquisition/Payment process? and identify four subgoals of this objective ?

B.A.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 :

Give 1 example for each Event …

What are the Event type?

Who is the internal and External Agent for specified Event?

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

Event

Event Type

Internal Agent

External Agent

4.For the events Labor Operation (Economic Decrement), Machine Operation (Economic Decrement) Identify the resources and agents associated with each of them. Also discuss why are labor operations and labor types often tracked in the conversion process but usually not tracked in the revenue process?

Please answer all question and write by computer .. Thanks

(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. SELECT *
FROM RolePlayed
WHERE StarID=”Meg Ryan”

StarID is integer data type and passed here string data type(Meg Ryan), this is main error in the above script and also to retrieve the title and rating not used Movie table than not possible to get the title and rating of each movie. To retrieve the title and rating of each movie in which “Meg Ryan” played a role below is correct query by joining all the three table:

Select m.Title , m.Rating
from Movie m
Join RolePlayed r on r.MovieID = m.MovieID
Join Star s on s.StarID = r.StarID
Where s.Name = 'Meg Ryan'

2. An event is public assembly for the purpose of celebration, education, marketing or reunion. 6 events of the revenue business process is:
1) Social / life–cycle events: example Wedding, Anniversary etc
2) Education and career events: example seminar,debate etc.
3) Sports events: Olympics, World Cup, marathons, Wimbledon etc.
4) Entertainment events: celebrity nights, beauty peagents, flash mob, jewellery shows, stage shows etc.
5) Political events: rally, political functions etc.
6) Corporate events: meetings, incentives, conferences, exhibitions etc.

3. The Acquisition/Payment process is Gateway & Processing Connections to provide the platform to process the payments through internet. The main objective of Acquisition/Payment process to save time and also do in easier way and als very sucure as well as the convenience.

4. Labor operations and the labor types used up by those operations are typically tracked in the conversion process because they represent a significant portion of product costs and the value added by the conversion process. In the revenue process, labor is typically insignificant compared to inventory costs. The exception is if the revenue process involves the performance of services rather than the sale of goods, in which case labor operations and labor types would usually be tracked.
         

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.