Introduction to Database System

• A database is a collection of related data.
• By data,we mean known facts that can be recorded and that have implicit meaning.
• A database can be of any size and complexity. For example, the list of names and
  addresses referred to earlier may consist of only a few hundred records, each with a
  simple structure.

A database has the following implicit properties:

• A database represents some aspect of the real world, sometimes called the miniworld or the universe of discourse (UoD). Changes to the miniworld are reflected in the database.
• A database is a logically coherent collection of data with some inherent meaning. A random assortment of data cannot correctly be referred to as a database.
• A database is designed, built, and populated with data for a specific purpose. It has an intended group of users and some preconceived applications in which these users are interested.
  

An example of a large commercial database is Amazon.com

It contains data for over 20 million books, CDs, videos, DVDs, games, electronics, apparel, and other items. The database occupies over 2 terabytes (a terabyte is 1012 bytes worth of storage)
and is stored on 200 different computers (called servers). About 15 million visitors
access Amazon.com each day and use the database to make purchases. The
database is continually updated as new books and other items are added to the
inventory and stock quantities are updated as purchases are transacted. About 100
people are responsible for keeping the Amazon database up-to-date.

A database management system (DBMS)

A database management system (DBMS) is a collection of programs that enables
users to create and maintain a database. The DBMS is a general-purpose software system
that facilitates the processes of defining, constructing, manipulating, and sharing
databases among various users and applications.

• Defining a database involves specifying
  the data types, structures, and constraints of the data to be stored in the database.
• Constructing the database is the process of storing the data on some storage medium that is controlled
  by the DBMS.
• Manipulating a database includes functions such as querying
  the database to retrieve specific data, updating the database to reflect changes in the
  miniworld, and generating reports from the data.
• Sharing a database allows multiple users and programs to access the database simultaneously.

Other important functions provided by the DBMS include protecting the database
and maintaining it over a long period of time. Protection includes system protection
against hardware or software malfunction (or crashes) and security protection
against unauthorized or malicious access. A typical large database may have a life
cycle of many years, so the DBMS must be able to maintain the database system by
allowing the system to evolve as requirements change over time.
we will call the database and DBMS software together a database system.

eBook | ANDROID WIRELESS APPLICATION DEVELOPMENT Free Download

Book introduction

In GTU MCA sem 5 syllabus, ANDROID WIRELESS APPLICATION DEVELOPMENT is main text book.
Auther :: Lauren Darcey and Shane Conder,
Publication ::Pearson Education :: 2nd (2011

)

Features

• Covers application design, development, debugging, packaging, distribution, and much more
• Includes invaluable real-world tips from experienced mobile developers
• This book covers multiple Android SDK versions, which is how developers must work with Android

Buy Online at Discounted price

Download eBook Free !

Free download Adnroid ebook(pdf).
Here is Link to Download it free >> http://bit.ly/ANDROIDbook
Share it with your friends

Acknowlegement

Thank you for sending this ebook, we are glad to post it here. if you want to send such useful free materials to us email at: iamlearninghere@yahoo.com plz mention name with your email so we can display it with post.

eBook | Fundamentals of Database System Free Download

MCA sem-5 is started, Hope all of you are enjoying the final year of GTU MCA( hope so!! ). Well in my life of study , thing i hate most is Books price. so much expensive is this!!

In Sem-5 i have choose ADBMS as elective subject, of course it is threory subject, hvae to go for book. So i visited popular online shoopping site Flipkart.com.and Infibeam.com

Price of Book online ::

"Fundamentals of Database Systems”,Pearson Education, 5th Edition = Rs. 450 +
( Buy from Infibeam.com )

“Oracle 9i, DBA Handbook”, Oracle Press, TMGH Publications = Rs. 470 +

 if you can afford this books, its best to buy but id you can't afford this than don' worry.

we are here to give you free ebook(pdf) of this two ADBMS books,
free ebook(pdf) download of Fundamentals of Database Systems”,Pearson Education, 5th Edition and 
Oracle 9i, DBA Handbook

Download from here ::

First textbook      >> Download
Second textbook >> Download (this is 10G edition but theory same)

Note::
Price is seen on posting time that may change time to time,so refer website for latest price.

Thank You so much for our anonymous reader who shared a ebooks link with us.

