We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>

Looking For Something at vustudents.ning.com? Click Here to Search

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & More


Production House Budgeting System

Entertainment industry is flourishing day by day in Pakistan. Due to the revival of Film industry new production houses are opening. The production company is generally responsible for fundraising for the production. It handles budgeting, scheduling, scripting, supply with talent and resources, the organization of staff, the production itself, post-production, distribution, and marketing.

Suppose Mr. “X” is your friend and has opened a production company with the name “Dream Anime”. He wants you to automate the whole processing of the company, especially the budgeting of the films to keep track of the financial status of the company.

A film goes through many phases. Development, Preproduction, production, post production and distribution are the main phases of film production.

Suppose the story of the movie has been decided in the development phase by the producer and it is moved to the production phase. 

Pre-Production:

In pre-production, every step of actually creating the film is carefully designed and planned. The film is pre-visualized by the director, and may be storyboarded with the help of illustrators. A production budget is drawn up to plan expenditures for the film. Expenditures include cast, crew, production cost (location expenditure, equipment etc), visual effects and music etc.

The producer hires a crew. The nature of the film, and the budget, determine the size and type of crew used during filmmaking.

Production manager handles all the expenses and cost related issues. He along with producer decides the budget of the project and manages the resources accordingly. He is also responsible for collecting the finance for the project. Production manager also contacts funding agencies and finalizes the deal.

After Preproduction, project goes into the production and post-productionphases where the actual filming, editing and mixing etc. are done. When the movie is in the final shape and ready to be in the cinemas, it goes into the distribution phase.

 

Distribution:

This is the final stage, where the film is released to cinemas, occasionally, directly to consumer media (DVD, VCD, VHS, Blu-ray). The film is duplicated as required and distributed to cinemas/distributors for exhibition (screening).

After the movie releases, the production company keeps track of the revenue generated by the movie from all possible ways. They keep checking the profit and loss status of the movie after all payments. The profit of the funding companies is also paid back.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Task Description:

 

In this assignment you will focus only on the tasks given below:

 

 

MOVIE:

MovID

MovName

MovCost

MovReleaseDate

101

Brave Heart

250,000 $

1/1/1995

102

The Troy

350,000 $

1/1/2004

103

CyBurg

150,000 &

1/1/1989

104

The Petriot

450,000 $

30/06/2000

105

Black Hawk Down

550,000 $

1/5/2000

 

 

 

 

 

 

 

 

CINEMA:

 

CinRegNo

CinemaName

CinemaLocation

MovID

1

Cinepex

Islamabad

101

2

Shama

Peshawer

103

3

PRC

Multan

105

 

 

 

 

 

 

  1. Open the Query Analyzer/SQL server management studio, and perform the below tasks in already created database (Assignment#03). If you have not create a database for assignment#03 then creates a database along with above mentioned tables (MOVIE and CINEMA).
  2. Insert above rows in each table i.e. MOVIE and CINEMA using SQL queries.

 

 

After inserting rows, Perform the below tasks:

 

  1. Write an SQL query to apply Right outer join between table MOVIE and CINEMA and show the result.
  2. Write an SQL query to apply inner join between table MOVIE and CINEMA and show the result.
  3. Write an SQL query to apply subquery (nested query) between table MOVIE and CINEMA, which shows the following results;

 

MovID

MovName

MovCost

102

 The Troy

350,000 $

 

 

 

 

  1. Take screenshots of your work, and paste them in your solution file (.DOC file).

 

Hint: You can use aggregate function i.e. max function to perform the 5th task.

 

Lectures Covered:This assignment covers Lecture #  28 to 32

Deadline:Your assignment must be uploaded/submitted at or before Febraury 9, 2016

 

+ How to Join Subject Study Groups & Get Helping Material?

+ How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?

+ VU Students Reserves The Right to Delete Your Profile, If?


See Your Saved Posts Timeline

Views: 12079

.

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

+ Click Here To Join (Our facebook study Group)

Replies to This Discussion

solution file

Attachments:

Edit karny main mahir hy pakistani 

Shahroz ????

Thank You Imran Ahmed, You did such a good work regarding SQL. Salute u Bro........................ :) :)

