Wednesday, September 3, 2014

E-BOOKS

1. Subject Name: Computer of Fundamental  (FOC)

1.1) E-Book
2.  Computer History  and Generation - FOC - Hindi 
3.  Fundamental of Computers: hindi
4.  PK Sinha Book:  
    Chapter-1: Introduction                         
    Chapter-2: BCO (Basic Computer Organization) 
    Chapter-3: Number System                     
    Chapter-4: Computer Codes
    Chapter-5: Computer Arithmatic             
    Chapter-6: Boolean Algebra
    Chapter-7: PAM (Processor and Memory)
    Chapter-8: Secondary Storage
    Chapter-9: IO Devices                             
    Chapter-10: CS(Computer Software)
    Chapter-11: PCP (Planning the Computer Program) 
    Chapter-12: CL (Computer Language)
    Chapter-13: SIO ( System Implementation and Operation)
    Chapter-14: OS (Operating System)         
    Chapter-15: ASP (Application Software Packages)
    Chapter-16: BDP (Bussiness Data Processing)
    Chapter-17: DCCN (Data Communicatio and Computer Networks)
    Chapter-18: Internet                                   
    Chapter-19: MultiMedia
    Chapter-20: COC (Classification of Computer)                   
    Chapter-21: C Language
5. Fundamental of Computer-1:  DOS Hindi - 1
6. Fundamental of Computer-2:  DOS Commands Hindi - 2
7. Fundamental of Computer-3:  DOS Commands Hindi - 3

1.2) Hand Written

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

2. Subject Name: Programming Technique Using C  

2.1) E-Book
1. Book for Computer C Language In -  Hindi  


@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
 4. Subject Name: Java                                                               

4.1) E-Book
 1. Programming with Java - A Premier ( 3rd Edition)  - Click to Download

4.2) Software
 1.  Java Software for Program
http://www.oracle.com/technetwork/java/javasebusiness/downloads/java-archive-downloads-javase13-419413.html
 2. Editor Software for Java -  http://www.textpad.com/download/index.html



@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
 Advance Java
1. Book for Java Script   Book Name: Java Script Bible
2. Book for Java Book in Hindi  by Kuldeep Chand Mishra
3. Book for Java Script in Hindi by Kuldeep Chand Mishra
4. Notes for Unit - V RMI Notes  
5. Notes for Unit - II JSP

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
 Java Script


@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@



5.Subject Name: Oracle SQL, PL/SQL, RDBMS
        Pwd = gr3ty


@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

6.Subject Name: Computer Network 

6.1) E-Book
1. Computer Network: Andrew S. Tananebaum: 4th Edition

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

7.Subject Name: System Analysis and Design
5. SDLC 6. Planning and Investigation  7. Testing and Quality 8. Tools of Structure Analysis
9. Feasibility  Study 10. HIPO IPO 11. PPT HIPO IPO

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
4.Subject Name: Dataware House
4.1) E-Book
1.  Paulraj Ponniah:  Data Warehousing Fundamentals
2. Paulraj Ponniah: Data Warehousing Fundamentals For IT Professionals
3  Notes for Data Ware House Case Study Link


@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@


1. eBook by  Paul Callaout:   Linux Fundamental
2. eBook: Unix Tutorial

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

Sunday, August 24, 2014

MSc-III(2014-15)

             
---------------------------------------------------------------------------------------------------------------------
1. Java Advance Research Topic
  1. Priya  Gupta- Java Beans
  2. Khushbu Agwarwal - Jar File
  3. Priyanka - Servlet
  4. Poonam - Web Application development in 2 and 3 Tier Architecture
  5. Shweta - Servlet Life Cycle
  6. Ritu Gupta - GET() and POST() compare
  7. Rachna Tiwari - HTTP and SSL
  8. Vidhi Chawla - Session 
  9. Shilpa - Cookies
  10. Shradha - Database Connectivity
  11. Neelam - TC/I Socket
  12. Shipra - RMI
  13. Deepti Daharwar - JSP form Processing
  14. Neha Giri  - Overview of JSP
  15. Poonam Singh -  JSP Life Cycle
  16. Swati - JSP Client Request and Server Response
  17. Security issues when dealing with RMI