(For Beginner) How to Setup Android App Development Tools Video Tutorials

In this lesson you will learn:

-Installing Eclipse
-Set up the link to the ADT
-Setting up the SDK and different android platforms
-Setting up the AVD

Download links:
Eclipse: http://www.eclipse.org/downloads/
Android SDK: http://developer.android.com/sdk/inde...
Android ADT: http://developer.android.com/sdk/ecli...

Additional help link: http://developer.android.com/sdk/inst...


source : mybringback.com

16. Assume that the information regarding the marks for all the subjects of a student in the last exam are available in a database, Develop a Servlet which takes the enrollment number of a student as a request parameter and displays the marksheet for the student.

WTAD Practical - 16
Assume that the information regarding the marks for all the subjects of a student in
the last exam are available in a database, Develop a Servlet which takes the
enrollment number of a student as a request parameter and displays the marksheet for the student.
index.html

<HTML>
<HEAD>
<TITLE>WTAD.practical-16 @iAmLearningHere </TITLE>

</HEAD>
<BODY bgcolor="YellowGreen">
<h3> Result  </h3>
<hr>
<form name="frm1" action="display">
Enter Enrolment No :: <input type="text" name="en"> 
<input type="submit" Value="Get Result"">
</form>
</BODY>
</HTML>

15. Assume that we have got three pdf files for the MCA-1 Syllabus, MCA-2 Syllabus and MCA-3 Syllabus respectively, Now write a Servlet which displays the appropriate PDF file to the client, by looking at a request parameter for the year (1, 2 or 3).

WTAD Practical - 15
Write a Servlet to display parameters available on request.
index.html

<HTML>
<HEAD>
<TITLE>WTAD.practical-15 @iAmLearningHere </TITLE>
</HEAD>
<BODY bgcolor="YellowGreen">
<h3>DISPLAY Syllabus in pdf</h3>
<hr>
<form name="f1" action="display" method="get" >
MCA-1<br>
MCA-2<br>
MCA-3<br>
<input type="text" name="MCA" value="" />
<input type="submit" value="Show Syllabus" />
</form>
</BODY>
</HTML>

14. Write a Servlet which displays a message and also displays how many times the message has been displayed (how many times the page has been visited).

WTAD Practical - 14
Write a Servlet which displays a message and also displays how many times the
message has been displayed (how many times the page has been visited).
WEB-INF/web.xml

<web-app>
<servlet>
<servlet-name>s14</servlet-name>
<servlet-class>VisitCount</servlet-class>
</servlet>
<!-- Servlet Mapping -->
<servlet-mapping>
<servlet-name>s14</servlet-name>
<url-pattern>/visit</url-pattern>
</servlet-mapping>
</web-app>

12. Write a Servlet to display parameters available on request.

WTAD Practical - 12
Write a Servlet to display parameters available on request.
index.html

<HTML>
<HEAD>
<TITLE>WTAD.practical-12 @iAmLearningHere </TITLE>
</HEAD>
<BODY bgcolor="YellowGreen">
<h3>Display parameters available on request.</h3>
<hr>
<form name="f1" action="display" method="get" >
<!-- Enter Three Parameters Here -->
Source Name:<input type="text" name="nm"/><br />
Subject 1 &nbsp;&nbsp;&nbsp; : <input type="text" name="sub1" /><br />
Subject 2 &nbsp;&nbsp;&nbsp; : <input type="text" name="sub2" /><br />

<input type="submit" value="Send Parameters" />
</form>
</BODY>
</HTML>

11. Write a Servlet to display all the headers available from request.

WTAD Practical - 11
Write a Servlet to display all the headers available from request.
WEB-INF/web.xml

<web-app>
<servlet>
<servlet-name>s11</servlet-name>
<servlet-class>RequestHeaders</servlet-class>
</servlet>
<!-- Servlet Mapping -->
<servlet-mapping>
<servlet-name>s11</servlet-name>
<url-pattern>/requestheaders</url-pattern>
</servlet-mapping>
</web-app>

10.Write a Servlet to display “Hello World” on browser.

WTAD Practical - 10
Write a Servlet to display “Hello World” on browser.
WEB-INF/web.xml

