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

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

Total Marks: 20

Due Date:07/12/2015

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,

  • Giving the idea of most commonly used semantic data model for graphical representation of conceptual database design i.e. Entity Relationship Data model. 
  • Giving the idea of entities, attributes, cardinalities and relationship between the entities in the system.
  • Providing an understanding of types of relationships i.e. in how many ways an entity interact with other entity in real world.

 

 

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. 02:

 

This Assignment is the continuation of First Assignment. Take same case study already used in Assignment 01.Apply the techniques and methods given in lectures (7-10)regarding ER Diagramand by utilizing the solution of first assignment uploaded on VULMS in the form of DFD in order to finalize the tasks of second assignment listed below in task description.

Task Description:

 

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

 

Tasks:

In this assignment you will have to perform the following two tasks:

Task No. 01:

Identify all the Entities along with proper attributes.            (8 Marks)

Task No. 02:

You will have to make a final comprehensive ER Diagram of the system showing all entities and their attributes identified in Task 1.                                                   (12 Marks)

 

 

 

 

Drawing Final ER Data Model:

You can use MS Word or MS Visio for drawing the final ER Diagram.

 

Guidelines:

  1. Use Standard UML notations for entities, attributes, relationships and cardinalities used in handouts.
  2. Use Proper naming conventions for entities, attributes and relations as given in handouts.
  3. Copy/Paste your class diagram in your final MS Word (.doc) file if you are using any drawing tool (MS Paint, MS Visio etc).                                                     

 

 

 

Lectures Covered:This assignment covers Lecture #  7-10

Deadline:Your assignment must be uploaded/submitted at or beforeDecember 07, 2015

 

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

.

+ 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

solution 

Attachments:

which one is true.............?

solution file

Attachments:

cs403 DBMS Assignment No 2 (IDEA SOLUTION)

Attachments:

thanks

i think there is a big mistake in these attributes. according to mention attributes of each entity, there must b a identifier of that entity. so we must 've to mention identifier here. like CNIC num ber can be used as identifier.

Thanks sir

RSS

Latest Activity

Profile IconMudassir Abbas, Muhammad Abbas, Anum and 8 more joined Virtual University of Pakistan
2 minutes ago
Faisal izhar liked ZR's discussion Psy101 quiz1 solved 2018
4 minutes ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion BIO302 Molecular Biology Assignment No 01 Fall 2019 Solution & Discussion in the group BIO302 Molecular Biology
5 minutes ago
彡Tweety彡 ❤️ replied to +***piya o ry piya***+'s discussion eng301 solution chahiyaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
8 minutes ago
Fahad replied to + M.Tariq Malik's discussion CS304 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 13-11-2019 in the group CS314 Introduction to Cellular Networks
8 minutes ago
Fahad replied to Ikra butt's discussion CS610 Assignment No 1 Solution Complete And Correct Solution in the group CS610 Computer Network
9 minutes ago
+***piya o ry piya***+ replied to +***piya o ry piya***+'s discussion eng301 solution chahiyaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
11 minutes ago
+ ! ! ! ! ! ! BLaiRe ! !+ liked + Iuuoɔǝut +'s discussion یہ محبت ہی میری خطا ہوگئی
18 minutes ago
+***piya o ry piya***+ replied to +***piya o ry piya***+'s discussion eng301 solution chahiyaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
18 minutes ago
MUHAMMAD USMAN replied to + M.Tariq Malik's discussion MGT611 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 14-11-2019 in the group MGT611 Business & Labor Law
22 minutes ago
Profile IconMUHAMMAD USMAN and Amina Azeem joined + M.Tariq Malik's group
22 minutes ago
+ Iuuoɔǝut + posted a discussion
23 minutes ago
MUHAMMAD USMAN replied to + M.Tariq Malik's discussion CS606 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 14-11-2019 in the group CS606 Compiler Construction
23 minutes ago
MUHAMMAD USMAN joined + M.Tariq Malik's group
23 minutes ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion FIN622 Corporate Finance GDB Fall 2019 Solution & Discussion in the group FIN622 Corporate Finance
27 minutes ago
+ M.Tariq Malik liked + M.Tariq Malik's discussion FIN622 Corporate Finance GDB Fall 2019 Solution & Discussion
27 minutes ago
+ M.Tariq Malik added a discussion to the group FIN622 Corporate Finance
29 minutes ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion CS205 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 14-11-2019 in the group CS205 Information Security
31 minutes ago
Annu posted a discussion
32 minutes ago
Fahad replied to + M.Tariq Malik's discussion CS205 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 14-11-2019 in the group CS205 Information Security
34 minutes ago

Today Top Members 

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

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