--------------------------------------------------------------------------------------------------------------------

2. Assignments
  1. Priya  Gupta   -  JSP Client Request and Server Response
  2. Khushbu Agwarwal - JSP Life Cycle
  3. Priyanka - Overview of JSP
  4. Poonam -  JSP form Processing
  5. Shweta -  RMI
  6. Ritu Gupta -  TCP/IP Socket
  7. Rachna Tiwari -  Database Connectivity
  8. Vidhi Chawla -  Cookies
  9. Shilpa -   Session 
  10. Shradha - HTTP and SSL
  11. Neelam -   GET() and POST() compare
  12. Shipra -   Servlet Life Cycle
  13. Deepti Daharwar -  Web Application development in 2 and 3 Tier Architecture
  14. Neha Giri  -  Servlet
  15. Poonam Singh -  Jar File
  16. Swati -   Java Beans
  17. Vinita - Security issues when dealing with RMI
-----------------------------------------------------------------------------------------------------------------------

3. Practical List 

First Date: Practical# 1 to 15 should be completed before on 19/09/2014
Second Date:  Practical#  15 to 30 should be completed before on 30/09/2014



       1.       Write a HTML program to display Hello Aloysius in the web browser.
       2.       Write an HTML code to create following table
Name
Father’s Name
DOB
Address
College
















3.       Write a program to using Marquee Tag displaying name of college for H1 to H6 size of tag.
      4.       Write a Java Script program to   get the window status.
      5.       Write a Java script program to print the hostname of the site.
      6.       Write a Java script program to detect the browser name.
      7.       Write a program of Fibonacci series using for loop in java script.
      8.       Write an HTML code to window handle window alert
a)      Alert    b) confirm           c) prompt
      9.       Write a program to reverse the given string using java script.
      10.   Write a program to check whether the given number is  prime or composite number java script.
      11.   Write a program to check whether the given string/number is palindrome or not using java script.
      12.    Write a program to count the characters of given string using java script.
      13.   Write a program to display the day of the week as per given input using Java Script.
      14.   Write a program to greet you with your name using date and get hours methods.

      15.   Write  a program using Array and Switch statement for displaying the day of week according the choice of user. Sunday should be display for 1, Monday for 2 and so on.



      16 Write a JavaScript program to calculate multiplication and division of two numbers (input from user). 




17. Write a JavaScript program which compute, the average marks of the following students Then, this average is used to determine the corresponding grade. 
Student NameMarks
David80
Vinoth77
Divya88
Ishitha95
Thomas68
The grades are computed as follows :
RangeGrade
<60F
<70D
<80C
<90B
<100A













18. Write a JavaScript function that generates all combinations of a string. 
Example string : 'dog' 
Expected Output : d,do,dog,o,og,g 


      19.   Write a pattern that matches e-mail addresses.  The personal information part contains the         following ASCII characters.
      ·    Uppercase (A-Z) and lowercase (a-z) English letters.
      ·    Digits (0-9).
      ·    Characters ! # $ % & ' * + - / = ? ^ _ ` { | } ~
      ·    Character. ( period, dot or fullstop) provided that it is not the first or last character and it will not come one after the other.

 20.   Write a JavaScript function that takes the value in the text input and converts it from pound to             kg and kg to pound . 
             The conversion factor from pounds to kilograms is 0.45359237, and from kilograms to pounds is         2.20462262.
        Sample HTML Screen :
              


        21.  Write a JavaScript program to draw the following rectangular shape. 

          


         Hint to Program: getContext, fillRect

          22.  Write a JavaScript program to draw a Triangle.
      

    Hint to Program:  beginPath(),moveTo

          23.  Write a JavaScript program to draw two intersecting rectangles, one of which has alpha             transparency. 
     



   Hint to Program: FillRect, FillStyle1.   