<web-app>
<servlet>
<servlet-name>s10</servlet-name>
<servlet-class>Hello</servlet-class>
</servlet>
<!-- Servlet Mapping -->
<servlet-mapping>
<servlet-name>s10</servlet-name>
<url-pattern>/hello</url-pattern>
</servlet-mapping>
</web-app>

9. Write a JavaScript to show a pop up window with a message Hello and background color lime and with solid black border.

WTAD Practical - 9
Write a JavaScript to show a pop up window with a message Hello and background
color lime and with solid black border.

<HTML>
<html>
<HEAD>
<TITLE>WTAD.practical-9 @iAmLearningHere </TITLE>
</HEAD>
<body bgcolor="YellowGreen">
    <form name="f1">
            <input type="button" value="Pop Up"    onclick="window.open('w1.html','PopUpWindow','width=2s00',
            'height=50')">
    </form>
</body>
</HTML>

8. Write a JavaScript to find a string from the given text. If the match is found then replace it with another string.

WTAD Practical - 8
Write a JavaScript to find a string from the given text. If the match is found then
replace it with another string.

<HTML>
<html>
<HEAD>
<TITLE>WTAD.practical-8 @iAmLearningHere </TITLE>
</HEAD>
<body bgcolor="YellowGreen">
        <font size="4">
        <script language="javascript" type="text/javascript">
        var c = prompt("Enter Text :");
        var searchtxt = prompt("Enter Search Text :");
        document.write("<br>Text is :: " + c );
        document.write("<br>Search text is :: " + searchtxt);
        var r = new RegExp(searchtxt);
        if ( c.search() == -1)
        {
            alert("Match Not Found");
            var searchtxt = prompt("Enter Search Text Again:");
        }
        else
        {
            alert("Match Found !");
            var rtext = prompt("Enter  Text To replace With:");
            document.write("<br>Replace text is :: " + rtext);
            document.write("<br>Replaced Text :: " + c.replace(r,rtext));
        }
    </script>
    </body>
</HTML>

7. Write a JavaScript to convert Celsius to Fahrenheit.

WTAD Practical - 7
Write a JavaScript to generate two random numbers and find out maximum and
minimum out of it.

<HTML>
<html>
<HEAD>
<TITLE>WTAD.practical-7 @iAmLearningHere </TITLE>
</HEAD>
<body bgcolor="YellowGreen">
        <center><font size=5>
        <script language="JavaScript">
            var a,b;
            a=parseFloat(prompt("enter the Celsius:",""));
            document.write("Celsius value is: "+a+"<br><br>");
            b=32+(a*1.8);
            alert("Celsius to Fehrenheit "+b);
            document.write("Fehrenheit value is: "+b);
        </script>
    </body>
</HTML>

6. Write a JavaScript to remove the highest element from the array and arrange the array in ascending order.

WTAD Practical - 6
 Write a JavaScript to remove the highest element from the array and arrange the array in ascending order.

<HTML>
<html>
<HEAD>
<TITLE>WTAD.practical-6 @iAmLearningHere </TITLE>
</HEAD>
<BODY bgcolor="YellowGreen">
    <script language="JavaScript">
            var i,size,j,temp;
            var arr=new Array();
            size=parseInt(prompt("enter the size of array",""));
            for(i=0;i<size;i++)
            {
                arr[i]=parseInt(prompt("enter the element of array",""));
            }
            document.write("array is:-<br>");
            for(i=0;i<size;i++)
            {
                document.write(arr[i]+", ");
            }
            for(i=0;i<size;i++)
            {
                for(j=i+1;j<size;j++)
                {
                    if(arr[i]>arr[j])
                    {
                        temp=arr[i];
                        arr[i]=arr[j];
                        arr[j]=temp;
                    }
                }
            }
            document.write("<br><br>sorted array is:-<br>");
            for(i=0;i<size;i++)
            {
                document.write( arr[i] + ", ");
            }
            document.write("<br><br>after delete large element array is:-<br>");
            arr.pop();
            for(i=0;i<arr.length;i++)
            {
                document.write(arr[i]+", ");
            }
        </script>
</BODY>
</HTML>

MCA sem - 4 Summer Examination - 2013

MCA sem - 4 summer examination time table is out now, It's Starting from 21st May,13.

Download TimeTable here

