+ Link For Assignments, GDBs & Online Quizzes Solution |
+ 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:
CINEMA:
After inserting rows, Perform the below tasks:
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 |
Tags:
+ 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)movie ka id nai bnao gy to inner join result kese de ga :O
bhai kindly mja bna do...mra pas sql server ni hai...plzzz
ammadkhan77@gmail.com
AoA plz mail me assignment plz
sstit7786@gmail.com plz
Bro mujse nhi horhi ye assign plz send me thanks
raomuhammadfurqan@gmail.com
de do sloution?
Bhai plz help me in assignment cs 403
Mujhse to ub tk SQL hi download nhi huaa. lots of error
cod to share ker do koi plz
plz share da solution asim
Asslam Allekum Friends is screenshot main do columns hn date ka and currency ka in ki format change karni hy.
Date ke format esi ho mm/dd/yyyy or
currency ki value k sath dollar ka symbol aa ja comma k saath like agar 150000 value hy to result main 150,000$ ay is main meri koi help kar dy plzz i am weting
© 2021 Created by + M.Tariq Malik.
Powered by
Promote Us | Report an Issue | Privacy Policy | Terms of Service
We have been working very hard since 2009 to facilitate in learning Read More. We can't keep up without your support. Donate.
We are user-generated contents site. All product, videos, pictures & others contents on site don't seem to be beneath our Copyrights & belong to their respected owners & freely available on public domains. We believe in Our Policy & do according to them. If Any content is offensive in your Copyrights then please email at m.tariqmalik@gmail.com Page with copyright detail & We will happy to remove it immediately.
Management: Admins ::: Moderators
Awards Badges List | Moderators Group
All Members | Featured Members | Top Reputation Members | Angels Members | Intellectual Members | Criteria for Selection
Become a Team Member | Safety Guidelines for New | Site FAQ & Rules | Safety Matters | Online Safety | Rules For Blog Post