BCA - Black Out Party!!!!!

Black Out Party!!!!
(only for Students of BCA)
:-)

E-Mail Id Submission for English CCE (BCA IV - SEM )

E-Mail Id Submission for English CCE (BCA IV - SEM )

BCA SEM-II 'C' Final Assignment 2012

C LANGUAGE
FINAL PRACTICAL ASSIGNMENT 2012
BCA - SEM II

Click on the Image to open FULL IMAGE, then Right Click on the Image and Save it.

BCA-Sem-VI - JAVA Final Assignment 2012

BCA-Sem-VI - JAVA Final Assignment 2012

BCA-Sem-VI - Basic Computer Information Technology-II [Foundation Course-III] Final Practical Assignment 2012

BCA-Sem-VI - Basic Computer Information Technology-II [Foundation Course-III]
Final Practical Assignment 2012

BCA Semester IV - Data Structure & Algorithm-Final Assignment 2012

BCA Semester IV - Data Structure & Algorithm-Final Assignment 2012

VISUAL BASIC - Final Practical Assignment - Sem V [2011]

VISUAL BASIC

Final Practical Assignment - Sem V [2011]
Last Date of Submission: 1617 Dec, 2011

Last Year's Demo File:

Practical Assignment File of BASIC Computer Info. Tech.-I (FC-III) Sem-V 2011

Practical Assignment File of

BASIC Computer Info. Tech.-I

(FC-III) Sem V

@#$

Practical Assignment on Oracle 2011 Sem V

Practical Assignment on Oracle
Semester - V
Session: 2011

BCA-SEM-III - DBMS FINAL PRACTICAL ASSIGNMENT

BCA-SEM-III

DBMS FINAL PRACTICAL ASSIGNMENT

BCA-Sem-III - C++ Final Assignment 2011

BCA-SEM-III

C++ FINAL PRACTICAL ASSIGNMENT

Turbo C++ for 64 Bit OS

Turbo C++ for 64 Bit Operating System

Probable List Of Questions Final Practical Exam

Probable List Of Questions Final Practical Exam

To Download the Questions' list:

Click on the Image

or

Click here.

Your comments are Welcome.....

Job Oriented Project-Work FORMAT Sem-IV

Job Oriented Project-Work FORMAT Sem-IV

Click on the Image to Enlarge/Save FULL IMAGE on then Save it

---

FORMAT OF THE FRONT PAGE......

Your comments are Welcome.....
View Job Oriented Project-Full-Sem-3 .

Assignments for Both CCEs - Numerical Analysis

Assignment for CCE-1 - Numerical Analysis

To Download the Assignment with Roll Nos. & All Questions:

Click on the Image above

or

Click here.

Your comments are Welcome.....

Password is vvijay.co.cc

CCE-2 (CHART) Assignment: Numerical Analysis

---

To Download the Assignment, Click on the Images...

Click Here for the CCE-2 Chart

Your comments are Welcome.....

---

Final Practical Assignment - Web Design

Final Practical Assignment - Web Design

To Download the Assignment:

Click on the Image

or

Click here.

Your comments are Welcome.....

Final Practical Assignment - Data Structure

Final Practical Assignment - Data Structure and Algorithm

To Download the Assignment:

Click on the Image

or

Click here.

---

---

Your comments are Welcome.....

List of Files Uploaded for Sem IV

BCA Collections

Click here to View the List of all Files.

Your comments are Welcome.....

;-)

Project-HOD

A Report on

(Title of the Report)

(Name of Subject)

Any relevant photo or diagram of topic Or Computer system

(Not more than 2*2 inches)

BY

NAME OF STUDENT

CLASS

SUBMITTED TO

MRS. ARCHANA NAIK

H.O.D.

DEPT OF COMPUTER APPLICATION

THE BHOPAL SCHOOL OF SOCIAL SCIENCES BHOPAL-462026

DECEMBER-2010

INDEX

S. No.	Particulars	Pg. No.
1	Details of the student	1
2	Brief of the subject	2
3	About Topic	*-*
	· Definition
	·
	·
	·
	·
	·
