Assignment No. 03 of CS403 has been uploaded and will be closed on Jan 27, 2016

[محمد شہروز منیر(BScs 7th semest)]

	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 [e-mail] 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:   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. 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: 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. You are required to transform all entities into tables by CREARE TABLE command. You have to transform all entity attributes into columns. Define appropriate data types of each attribute. Apply entity integrity constraint by defining primary key of each entity. Insert 3 rows in each table using SQL INSERT command. 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

 

[+ M.Tariq Malik]

Dear Students Don’t wait for solution post your problems here and discuss ... after discussion a perfect solution will come in a result. So, Start it now, replies here give your comments according to your knowledge and understandings....

[Nazia Tabassum]

A.o.a

Tariq bhai mera SQL server install ho gya hai per meray pass code run nai ho rha Plz muj ko as ka correct code or complete assignment solution send ker dya Kal last date hai plz help me 

[Dextorstudent]

For installation of SQL server must Install windows 7 professional or above. its CD is available in Market with sql sever maximum 5 gb storage. Install must in Administrator Login. Virtual University MDB is not providing to much information about this one phenomena. he only said you download this software from download section. i Really worried and waste 2 week but in vain. The campus trainer did not help us about this installation. after searching 2 week i find that this installation process. Now i can easily execute any query without any tension. Please don't waste time and install windows 7 professional.

[Dextorstudent]

This Video Also help you for installation of  SQL Server Follw this link

SQL Step by step

[Dextorstudent]

PRactice makes even the student prerfect

to create a table
use Demodata

create table employee (id int,name varchar(50),dept varchar(50),age varchar(50),salary varchar(50),location varchar(50))

to insert data into table
insert into employee (id,name,dept,age,salary ,location) values (105,'Srinath', 'Aeronautics',27,33000,'Dehli');

insert into employee (name,dept,age,salary ,location) values ('Srinath', 'Aeronautics',27,33000,'Dehli');

(id , name , fname , age , phnum ,location)

insert into (id , name , fname , age , phnum ,location) values(1,'Rehmat Ali','Nawaz Ahmad', 18, 1234567,'Karachi')

update fields
UPDATE employee
SET name='Akhtar Ali', age=27
WHERE name='Akhtar A;i';

fetch data into the order
order by

select * from employee order by name

Add attribute value in any table
alter table senroll add classname char(15)

[Ahmed KHursheed]

please koi complete solution de dooo plz

[arshad iqbal]

dear    plz do the solution in correct form

[saminakausar]

mera server name nai lag rha or server sa connect nai ho rha plzzzzz

help

[saminakausar]

Wasiq MAHMOOD PLZZZZZ MJHY SERVER NAME DA DE AP 

ki pic mn server name nai hai

[Wasiq Mahmood]

mara server name different hai

WASIQ-PC\SQLEXPRESS

ap ki server name different ho ga

[saminakausar]

BHAI SUB KUCH CORRECT KRTI HO PTA NAI Q CONECT NAI HO RHA

[Wasiq Mahmood]

USE BC000000000

/* YEH COMMAND USE KARO

DROP TABLE movie

CREATE TABLE movie

(

...................................

...................................

)