actually you third answer is wrong you have used sub query be instead of using both table you have used only one this question have a logical error but still we can pull out desire data 

Write an SQL query to apply subquery (nested query) between table MOVIE and CINEMA, which shows the following results;

Hi Brother. can you help me for screenshots. I could not install this SQL? plzz

how to write our id in the

create database type id

plz koi help kare Batain yahan kya masla hai?

Attachments:

Attachments:

Hi brothers. anyone can help me in this assignment. I couldn't install the SQL on PC. so anyone of you can do me a favor plzz. ??

RSS

Latest Activity

Mahim Ch replied to + M.Tariq Malik's discussion VU Students Reserves The Right to Delete Any Profile On the Site
25 minutes ago
Hadi updated their profile
1 hour ago
彡JK彡 ❤️ liked +¢αяєℓєѕѕ gιяℓ's discussion عزت وہ ہے جس میں ہمارا قلب مطمئن ہوتا ہے
1 hour ago
+ M.Tariq Malik liked + M.Tariq Malik's discussion 111 Solved MCQs of Financial Management MGT201
1 hour ago
+ !♛Abee Smarty ♛!+ liked moniba hussain's blog post love
1 hour ago
+ !♛Abee Smarty ♛!+ liked moniba hussain's blog post fun
1 hour ago
+ !♛Abee Smarty ♛!+ liked + "αяsαℓ " Ќąƶµяɨ •"'s blog post نظر لگنا کیا ہے اور بُری نظر انسان کے جسم پر کیسے اثر انداز ہوتی ہے
1 hour ago
+ !♛Abee Smarty ♛!+ liked + Iuuoɔǝut+'s blog post Things about Arabic Language in an info graphic
1 hour ago
+ !♛Abee Smarty ♛!+ liked + Iuuoɔǝut+'s blog post The End Is Not Near, But If An 'Insect Apocalypse' Ever Happens, How Would We Know?
1 hour ago
+ !♛Abee Smarty ♛!+ liked + Iuuoɔǝut+'s blog post Dengue fever facts
1 hour ago
+ !♛Abee Smarty ♛!+ liked + "αяsαℓ " Ќąƶµяɨ •"'s blog post چھوٹا کام
1 hour ago
+ !♛Abee Smarty ♛!+ liked ++"S.M.TALHA"++'s blog post کی جاناں میں کون
1 hour ago
+ !♛Abee Smarty ♛!+ liked + ! ! ! ! !Cato's blog post Lets Make .....................Tasbeeh
1 hour ago
+ !♛Abee Smarty ♛!+ liked +++STUDENT+++'s blog post Depression
1 hour ago
+ !♛Abee Smarty ♛!+ liked ϝ ι ყ α's discussion What is Microsoft Excel..............???
1 hour ago
+ !♛Abee Smarty ♛!+ liked ϝ ι ყ α's discussion *1st $em VS Last Sem,................*
1 hour ago
+ !♛Abee Smarty ♛!+ liked + "αяsαℓ " Ќąƶµяɨ •"'s discussion Muhabato me li gaye kasmain
1 hour ago
+ !♛Abee Smarty ♛!+ liked + sílєnzíσ's discussion If fb, google nd youtube would have been subjects..... !!!!!!!!!!!!
1 hour ago
+ !♛Abee Smarty ♛!+ liked +¢αяєℓєѕѕ gιяℓ's discussion عزت وہ ہے جس میں ہمارا قلب مطمئن ہوتا ہے
1 hour ago
+ !♛Abee Smarty ♛!+ liked + M.Tariq Malik's discussion ایسا بھی میرے دوست فارغ نہیں ہوں - میں بیٹھا ہوں انتظار میں، کب یاد آوں گا
1 hour ago

© 2019   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service