4	Conclusion	*
5	References	*

Details of Students

Name of the Student:

Permanent Address:

Address for Correspondence:

Contact Number:

Student email:

Name of Subject:

Name of Topic:

Brief of the subject About Topic

• Definition

• History

• Characteristics/ Properties/ Features

• Various types

• Advantages/Disadvantages

• Comparison with relevant topic

• Relevant:- diagrams .flowchart, block diagram (Either hand made or typed) (All the diagrams must be numbered like Fig. 1)

• Relevant examples/programs/queries

• Real life examples

• Relevant sub points from above mentioned points have to be used

Conclusions

Summary of topic

References

A list of referred books and Website, (not more than 7-8),

Do not write name of any search engine like Google.....

Rules

List1

List2

FINAL PRACTICAL ASSIGNMENT-DBMS

BCA-SEM-III

FINAL PRACTICAL ASSIGNMENT

●DBMS

♦ Date of submission:

28^th Oct 2010

♦ Submit 

assignment in clip file.

Q1. Draw an ER Diagram for Software Company:-

In Software Company there are three categories of Employees: Grade 1, Grade-2 and Grade-3. Employee belongs to different department Employees work on different Project. Department runs various Project.

Design the Database for the above System with the following constraint:-

a. Every entity must have a unique identification number.

b. Employee name must be in upper case.

c. Name of the Project must not be null.

d. Salary of employee must be greater than 15000.

e. In the employee table employee-type must be as follows:

· 'G1for Grade-1 (default).

· 'G2' - for Grade-2.

· 'G3' - for Grade-3.

Q2. Below is the database of a Super Market ( An organization).( reate following tables and answer the queries based on these tables:-

1. List the name of employee having 'A' or 'E' as second letter in their name.

2. Calculate the total quantity of each product supplied by supplier.

3. Increasing the salary of employees of SALES department by 10% and display their names.

4. Display the supplier id and name of all suppliers who do not live in Indore and Nagpur.

5. Display the supplier id and name of all suppliers who live in Delhi or Mumbai.

6. Add a new column Gender in employee table and insert the value in it

7. Display the employee id and name of all employees with their respective department name

8. Count the total number of employees whose salary exceeds by Rs. 20000 in each department.

9. Retrieve the total number of employee in ADVERTISING department.

10. Calculate the average of salary for each department.

11. Create a view on supplier table having any two fields.

12. Create a copy of an existing employee table.

13. Modify the width of the NAME field of supplier table from 15 to 20.

14. Display the name of employee in ascending order.

15. Retrieve the name and phone number of all suppliers who lives Delhi and Mumbai.

16. Retrieve the name and phone number of employees whose salary is greater than 10000.

17. Find the sum of the salaries of all employees of the “SALES' department, as well as the maximum salary, the minimum salary and average salary in the department.

18. List the date of manufacturing in descending order.

19. Create a new user U1 and give the permission of select on Employee table of Scott to Ul.

20. Revoke the above permission from Ul.

Q3. Write a PL/SQL block of code to calculate the factorial of a gives number.

Q4. Write a PL/SQL block of code to print the table of a given number.

Q5.Write PL/SQL code block to show the following pattern:

*

* *

* * *

* * * *

* * * * *

Q6. Write a PL/SQL code block to calculate the area of a circle for value of radius varying from 5 to 15.Store the radius and the corresponding values of calculated area in a table AREAS containing attributes Radius, Area.

Q7. Write a PL/SQL block of code for generating the Fibonacci series.

OR

Click the links below to download the DBMS Final Practical Questions:

DBMS Final Practical

Click here(Server1) to Download Oracle 8.0

Click here(Server2) to Download Oracle 8.0

Click below to download WinRar

(Pasword is '1' without quotes)

Download WinRar

Last Year's DBMS File Demo:

DemoFile

for Password... Contact Vijay

Oracle 11g
works 100% in Windows XP, Vista & 7

For Pasword... Contact Vijay

Click here to download

I Thank and Appreciate Raaj for helping me

and spending his valuable time for all the Uploads...