24. Draw the Following




25.  Write a  Java Script Program Using onchange event.

26.  Write a Java Script Program using onblure event.

27.  Write a Java Script Program using document.write .

28.  Write a Java Script Program using document.writeln .

29.  Write a Java Script Program using Radio  button.


30.  Write a Java Script Program for Checkbox object.


31.  "Port Occupied" Error comes when oracle and glassfish server 3(NetBeans IDE during the installation) install on the same port, write the step how to remove the this error.

32.  Write a servelet Program to say Hello World.

33.  Create Table name as Student in Access Database with following columns
       std_id, std_name, std_add insert data using JDBC Connectivity in the student tables servelet

        1    Anil                Jabalpur
        2    Kumar           Adhartal
        3.   Arvind           Sadar
        4.   Narendra       Ranji
        5.   Suresh           Medical

34.  In Student table has five record update the name Suresh to Anamika  using JDBC connectivity procedure servelet.

35.  Delete students from the student table whose id are 4 and 5 using JDBC connectivity servelet
.
36.  Fetch and display (Extract) all the data from student table using JDBC connectivity servelet.

37.  Create Table name as Student in Oracle  Database with following columns
       std_id, std_name, std_add
insert data using JDBC Connectivity in the student tables servelet

        1    Anil                Jabalpur
        2    Kumar           Adhartal
        3.   Arvind           Sadar
        4.   Narendra       Ranji
        5.   Suresh           Medical

38.   In Student table has five record update the name Suresh to Anamika  using JDBC connectivity procedure servlet using oracle database.

39.  Delete students from the student table whose id are 4 and 5 using JDBC connectivity servelet using oracle database..

40.  Fetch and display (Extract) all the data from student table using JDBC connectivity servelet using oracle database.

41. WAP to in Java Servlet to display following information             

            1.      Cookies information
            2.      Name of Method
            3.      Query String
            4.      Request URL details
            5.      Name of the protocol in tabular form.

42. WAP in JSP and Servlet. JSP Page will accept values from the user, transfer these values as a parameter and display to servlet page. Values are Name, Age, Address, Gender, MobileNo


43.  WAP in JSP and Servlet. JSP Page will accept values from the user, transfer these values as a parameter and display to servlet page. Values are Name, Age, Address, Gender, MobileNo and insert into these values in oracle database table name student_det. 

44.  WAP in Servlet to set the Cookies from the browser.

45.  WAP in Servlet to get the Cookies from the browser.

46.  WAP in Java to Create Remote Interface for RMI.

47.  WAP in Java to Create and Run the server application.

48.  WAP in Java to Create and Run the Client application. 

49. Write a Program in JSP to Print Hello.

50. Write a Program in

Link: http://www.javatpoint.com/RMI


---------------------------------------------------------------------------------------------------------------------

Advance Research Topic

1. Ku. Khushboo Agarwal 
Research Paper Title: JAZZ - An Efficient Compressed Format for Java Archive Files
PPT Link: https://drive.google.com/file/d/0B8jRSAwhk8_yd0c4bDRTM25RZXM/edit?usp=sharing
Link: https://drive.google.com/file/d/0B8jRSAwhk8_yc3U3OHhuWFJobFE/edit?usp=sharing

2. Ku. Priya Gupta 
Research Paper Title: Java Bean
PPT Link: Java Bean PPT Priya

---------------------------------------------------------------------------------------------------------------------
Preliminary Exam Results 
Subject: Advance Java 
Date: 18/10/2014

Shipra Chourasiya    - 32
Neelam Chourasiya   - 30
Khusboo Agarwal     - 30
Priya Gupta               - Absent
Rachana Tiwari        - 15
Vidhi Chawala           - 27
Poonam Rawat          -  20
Ritu Gupta                - 12
Shraddha Verma      - 20
Priyanka Kumari     - 18
Shweta Jain              - 20
Deepti Daharal         - 24
Swati Rajak              - 26
Shilpa Vadnekar      - 14

