Assignment No. 04 (Graded) SEMESTER Fall 2015 CS403- Database Management System

[Malik]

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             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). Insert above rows in each table i.e. MOVIE and CINEMA using SQL queries.     After inserting rows, Perform the below tasks:   Write an SQL query to apply Right outer join between table MOVIE and CINEMA and show the result. Write an SQL query to apply inner join between table MOVIE and CINEMA and show the result. 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 $         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

 

[Abrar Ahmed (BSSE)]

Jiss ko full assignment chahye meri time line py pari hwi hy as a pictures enjoy karen..

https://www.facebook.com/bc130401499

[Atif Aslam]

500 mein se ak zero nikal do 50 chalen gy if u want

[Rabia Shahbaz]

It didn't work :( now? Already missed 3rd assignment.

[Muhammad Umer]

Only just install SQL Server 2008 for windows 7 or 8. There are lot of issues in 2005.

[omi]

but i have windows xp

[Sumbul]

https://www.youtube.com/watch?v=h24S8xXC94A

[Sumbul]

Resolving SQL Server Connection Error 26

[Suleman]

After creating tables and inserting rows just enter this
select * from Cinema right outer join Movie
on Cinema.Mov_Id = Movie.Mov_ID;
select * from Cinema inner join Movie
on Cinema.Mov_Id = Movie.Mov_ID;
Select*from Movie where Mov_Cost = 350000

[Abrar Ahmed (BSSE)]

Suleman see assignment file..

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

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

[Syed Salman Ali]

assignment # 03 me MOVIES k table me alag columns hen aur assignment # 04 me alag columns hen, kya kren ab hum log?

[Syed Salman Ali]

Assalam-o-Aleikum,

 

Diagram for MOVIES table in assignment # 03 has different columns and MOVIES table shown in assignment # 04 has different columns. Now what should we do?

Little time left in submission, please clear the confusion.

Should we (students) proceed with latest MOVIES table?

 

[Syed Salman Ali]

send this email to this subjects instructor's email address