This time table is gives relief because GTU has given 1-2 days gap between each paper, this will be beneficial for students. Start your preparation for the exams.

All the best to all the students
Keep Learning

 >> All MCA sem 1 to 5 summer 2013 exam time table link << 

5. Write a JavaScript to generate two random numbers and find out maximum and minimum out of it.

WTAD Practical - 5
Write a JavaScript to generate two random numbers and find out maximum and
minimum out of it.

<HTML>
<HEAD>
<TITLE>WTAD.practical-5 @iAmLearningHere </TITLE>
</HEAD>

<script type="text/javascript">
    function calculateRandom()
    {
        var r1=Math.floor(Math.random()*100);
        var r2=Math.floor(Math.random()*100);
        document.write('<br>Random No.1 : ' + r1);
        document.write('<br>Random No.2 : ' + r2);
        if (r1 < r2)
        {
            document.write('<br><br>Minimum No.:' + r1);
            document.write('<br>Maximum No.:' + r2);
        }
        else
        {
            document.write('<br><br>Minimum No.:' + r2);
            document.write('<br>Maximum No.:' + r1);
        }
    }
</script>

4. Write a JavaScript that finds out multiples of 10 in 0 to 10000. On the click of button start the timer and stop the counter after 10 seconds. Display on the screen how many multiples of 10 are found out within stipulated time.

WTAD Practical-4
Write a JavaScript that finds out multiples of 10 in 0 to 10000. On the click of button
start the timer and stop the counter after 10 seconds. Display on the screen how
many multiples of 10 are found out within stipulated time.

<HTML>
<HEAD>
<TITLE>WTAD.practical-4 @iAmLearningHere </TITLE>
</HEAD>

<script type="text/javascript">
    function start()
    {
        setTimeout("displayMultiple()", 10000); // time in millisecond
    }

    function displayMultiple()  
    {
        var i = 1;
        document.write(" [ ");
        for(i=1; i<=10000; i++)
        {
            if(i%10==0 )
                document.write(i + ' , ');
        }
        document.write(" ] ");
    }
</script>

3. Create a Form in HTML with two fields, minimum and maximum, write JavaScript to validate that only numeric value is entered in both, and the value entered in minimum is less than the value entered in maximum.

WTAD Practicals :

Create a Form in HTML with two fields, minimum and maximum, write JavaScript
to validate that only numeric value is entered in both, and the value entered in
minimum is less than the value entered in maximum.

<HTML>
<HEAD>
<TITLE>WTAD.practical-3 @iAmLearningHere </TITLE>
</HEAD>
<BODY>
<script type="text/javascript">
    function isValidNum(num)
    {
        if(isNaN(num.value))
            alert("plz enter valid number!!");
        num.focus();
    }
  
    function check()
    {
        var num1 = document.getElementsByName("txtmin")[0].value;
        var num2 = document.getElementsByName("txtmax")[0].value;
        if( num1 < num2 )
            document.getElementById("msg").innerHTML=" Minimum is less than Maximum. OK!";
        else
            document.getElementById("msg").innerHTML="Wrong Entry!!";       
    }
</script>

2. Write a JavaScript that demonstrates the use of +=,-=,*=,/= operators.

WTAD Practical-2
Write a JavaScript that demonstrates the use of +=,-=,*=,/= operators.

<HTML>
<HEAD>
<TITLE>WTAD.practical-2 @iAmLearningHere </TITLE>
</HEAD>
<BODY>
<H2>Demonstration the use of +=,-=,*=,/= operators.</H2>
<H3>
<script type="text/javascript">

    var i = 11;
    document.write("<br> i = " + i);
    i += 10;
    document.write("<br>( i +=10 ) =>" + i);
    i *= 10;
    document.write("<br>( i *=10 ) =>" + i);
    i -= 10;
    document.write("<br>( i -=10 ) =>" + i);
    i /= 10;
    document.write("<br>( i /=10 ) =>" + i);
</script>

1. Write a JavaScript that shows how a variable’s type can be changed on-the-fly.

WTAD Practical -1 :
Write a JavaScript that shows how a variable’s type can be changed on-the-fly.

<HTML>
<HEAD>
<TITLE>WTAD.practical-1 @iAmLearningHere </TITLE>
</HEAD>
<BODY>