------------------------------------------------------------------------------------------------------------------
 Java Advance  Internal Marks
  1. Priya  Gupta  -  9
  2. Khushbu Agwarwal - 9
  3. Priyanka  - 8
  4. Poonam - 8
  5. Shweta Jain  - 8
  6. Ritu Gupta - 8
  7. Rachna Tiwari - 8
  8. Vidhi Chawla - 8
  9. Shilpa Vadnekar  - 7
  10. Shradha  Verma - 8
  11. Neelam Chourasiya - 9
  12. Shipra Chourasiya - 9 
  13. Deepti Daharwar - 8
  14. Neha Giri  - 9
  15. Poonam Singh -  8
  16. Swati  Rajak - 8
  17. Vinit Shrivastava - 7





Sunday, July 27, 2014

BCA - V (2014-15) ( PPT Given by Students)


1. Sample PPT By Manish Tiwari ( Teacher)
Title: Sample
Link: https://drive.google.com/file/d/0B8jRSAwhk8_yQ1puTDY1b2RyQ3M/edit?usp=sharing

Title: How to Make an effective Power Point Presentation
Link: http://www.speakingaboutpresenting.com/design/powerpoint-design-recommended-tips/

Title: Slide Share for  an effective Power Point Presentation
Link:  http://www.slideshare.net/vmargutti/how-to-prepare-a-ppt-presentation

2. Unit - 1:  PPT by Anshita and Group: 
Title: Evaluation and Objective of Data Warehouse
Link: https://drive.google.com/file/d/0B8jRSAwhk8_ycHItd3dvUHA1MWM/edit?usp=sharing


3. Unit - 1: PPT by Saurabh Mani and Group: 
Title: Meta Data and It's Type
Link: https://drive.google.com/file/d/0B8jRSAwhk8_yNWRzT0ZGcUdpaWc/edit?usp=sharing


4.  Unit - II: PPT by Merlin Robert, Shruti Dhagat on 23/08/2014
Title:  ER Diagram Model Vs Dimensional Model 
Link: https://drive.google.com/file/d/0B8jRSAwhk8_yVXNHbmFsNndWUm8/edit?usp=sharing

Comments By Manish Tiwari(Subject Teacher) 
1. Matter or Content was not Justified/Margins should be adjusted.
2. PPT Template should be same for pages.
3. During the presentation eye contact were lost.
4. Conclusion PPT is not included.
Question (Discussion): 
1. What is entity?
2. What is Data Dependency?


5. Unit - II: PPT by Anita Sittam, Ishpreet Kaur, Nikit Kesarwani  on 
Title: Data Granularity
Link: https://drive.google.com/file/d/0B8jRSAwhk8_yczJNQTJkSjZpcGs/edit?usp=sharing

Question By students:
Q.1 Finer Granularity example was not clear re-explanation required?
    Question By: Devender Kumar
    Feedback: Satisfied by answer
Q.2 How to implement finer granularity in the dimention modeling?
    Question By: Devender Kumar
    Feedback: Satisfied by answer
Q.3 Re explanation of example given for definition of Data Granularity
    Question By: Sumit Dubey
    Feedback: Satisfied by answer
Q.4 Re-Explanation of point - where you put data in the lowest grain
    Question By: Mukul Pandey
    Feedback: Satisfied by answer
Question from the Audience:
Rahul Gupta:  Good
Nikhil Radhwal:  Bad
Depanshu Jain:  Average
Ishpal: Very Bad
Pooja Gupta: Average
 Comments By Manish Tiwari (Subject Teacher)
1. Conclusion is missing.
2. Data should be properly aligned.
3. Margin should be manage.
4. Textual content must be manged with justified alignment.
5. Dual Granularity should be included.

 6. Unit - II: PPT by Deepanshu Jai, Saurabh Mani, Pooja Gupta, Alisha Mansoori
    Title: Star Schema


