Sponsored Links


Results 1 to 3 of 3

Thread: CS403 Assignment No. 03 Solution 23rd January 2016

  1. #1
    Administrator Vuhelper's Avatar
    Join Date
    Apr 2011
    Posts
    9,578

    Thumbs up CS403 Assignment No. 03 Solution 23rd January 2016

    Sponsored Links1


    Assignment No. 03(Graded)
    SEMESTER Fall 2015
    CS403- Database Management System
    Total Marks: 20
    Due Date:27/1/2016
    Instructions:
    Please read the following instructions carefully before solving & submitting assignment:
    It should be clear that your assignment will not get any credit (zero marks) if:
    The assignment is submitted after due date.
    The submitted assignment does NOT open or file is corrupt.
    The assignment is copied (from other student or ditto copy from handouts or internet).
    You are supposed to submit your assignment in .doc / Docx format. Any other formats like scan images, PDF, Zip, rar, bmp etc will not be accepted.

    Objectives:
    The objectives of this assignment are,
    • To give students the idea of the most commonly used RDBMS for designing physical database systems i.e. SQL SERVER.
    • To build and manage SQL Server databases.
    • To apply constraints e.g. Primary Key and foreign key on attributes.
    • To retrieve and manipulate data with SQL queries from tables.
    • To insert, update, and delete data from SQL tables.
    For any query about the assignment, contact at cs403@vu.edu.pk
    GOOD LUCK

    Marks: 20

    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.
    Important Note Regarding Assignment No. 03:

  2. #2
    Administrator Vuhelper's Avatar
    Join Date
    Apr 2011
    Posts
    9,578
    kitna table banana hai Second Assignment to read karta hua banana hai Assignment 2 ma 10 table hai
    MOVIE (MovID, Mov_Name, Mov_Producer, MovReleasDate, MovCast)
    PRODUCER (ProducerID, ProducerName)
    PRODUCTION MANAGER (PmID, PmName)
    DIRECTOR (DirectorID, DirectorName)
    BUDGET (BudgetID, BudgetSize, BudgetReleaseDate)
    RESOURCES (ResID, ResType)
    FUNDING AGENCIES (FA_ID, FA_Name, FA_RegNo)
    CINEMA (CinRegNo, CinemaName, CinemaLocation)
    REVENUE (RevID, NetAmount)

  3. #3
    Administrator Vuhelper's Avatar
    Join Date
    Apr 2011
    Posts
    9,578
    To give students the idea of the most commonly used RDBMS for designing physical database systems i.e. SQL SERVER.
    • To build and manage SQL Server databases.
    acha hmen aik sqlmmessgae creat krna hai...
    • To apply constraints e.g. Primary Key and foreign key on attributes.
    jo primary key and foreign key pe mushtamil ho...
    • To retrieve and manipulate data with SQL queries from tables.
    thn sqlqureis ko manipulate frm table
    • To insert, update, and delete data from SQL tables
    insert statemnts use hgi update and delte from sql..

    Sponsored Links

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 01-20-2016, 05:20 PM
  2. Replies: 0
    Last Post: 01-20-2016, 05:19 PM
  3. Replies: 0
    Last Post: 01-20-2016, 05:02 PM
  4. cs301 assignment no 3 Solution 20 January 2016
    By Vuhelper in forum Assignments & Solutions
    Replies: 0
    Last Post: 01-20-2016, 02:32 PM
  5. CS101 Assignment no 3 Solution 20th January 2016
    By Vuhelper in forum Assignments & Solutions
    Replies: 0
    Last Post: 01-20-2016, 02:25 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
-: Vuhelp Disclaimer :-
None of the files shown here are hosted or transmitted by this server. The links are provided solely by this site's users. The administrator's or staff of Vuhelp.net cannot be held responsible for what its users post, or any other actions of its users. You may not use this site to distribute or download any material when you do not have the legal rights to do so. It is your own responsibility to adhere to these terms. If you have any doubts about legality of content or you have any suspicions, feel free to contact us.
Online Education | JhelumSoft