We have been working very hard since 2009 to facilitate in your learning Read More. We can't keep up without your support. Donate Now.

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

 


+ 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)


Views: 12171

Replies to This Discussion

I think its continuity of assignment # 3

A.O.A
help me solved the Assignment

CS403 - Database Management Systems Assignment No. 4 Solution Fall 2015 Due Date Feb 09, 2016

Please Discuss here about this assignment.Thanks

Our main purpose here discussion not just Solution

We are here with you hands in hands to facilitate your learning and do not appreciate the idea of copying or replicating solutions.

lets start discussion 

itni easy assignment :O

just 5 minutes ki assignment di vu walay pagal ho gaye hen kya.

jis ko chahiye wo muj se le skta hai :-!

blur iss liye kia hai k pehle ap log khud bnanay k try kren

please give solution ma cs k subj k bar kch b nai janti par mujhe apni frnd k ly assignment chahe g so plzzzzzzzzz solution dy dy g mj g.....

please share its solution with me

A.O.A
please share code file.

brother meri wali bana do mere laptop me sql kam nai kr raha.

dear Asim ,

                 i have problem in installing the SQL  . Plz if possible send me the cs403 correct solution . thanks

ai_prince_eng@yahoo.com

Asim is main CINEMA table main MovID ka columns nhi banana hy wo MOVIE table sy utha k CINEMA k andar just show karna hy...

RSS

Latest Activity

++Mongol updated their profile
2 minutes ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion EDU201 Learning Theories Assignment 01 Fall 2020 Solution / Discussion in the group EDU201 Learning Theories
2 minutes ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion GSC201 Teaching of General Science Assignment 01 Fall 2020 Solution / Discussion Due Date: in the group GSC201 Teaching of General Science
2 minutes ago
Ꮆㄩフフ卂尺 liked Hafiza Tehreem Fatima's discussion BIRTHDAY CELEBRATION OUR BELOVED <MEMBER SARAH ABDUL
16 minutes ago
+M.Tariq Malik replied to Muhammad Faizan Alam's discussion STA301 Assignment No.1 | FALL 2020 | Due Date: 8th December, 2020 in the group STA301 Statistics and Probability
16 minutes ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion MGT301 Principles of Marketing Assignment 01 Fall 2020 Solution / Discussion in the group MGT301 Principles of Marketing
22 minutes ago
Blessings liked Blessings's profile
23 minutes ago
+M.Tariq Malik replied to shifa arshad's discussion MGT501 GDB Fall 2020 Solution / Discussion Due Date: 09-dec-2020 in the group MGT501 Human Resource Management
31 minutes ago
Mani Siddiqui Ex posted a status
"جینے والوں نے خود کشی کر لی.. رہ گئے جو، اداس رہتے ہیں.."
32 minutes ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion MTH633 Group Theory Assignment 01 Fall 2020 Solution / Discussion in the group MTH633 Group Theory
36 minutes ago
+M.Tariq Malik replied to Fragrance of Islam's discussion ENG301 Business Communication GDB No 01 Fall 2020 Solution / Discussion in the group ENG301 Business Communication
40 minutes ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion PSY407 Assignment 01 Fall 2020 Solution / Discussion Due Date: 07-12-2020 in the group PSY407 Sport Psychology
42 minutes ago
Ellen Shades posted blog posts
44 minutes ago
Profile IconRabi Rajput, Ayesha, Nabila and 18 more joined Virtual University of Pakistan
46 minutes ago
Ayesha liked +M.Tariq Malik's discussion PSY401 Clinical Psychology Assignment 01 Fall 2020 Solution / Discussion
51 minutes ago
Saba liked +M.Tariq Malik's discussion VU New Grading Scheme For Semester Fall 2020
2 hours ago
Blessings posted a status
"Mn is qabil tu na tha .....................jis qabil mjhe RUB ne bna diya JUMMA MUBBARAK"
2 hours ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion PSY402 Experimental Psychology Assignment 01 Fall 2020 Solution / Discussion Due Date: 07-12-2020 in the group PSY402 Experimental Psychology
3 hours ago
+M.Tariq Malik liked ・༓☾ Shayna ☽༓・'s blog post ✿ Money Can't Buy ✿
4 hours ago
+M.Tariq Malik replied to Muhammad Faizan Alam's discussion STA301 Assignment No.1 | FALL 2020 | Due Date: 8th December, 2020 in the group STA301 Statistics and Probability
4 hours ago

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

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

.