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


Dear Students! Share your Assignments / GDBs / Quizzes files as you receive in your LMS, So it can be discussed/solved timely. Add Discussion

How to Add New Discussion in Study Group ? Step By Step Guide Click Here.

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:

 

  1. This Assignment is the continuation of Second Assignment. Taking in consideration the same case study of Production House Budgeting System, a conceptual database has been provided in the form of an ERD.
  2. You have to complete your next phase of the Database Development Process which is physical database design. You will create it by utilizing the same ERD which is provided in the next page (2nd Assignment Solution).

 Task Description:

 

This Assignment is related to Development phase and in this assignment you will focus only on the tasks given below:

 

Tasks:

  1. Open the Query Analyzer, and then create a new database by your id, like a sample screenshot provided on the last page of this file. Then create all the tables in this database by using it.
  2. You are required to transform all entities into tables by CREARE TABLE command.
  3. You have to transform all entity attributes into columns.
  4. Define appropriate data types of each attribute.
  5. Apply entity integrity constraint by defining primary key of each entity.
  6. Insert 3 rows in each table using SQL INSERT command.
  7. Take screenshots of your work, and paste them in your solution file (.DOC file).

Lectures Covered:This assignment covers Lecture #  25-30

Deadline:Your assignment must be uploaded/submitted at or before January 27, 2016

 

+ How to Follow the New Added Discussions at Your Mail Address?

+ 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: 11269

.

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

Attachments:

Replies to This Discussion

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) 

or sub ma delete insert or update type karni hai

all the table will we make separately open new window of SQL Server then we make new table yes or no

salam wasik bahi sql server ki installaino bata sakty hain ap

Sorry Rubina Akhtar ma na 4 din bad apni VU help site visit ki hai to SQL ko ap
https://www.microsoft.com/en-pk/download/details.aspx?id=7593
sa download karlo
phir ap run program karo kuch extract file ka bad aik windo open ho gi left side pa second option installation ka hai click on it the it will open another window us ma first option hai New SQL Server stand alone installation ka then click on it read it carefully always select on default option then you can easily install SQL Server.
SORRY AGAIN I didn't open my VU help ID in these 4 days I am really really SORRY sister RUBINA AKHTAR

Read more at http://vustudents.ning.com/group/cs403databasemanagementsystems/for...

Bohat easy aSSignment hai

yeh kesay karni hai help kar dein mujh se apnay name ki id hee nahin ban rahi

create database mc123456;

use mc123456;

aisay likh k execute kro bn jaye gi

ulain.qamar2@gmail.com   

yeh meri id hai. help kar dein 

pehle khud try kr lo na bni to phir le lena muj se

Please help ker do na muj se tu id hi creat nai ho rha hai 

asim sahib agar aap bana dain yeh assignment tou meherbani ho gi

ulain.qamar2@gmail.com

RSS

Latest Activity

Awais Ahmad liked ALEENA's profile
3 minutes ago
Fazal ur Rehman replied to + M.Tariq Malik's discussion SOC101 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 21-11-2019 in the group SOC101 Introduction to Sociology
38 minutes ago
Fazal ur Rehman joined + M.Tariq Malik's group
38 minutes ago
Khuzamah Rasheed replied to + M.Tariq Malik's discussion EDU402 Curriculum Development Assignment No 01 Fall 2019 Solution & Discussion in the group EDU402 Curriculum Development
41 minutes ago
Khuzamah Rasheed joined + M.Tariq Malik's group
41 minutes ago
ALEENA and Adilshahid are now friends
44 minutes ago
Sami joined + M.Tariq Malik's group
46 minutes ago
Khuzamah Rasheed posted a status
"full solution"
48 minutes ago
Khuzamah Rasheed posted a status
"kisi ke pas 402 code ki assignment hy fall 2019"
48 minutes ago
+ ! ! ! ! Mehαr Mαh꧂ posted a video

Wintergatan - Marble Machine (music instrument using 2000 marbles)

Get the audio track "Marble Machine" by Wintergatan: https://wintergatan.bandcamp.com/track/marble-machine Marble Machine built and composed by Martin Molin ...
56 minutes ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion MTH501 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 19-11-2019 in the group MTH501 Linear Algebra
56 minutes ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion MGT603 Strategic Management Assignment No 01 Fall 2019 Solution & Discussion in the group MGT603 Strategic Management
57 minutes ago
+ M.Tariq Malik liked + M.Tariq Malik's discussion MGT603 Strategic Management Assignment No 01 Fall 2019 Solution & Discussion
57 minutes ago
+ M.Tariq Malik added a discussion to the group MGT603 Strategic Management
58 minutes ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion MGT501 Human Resource Management Assignment No 01 Fall 2019 Solution & Discussion in the group MGT501 Human Resource Management
58 minutes ago
ALEENA replied to + M.Tariq Malik's discussion MTH501 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 19-11-2019 in the group MTH501 Linear Algebra
58 minutes ago
+ M.Tariq Malik liked + M.Tariq Malik's discussion MGT501 Human Resource Management Assignment No 01 Fall 2019 Solution & Discussion
58 minutes ago
ALEENA joined + M.Tariq Malik's group
58 minutes ago
+ M.Tariq Malik added a discussion to the group MGT501 Human Resource Management
59 minutes ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion HRM613 Performance Management Assignment No 01 Fall 2019 Solution & Discussion in the group HRM613 Performance Management
1 hour ago

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

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