Question By students:

 Comments By Manish Tiwari (Subject Teacher)
--------------------------------------------------------------------------------------------------------------------------
Preliminary Result Data Ware House
First Topper:     Pooja Gupta
Second Topper: Devendra Kumar
Third Topper:   Sourabh Mani

Neat and Clean Copy Award Goes To:
Pooja Gupta, Merlin Robert, Deepanshu Jain, Devendra Kumar

Maximum Mark for any question award Goes To: Devendra Kumar
Highest in Objective Question Award goes To: Mohit Soni, Pooja Gupta.

Pass: 10
Fail: 33

1. Anand Tiwar - 36
2. Anita Sittam - 24
3. Anshita Singh - 43
4. Ankit Bajpai - 29
5. Alisha Mansoori - 32
6. Aman Jain - 46
7. Deepti Shrivastava - 39
8. Chandra Prakash Pandey - 35
9. Deepanshu Jain - 57
10. Devendra Kumar - 71
11. Devendra Aswani - 26
12. Unname(30376) - 14
13. Ishpreet Kaur - 16
14. Ishpal Singh - 17
15. Jagrati Thakur - 30
16. Kiran Kushwaha - 25
17. Km Anjali - 39
18. Mohit Soni - 36
19. Merline Robert - 45
20. Mukul Pandey - 40
21. Nikhil Radhawal - 34
22. Namrata Sharma - 23
23. Nikita Kesharwani – 23
24, Pratyanch Rajput - 18
25. Praveen Pal - 26
26. Pooja Singh - 28
27. Pooja Singh - 28
28. Priya Gupta - 35
29. Pranjali Choudhari  - 25
30. Priyank Jain - 22
31. Pooja Gupta - 73
32. Rahul Gupta - 32
33. Reshu Kushwaha - 15
34. Rishabh Parochi - 25
35. Sushama Kushwaha - 30
36. Sumit Dubey - 48
37. Saurabh Mani – 68
38. Surbhi Gupta - 16
39. Sourabh Kashyap - 31
40. Somya Singh - 24
41. Shubham Jaiswal – 17
42. Shruti Dhagat - 53
43. Zareena Khatoon – 46

-----------------------------------------------------------------------------------------------------------------
                                                                       CCE Marks

Anand  PrakashTiwari  - 13
Anita Sittam    -  15
Anshita Singh  - 15
Ankit Bajpai     - Absent
Alisha Mansoori – 18
Aman Jain          -  15
Deepti Shrivastava      - 17
Chandra Prakash Pandey – 17
Deepanshu Jain    - 18
Devendra Kumar  - 18
Devendra Aswani - 12

Ishpreet Kaur – 16
Ishpal Singh – 14
Jagrati Thakur – 13
Kiran Kushwaha - 14
Km Anjali – 12
Mohit Soni – 15
Merline Robert – 18
Mukul Pandey – 17
Nikhil Radhawal – 15
Namrata Sharma – 14
Nikita Kesharwani – 17
Pratyanch Rajput -  10
Praveen Pal – 14

Pooja Singh - 13
Priya Gupta - 14
Pranjali Choudhari  - 13
Priyank Jain – 15
Pooja Gupta – 18
Rahul Gupta – 15
Reshu Kushwaha - 15
Rishabh Parochi – 14
Sushama Kushwaha - 14
Sumit Dubey – 16
Saurabh Mani – 18
Surbhi Gupta – 13
Sourabh Kashyap -15
Somya Singh –  15
Shubham Jaiswal – 12
Shruti Dhagat –  17
Zareena Khatoon – 17
Surabhi Rajak - 13
Kiran Manjhi - 14



Financial Year Oracle PLSQL Program

 CREATE OR REPLACE function FINANCIAL_YEAR(p_date DATE) return varchar2 IS    v_first     varchar2(4);    v_second    varchar2(4);    v_year...