<H4>See the Variable Type is changing .. !!</H4>
<script type="text/javascript">
    var p1 = 11;
    document.write("<br>p1 contains ::"+ p1 +" of Type :: "+ typeof(p1) +"<br>");
    p1 = 11.1;
    document.write("<br>p1 contains ::"+ p1 +" of Type :: "+ typeof(p1)+"<br>");
    p1 = 'i';
    document.write("<br>p1 contains ::"+ p1 +" of Type :: "+typeof(p1)+"<br>");
    p1 = true;
    document.write("<br>p1 contains ::"+ p1 +" of Type :: "+typeof(p1)+"<br>");
    p1 = "iamlearninghere";
    document.write("<br>p1 contains ::"+ p1 +" of Type :: "+typeof(p1)+"<br>");

</script>

FON- What is OSI Model? from basics

In Fundamental of Networking, OSI is basic model to start with Computer Networking.
Here we found one Video which gives you idea about What is OSI model?

Topic is nicely explained in Hindi so most of us easily understands concept of OSI. try to understand the concepts.



Here is Video

We have not created this video.. All credit of this video goes to http://computerseekho.com . we have just shared with you.

post your feedback in comments, are you comfortable with the language of this video??

want more videos or material of FON??



Computer Networks PPTs downloads

Computer Networks ( oxford ) is a main book for MCA sem 4 students. its a new book written by Bhushan Trivedi (Director, MCA programme, at GLSICT ).

Books is very good ( No doubt on that !) because the book gives overview of data communications before plunging into the depths of networks.

Reading a book first time is good to understand concepts but Power Point Slide is best way to revise all content of book at last time. here we are with ppts of this books contains all chapters points. easy for quick review.


Select Chapter to see ppts online and downloads :: 


Chapter 1. Introduction to Computer Networks

Chapter 2. Network Fundamentals

Chapter 3. Data Communication Fundamentals

Chapter 4. The Physical Layer

Chapter 5. The Data Link Layer

Chapter 6. The Medium Access Sublayer

Chapter 7. The Network Layer

Chapter 8. The Transport Layer

Chapter 9. The Application Layer



To get all this ppts and more in your mail.

By Submitting your email address below: we will send you email.(No Advertisements )

Java and C

Java is derived from C. many of its syntactic characteristics are similar to C.
However, There are some huge differences

(1). Relational operators
Relational Operator works the same way but returns different results:
>, >=, =, <=, <, ==, != 
In Java, they returns true and false
In C/C++, they returns 1 or 0 
In C/C++,              a value of zero means false.              any value that is not zero means true ( <<very important )

(2). unary operator

The following unary operators are available C/C++ but not in Java

~                 invert the bits of a word

*                  pointer dereference

&                 pointer creation

(type)           cast (i.e., forceable type conversion)

sizeof           # of bytes in operand or data type

->                 pointer dereference with field selection

(3).  No goto statement
Java doesn't support a goto statement. Use of goto except in certain well-defined circumstances is regarded as poor programming practice. Java adds exception handling and labeled break and continue statements to the flow-control statements offered by C. These are a good substitute for goto.

(4). Command-line Argument
args[ 0 ] is first argument supplied (in Java !)
args[ 0 ] is program name (in C !) 
 

(5). Default values

in C , All Variables deault contains garbage value but in Java it has default values.

Variable Type	Default Value
Object reference	null
byte, short, int, long	0
float, double	0.0
boolean	false
char	'\u0000'

(6).Variable declarations anywhere
C requires local variable declarations to be made at the beginning of a method or block, while Java allows them anywhere in a method or block.

(7).Forward references
The Java compiler is smarter than the C compiler, in that it allows methods to be invoked before they are defined. This eliminates the need to declare functions in a header file before defining them in a program file, as is done in C.

(8). Method overloading
Java programs can define multiple methods with the same name, as long as the methods have different parameter lists.

(9).No global variables

Java defines a very clean namespace. Packages contain classes, classes contain fields and methods, and methods contain local variables. But there are no global variables in Java, and, thus, there is no possibility of namespace collisions among those variables.


For More detailed difference ::
http://wiki.answers.com/Q/What_is_the_difference_between_Java_and_the_C_programming_language
http://www.durofy.com/programming/10-major-differences-between-c-and-java/