Programming Language–III (3415)-solved Assignment-old papers-course outline -aiou-spring 2015

<div dir="ltr" style="text-align: left;" trbidi="on"> <div align="center" class="western" lang="en-GB" style="line-height: 0.21in; margin-bottom: 0in;"> </div> <h2 style="text-align: left;"> <span style="color: red;">Solved Assighnments</span></h2> <div style="text-align: left;"> </div> <h2 align="center" class="western"> <span style="color: #990000;"><span style="font-size: x-large;"><span style="letter-spacing: -0.3pt;"> </span></span></span></h2> <h2 align="center" class="western"> <span style="color: #990000;"><span style="font-size: x-large;"><span style="letter-spacing: -0.3pt;"> </span></span></span></h2> <h2 align="center" class="western"> <span style="color: #990000;"><span style="font-size: x-large;"><span style="letter-spacing: -0.3pt;"> </span></span></span></h2> <h2 align="center" class="western"> <span style="color: #990000;"><span style="font-size: x-large;"><span style="letter-spacing: -0.3pt;"> </span></span></span></h2> <h2 align="center" class="western">   <span style="color: #990000;"><span style="font-size: x-large;"><span style="letter-spacing: -0.3pt;">Course:</span></span></span><span style="color: #660000;"><span style="font-size: x-large;"><span lang="en-GB"><b> Programming Language–III (3415)</b></span></span></span></h2> <h2 class="western"> Level: B.S (CS) Semester: Autumn- 2015</h2> <h2 class="western"> Total Marks: 100 Pass Marks: 50</h2> <br /> <br /> <table cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: left; text-align: left;"><tbody></tbody></table>   <br /> <br /> <div align="center" class="western" lang="en-GB" style="line-height: 0.21in; margin-bottom: 0in;"> <br /></div> <div align="center" class="western" lang="en-GB" style="line-height: 0.21in; margin-bottom: 0in;"> <span style="font-size: medium;"><b>ALLAMA IQBAL OPEN UNIVERSITY, ISLAMABAD</b></span></div> <div align="center" class="western" lang="en-GB" style="line-height: 100%; margin-bottom: 0in;"> <i><b>(Department of Computer Science)</b></i></div> <div align="center" class="western" lang="en-GB" style="line-height: 100%; margin-bottom: 0in;"> <br /></div> <div align="justify" class="western" lang="en-GB" style="line-height: 100%; margin-bottom: 0in;"> </div> <div align="center" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.37in; text-indent: -0.31in;"> <span style="font-size: medium;"><b>WARNING</b></span></div> <ol> <li> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-right: 0.13in;"> <span style="font-size: x-small;"><b>PLAGIARISM OR HIRING OF GHOST WRITER(S) FOR SOLVING THE ASSIGNMENT(S) WILL DEBAR THE STUDENT FROM AWARD OF DEGREE/CERTIFICATE, IF FOUND AT ANY STAGE.</b></span></div> </li> <li> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-right: 0.13in;"> <span style="font-size: x-small;"><b>SUBMITTING ASSIGNMENTS BORROWED OR STOLEN FROM OTHER(S) AS ONE’S OWN WILL BE PENALIZED AS DEFINED IN “AIOU PLAGIARISM POLICY”.</b></span></div> </li> </ol> <div align="center" class="western" lang="en-GB" style="line-height: 100%; margin-bottom: 0in;"> <br /></div> <div align="center" class="western" lang="en-GB" style="line-height: 100%; margin-bottom: 0in;"> <br /></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in;"> <span style="font-size: x-small;"><span lang="en-GB"><b>Course: Programming Language–III (3415) Semester: Autumn, 2015</b></span></span></div> <div align="justify" class="western" lang="en-GB" style="line-height: 100%; margin-bottom: 0in;"> <span style="font-size: x-small;"><b>Level: Bachelor Total Marks: 100</b></span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in;"> <span style="font-size: x-small;"><span lang="en-GB"><b> Pass Marks: 50</b></span></span></div> <div align="center" class="western" style="line-height: 100%; margin-bottom: 0in;"> <span style="font-size: medium;"><span lang="en-GB"><b>ASSIGNMENT No. 1</b></span></span></div> <div align="justify" class="western" lang="en-GB" style="line-height: 100%; margin-bottom: 0in;"> <span style="font-size: x-small;"><br /></span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in;"> <span style="font-size: x-small;"><i><b>Note: All questions carry equal marks.</b></i></span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: x-small;"><br /></span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: x-small;">Q. 1 (a<a href="http://searchsoa.techtarget.com/definition/Java" target="_blank">) Explain what a Javaapplication is</a>. Why we use comments in Java applications?</span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: x-small;"> (b) Define and explain the term <a href="https://en.wikipedia.org/wiki/Java_virtual_machine" target="_blank">JVM (Java Virtual Machine</a>).</span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: x-small;"> </span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: x-small;">Q. 2 (a) Why we say that<a href="https://www.researchgate.net/post/Why_we_say_that_java_is_pure_object_oriented_programming_language_while_c_is_not10" target="_blank"> Javais an object oriented languag</a>e?</span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: x-small;"> (b) <a href="http://stackoverflow.com/questions/3442387/difference-between-a-java-interpreter-and-jvm" target="_blank">Differentiate between JVMand an interpreter</a>.</span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: x-small;">Q. 3 (a) <a href="http://www.tutorialspoint.com/sql/sql-data-types.htm" target="_blank">What is a data type</a>? Write in detail the <a href="http://www.tutorialspoint.com/java/java_basic_datatypes.htm" target="_blank">data types used in Java language</a>.</span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: x-small;"> (b)<a href="http://stackoverflow.com/questions/1200621/declare-array-java" target="_blank"> How arrays are declaredand allocated in Java</a>? Also <a href="http://www.programmerinterview.com/index.php/java-questions/does-java-pass-by-reference-or-by-value/" target="_blank">explain the </a></span><span style="font-size: x-small;"><a href="http://stackoverflow.com/questions/4712798/how-to-use-references-in-java" target="_blank">references </a>and<a href="https://msdn.microsoft.com/en-us/library/aa645763%28v=vs.71%29.aspx" target="_blank"> referenceparameters </a>in Java.</span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.38in; text-indent: -0.38in;"> <span style="font-size: x-small;"> </span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.38in; text-indent: -0.38in;"> <span style="font-size: x-small;">Q. 4 The factorial of a nonnegative integer n is written n! (Pronounced “n factorial”) and is defined as follows:</span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: x-small;"> </span><span style="font-size: x-small;"><span style="letter-spacing: -0.2pt;">n! = n (n-1) (n-2)… 1 (for values of n greater than or equal to 1) and n! = 1 (for n = 0).</span></span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: x-small;"> For example, 5! = 5.4.3.2.1, which is 120.</span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: x-small;"> (a) <a href="http://educational-wealth.blogspot.com/2016/02/finding-factorial-of-number-program-java.html" target="_blank">Write an application thatreads a nonnegative integer from an input dialog and computes andprints its factorial.</a></span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: x-small;"> (b)<a href="http://educational-wealth.blogspot.com/2016/02/estimated-value-of-mathematical.html" target="_blank"> Write an application that estimates the value of the mathematical constant </a></span><a href="http://educational-wealth.blogspot.com/2016/02/estimated-value-of-mathematical.html" target="_blank">eby using the formula</a></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: x-small;"> </span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.38in; text-indent: -0.38in;"> <span style="font-size: x-small;"> </span></div> <div align="justify" class="western" style="line-height: 0.21in; margin-bottom: 0in; margin-left: 0.75in; text-indent: -0.75in;"> <a href="https://www.blogger.com/blogger.g?blogID=4540382126610807499" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a><a href="https://www.blogger.com/blogger.g?blogID=4540382126610807499" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a><a href="https://www.blogger.com/blogger.g?blogID=4540382126610807499" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a><span style="font-size: x-small;">Q. 5 Differentiate among the following:</span></div> <div align="justify" class="western" style="line-height: 0.21in; margin-bottom: 0in; margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: x-small;"> (a) <a href="https://en.wikipedia.org/wiki/Reference_%28C%2B%2B%29" target="_blank">References</a> and <a href="https://en.wikipedia.org/wiki/Parameter_%28computer_programming%29" target="_blank">referenceparameter</a></span></div> <div align="justify" class="western" style="line-height: 0.21in; margin-bottom: 0in; margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: x-small;"> (b) <a href="https://answers.yahoo.com/question/index?qid=20091216185619AAkDCJl" target="_blank">Single subscripted array</a> and <a href="http://www.cs.ucsb.edu/~cappello/courses/cs10/tutorial/5/9/1/F.html" target="_blank">multiple subscripted array</a>s</span></div> <div align="justify" class="western" style="line-height: 0.21in; margin-bottom: 0in; margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: x-small;"> (c) Third element of array and array element 3</span><br /> <span style="font-size: x-small;"> Ans: </span><br /> <span style="font-size: x-small;">Suppose you have an Array </span><br /> <span style="font-size: x-small;">Sring arr[] = {"html","css","java script"};</span><br /> <br /> <span style="font-size: x-small;">The third element of the array is "java script" but it's position would be fouind as [2] in the array. You are supposing it as 3, and that's why you are getting the errors. </span></div> <div align="justify" class="western" style="line-height: 0.21in; margin-bottom: 0in; margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: x-small;"> (d) <a href="http://www.javacoffeebreak.com/faq/faq0009.html" target="_blank">Applet and application</a></span></div> <div align="center" class="western" style="line-height: 100%; margin-bottom: 0in;"> <span style="font-size: x-small;"><br /></span></div> <div align="center" class="western" style="line-height: 100%; margin-bottom: 0in;"> <span style="font-size: x-small;"><b>ASSIGNMENT No. 2</b></span></div> <div class="separator" style="clear: both; text-align: center;"> </div> <div align="right" class="western" lang="en-GB" style="line-height: 100%; margin-bottom: 0in;"> <span style="font-size: x-small;"><b>Total Marks: 100</b></span></div> <div align="right" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: x-small;"><span lang="en-GB"><b> Pass Marks: 50</b></span></span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in;"> <span style="font-size: x-small;"><i><b>Note: All questions carry equal marks.</b></i></span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.75in; text-indent: -0.75in;"> <a href="http://www.artima.com/forums/flat.jsp?forum=1&thread=4002" target="_blank"><span style="font-size: x-small;"><br /></span></a></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: x-small;"><a href="http://www.artima.com/forums/flat.jsp?forum=1&thread=4002" target="_blank">Q. 1 (a) Discuss why casting asuper class reference to a subclass reference potentially dangerous</a>? </span> </div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: x-small;"> (b)<a href="https://docs.oracle.com/javase/tutorial/java/concepts/package.html" target="_blank"> What are packages inJava</a>? Briefly describe the <a href="https://en.wikipedia.org/wiki/List_of_Java_APIs" target="_blank">Java API packages.</a></span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.38in; text-indent: -0.38in;"> <span style="font-size: x-small;"><br /></span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.38in; text-indent: -0.38in;"> <span style="font-size: x-small;">Q. 2 Distinguish between <a href="https://docs.oracle.com/javase/tutorial/java/IandI/" target="_blank">inheriting interface</a> and <a href="http://c2.com/cgi/wiki?ImplementationInheritance" target="_blank">inheriting implementation</a>.<a href="http://www.coderanch.com/t/597570/java/java/Difference-Implementation-Inheritance-interface-inheriatance" target="_blank"> How doinheritance hierarchies designed for inheriting interface differ fromthose designed for inheriting implantation?</a></span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: x-small;"><br /></span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: x-small;">Q. 3 (a) Briefly describe the <a href="http://www.tutorialspoint.com/java/lang/java_lang_string.htm" target="_blank">constructors of class string</a>? Also write <a href="https://blog.udemy.com/java-string-class/" target="_blank">demonstrating of Stringclass constructors in Java</a>. </span> </div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: x-small;"> (b) <a href="http://Differentiate between abstract super class and concrete classes" target="_blank">Differentiate between abstract super class and concrete classes</a>.</span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.38in; text-indent: -0.38in;"> <span style="font-size: x-small;"><br /></span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.38in; text-indent: -0.38in;"> <span style="font-size: x-small;">Q. 4 <a href="https://en.wikipedia.org/wiki/Polymorphism_%28computer_science%29" target="_blank">What is polymorphism</a>? Describe with an example.</span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.38in; text-indent: -0.38in;"> <span style="font-size: x-small;"> </span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: x-small;">Q. 5 (a) <a href="http://www.homeandlearn.co.uk/java/java_inheritance.html" target="_blank">Write a program inJava having parent and child classes to demonstrate the concept ofinheritance.</a></span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: x-small;"> (b) <a href="http://educational-wealth.blogspot.com/2016/04/write-applet-that-displays-subhanaallah.html" target="_blank">Write an applet thatdisplays “SubhanaAllah and Subbakhair Fajir Time” if the currenttime is between 5 a.m. and 7 a.m., “Its Zuhr Prayer time” if thecurrent time is between 12 p.m and 3 p.m., and “SubhanaAllah itsMugrib Prayer Time” if the current time is between 5p.m. and 7 p.m.</a></span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: x-small;"> (c) <a href="http://educational-wealth.blogspot.com/2016/04/write-applet-that-contains-one-button.html" target="_blank">Write an applet thatcontains one button. Initialize the label on the button to “Start”.Toggle the button label between these two values each time the buttonis pressed.</a></span><br /> <span style="font-family: "monospaced" , "courier";"><b> </b></span></div> <div align="justify" class="western" style="border-color: -moz-use-text-color -moz-use-text-color rgb(0, 0, 0); border-style: none none solid; border-width: medium medium 1px; line-height: 100%; margin-bottom: 0in; margin-left: 0.75in; padding: 0in 0in 0.01in; text-indent: -0.75in;"> <span style="font-size: x-small;"><br /></span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in;"> <span style="font-size: x-small;"><br /></span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in;"> <span style="font-size: x-small;"><b>Programming Language–III (3415) Credit Hours: 4(3+1)</b></span></div> <div class="western" style="line-height: 100%; margin-bottom: 0in;"> <span style="font-size: x-small;"><br /></span></div> <div class="western" style="line-height: 100%; margin-bottom: 0in;"> <span style="font-size: x-small;"><i><b>Recommended Book: </b></i></span> </div> <div class="western" style="line-height: 100%; margin-bottom: 0in;"> <span style="font-size: x-small;"><i>JAVA, How to Program, By Deital & Deital 3</i></span><span style="font-size: x-small;">^{<span style="font-size: xx-small;"><i>rd</i></span>}<span style="font-size: xx-small;"><i> Edition </i></span></span> </div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.5in; text-indent: -0.5in;"> <span style="font-size: x-small;"><br /></span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.5in; text-indent: -0.5in;"> <span style="font-size: x-small;"><b>Course Outlines:</b></span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.5in; text-indent: -0.5in;"> <span style="font-size: x-small;"><b>Unit No. 1 Introduction to Java Applications</b></span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in;"> <span style="font-size: x-small;"> Introduction, Using Comments, Block of Codes, a Simple Java Program</span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.75in; text-indent: -0.38in;"> <span style="font-size: x-small;"><br /></span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in;"> <span style="font-size: x-small;"><b>Unit No. 2 Data Types & Arrays </b></span> </div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.88in; text-indent: -0.88in;"> <span style="font-size: x-small;"> Data Types, Declaring & Allocating Arrays, References and Reference Parameters Searching Arrays, Multiple Subscripted Arrays</span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in;"> <span style="font-size: x-small;"><br /></span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in;"> <span style="font-size: x-small;"><br /></span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in;"> <span style="font-size: x-small;"><br /></span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in;"> <span style="font-size: x-small;"><b>Unit No. 3 Control Structures-I</b></span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in;"> <span style="font-size: x-small;"> Selection Structure, While Repetition Structure</span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in;"> <span style="font-size: x-small;"><br /></span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in;"> <span style="font-size: x-small;"><b>Unit No. 4 Control Structures-II</b></span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.88in; text-indent: -0.88in;"> <span style="font-size: x-small;"><b> </b></span><span style="font-size: x-small;">For Repetition Structure, Do/While Repetition Structure, Break and Continue, Multiple Selection Structure</span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.88in; text-indent: -0.88in;"> <span style="font-size: x-small;"><br /></span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in;"> <span style="font-size: x-small;"><b>Unit No. 5 Object Oriented Programming-I</b></span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.88in; text-indent: -0.88in;"> <span style="font-size: x-small;"><b> </b></span><span style="font-size: x-small;">Introduction to Class, Class Scopes, Creating Packages, Constructors, Set & Get Method, This Reference, Finalizer, Static Class Member </span> </div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in;"> <span style="font-size: x-small;"><br /></span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in;"> <span style="font-size: x-small;"><b>Unit No. 6 Object Oriented Programming-II</b></span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.88in; text-indent: -0.88in;"> <span style="font-size: x-small;"><b> </b></span><span style="font-size: x-small;">Super Class, Sub Classes, Protected Members, Inheritance, Polymorphism, Dynamic Method Binding, Inner Class Definitions</span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.75in; text-indent: -0.38in;"> <span style="font-size: x-small;"><br /></span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in;"> <span style="font-size: x-small;"><b>Unit No. 7 Packages, Interfaces, and Exception Handling</b></span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.88in; text-indent: -0.88in;"> <span style="font-size: x-small;"> Defining a Package, Access Protection, Importing Packages, Interfaces Exception-Handling Fundamentals, Exception Types, Using Try & Catch, Java Built-In-Exceptions</span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.88in; text-indent: -0.5in;"> <span style="font-size: x-small;"><br /></span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in;"> <span style="font-size: x-small;"><b>Unit No. 8 Strings & Characters</b></span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.88in; text-indent: -0.88in;"> <span style="font-size: x-small;"><b> </b></span><span style="font-size: x-small;">String Constructors, String Comparing, String Methods, String Concatenating, String Classes, String Methods </span> </div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.88in; text-indent: -0.38in;"> <span style="font-size: x-small;"><br /></span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in;"> <span style="font-size: x-small;"><b>Unit No. 9 GUI</b></span></div> <div align="justify" class="western" style="line-height: 100%; margin-bottom: 0in; margin-left: 0.88in; text-indent: -0.88in;"> <span style="font-size: x-small;"> Graphics Context, Graphic Methods, Color and Font Control, Drawing Shapes, Java 2d API, Java 2d Shapes, Swing Overview, Jlable, Event Handling Model, Jbutton, Jtextfield, Jradiobutton, Jcheckbox, Jlist, Multiple Selection List, Mouse Event Handling, Keyboard Event Handling, Layout Managers</span></div> </div>

Programming Language–III (3415)-solved Assignment-old papers-course outline -aiou-spring 2015

Solved Assighnments           Course: Programming Language–III (3415) Level: B.S (CS) Semester: Autumn- 2015 Total Mark...

Continue Reading »

database 1(3410)solved Assignment-old papers-course outline -aiou-spring 2015

<div dir="ltr" style="text-align: left;" trbidi="on"> <h2 style="text-align: left;"> <span style="color: red;">Solved Assighnments</span></h2> <table cellpadding="0" cellspacing="0" class="tr-caption-container" style="clear: left; float: left; margin-bottom: 1em; text-align: left;"><tbody> <tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg631E3T38WKi1W79dg5QQuomT_lo3ySCSL2VeLMtINqVYHOsJ3lZz6tlQ4K2Qxy9Jk2bmGBrx8mAxXfhqiu_Ql67g3Wqqo90qVL5n63vRka_4zCgqdVyDcq_zllACNrBxwsMky59sa8k8/s1600/allama.png" style="clear: left; margin-bottom: 1em; margin-left: auto; margin-right: auto;"><img border="0" loading="lazy" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg631E3T38WKi1W79dg5QQuomT_lo3ySCSL2VeLMtINqVYHOsJ3lZz6tlQ4K2Qxy9Jk2bmGBrx8mAxXfhqiu_Ql67g3Wqqo90qVL5n63vRka_4zCgqdVyDcq_zllACNrBxwsMky59sa8k8/s1600-rw/allama.png" /></a></td></tr> <tr><td class="tr-caption" style="text-align: center;">AIOU</td></tr> </tbody></table> <h2 align="center" class="western"> <span style="color: #990000;"><span style="font-size: x-large;"><span style="letter-spacing: -0.3pt;"> </span></span></span></h2> <h2 align="center" class="western"> <span style="color: #990000;"><span style="font-size: x-large;"><span style="letter-spacing: -0.3pt;"> </span></span></span></h2> <h2 align="center" class="western"> <span style="color: #990000;"><span style="font-size: x-large;"><span style="letter-spacing: -0.3pt;"> </span></span></span></h2> <h2 align="center" class="western"> <span style="color: #990000;"><span style="font-size: x-large;"><span style="letter-spacing: -0.3pt;"> </span></span></span></h2> <h2 align="center" class="western">   </h2> <h2 align="center" class="western"> <span style="color: #990000;"><span style="font-size: x-large;"><span style="letter-spacing: -0.3pt;"> </span></span></span></h2> <h2 align="center" class="western">  </h2> <table cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: left; text-align: left;"><tbody></tbody></table> <h2 class="western"> Course: Databases-I (3410) Semester: Autumn 2015</h2> <h2 align="justify" class="western"> Level: Associate Degree in Commerce Total Marks: 100</h2> <h2 class="western"> Pass Marks: 50 </h2> <div align="center" class="western"> <span style="font-size: small;"><b>(Unit 1–4)</b></span></div> <div align="center" class="western" style="margin-left: 0.38in; text-indent: -0.38in;"> <span style="font-size: small;"><span style="font-size: x-small;"><i><b>Note: All questions are compulsory. Each question carries equal marks.</b></i></span></span></div> <br /> <div align="justify" class="western" lang="en-GB" style="text-indent: -0.5in;"> </div> <h1 align="center" class="western"> <span style="font-weight: normal;"><span style="font-size: medium;">ASSIGNMENT No. 1</span></span></h1> <h1 align="center" class="western"> <b><span style="font-weight: normal;"><span style="font-size: medium;">Q-1   a) <a href="http://www.ucl.ac.uk/archaeology/cisp/database/manual/node1.html" target="_blank">What is meant by database? define and explain it with the help of proper examples </a></span></span></b></h1> <h1 align="center" class="western"> <b><span style="font-weight: normal;"><span style="font-size: medium;"><a href="http://www.teach-ict.com/gcse_new/databases/uses_of_databases/miniweb/pg3.htm" target="_blank">examples</a> </span></span></b></h1> <h1 align="center" class="western"> <span style="font-size: medium;">b)<span style="font-weight: normal;"><a href="http://www.my-project-management-expert.com/different-types-of-databases.html" target="_blank"> briefly  explain the different types of database with the help of suitable examples</a></span></span></h1> <h1 align="center" class="western"> <span style="font-size: medium;"><span style="font-weight: normal;"> </span></span></h1> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> <div align="justify" class="western" lang="en-GB" style="margin-left: 0.38in; text-indent: -0.38in;"> <span style="font-size: small;"><span style="font-size: x-small;"><span lang="en-GB">Q. 2<a href="https://www.kenyaplex.com/resources/3100-factors-to-consider-when-choosing-a-file-organisation-method.aspx" target="_blank"> What are important factors in selecting a file organization? Give a brief discussion on important file organization?</a> </span></span></span><br /> <a href="http://www.enggpedia.com/computer-engineering-encyclopedia/301-programming-languages/1898-file-org-types-dis-advantages" target="_blank"><span style="font-size: small;"><span style="font-size: x-small;"><span lang="en-GB">important file organization </span></span></span></a> </div> </div> <div align="justify" class="western" lang="en-GB" style="margin-left: 0.75in; text-indent: -0.75in;"> <br /></div> <div align="justify" class="western" style="margin-left: 0.38in; text-indent: -0.38in;"> <span style="font-size: small;"><span style="font-size: x-small;"><span lang="en-GB">Q. 3 The figure below shows a class list for AIOU. Convert this user view to a set of 3NF relations. Assume the following: </span></span><span style="font-size: x-small;"><span lang="en-GB"><b>(20)</b></span></span></span></div> <div align="justify" class="western" lang="en-GB" style="margin-left: 0.38in; text-indent: -0.38in;"> <span style="font-size: x-small;"> a) An instructor has a unique location.</span></div> <div align="justify" class="western" lang="en-GB" style="margin-left: 0.38in; text-indent: -0.38in;"> <span style="font-size: x-small;"> b) A student has a unique major.</span></div> <div align="justify" class="western" lang="en-GB" style="margin-left: 0.38in; text-indent: -0.38in;"> <span style="font-size: x-small;"> c) A course has a unique title.</span></div> <div align="justify" class="western" lang="en-GB" style="margin-left: 0.38in; text-indent: -0.38in;"> <br /></div> <dl><dd><table cellpadding="7" cellspacing="0" style="width: 493px;"> <colgroup><col width="104"></col> <col width="113"></col> <col width="113"></col> <col width="105"></col> </colgroup><tbody> <tr> <td colspan="4" style="border: 1px solid #000000; padding: 0in 0.08in;" valign="top" width="477"><div align="center" class="western" lang="en-GB"> <span style="font-size: small;"><b>Allama Iqbal Open University</b></span></div> <div align="center" class="western"> <span style="font-size: small;"><span style="font-size: x-small;"><span lang="en-GB"><b>Class List – Spring 2015</b></span></span></span></div> </td> </tr> <tr> <td colspan="4" style="border: 1px solid #000000; padding: 0in 0.08in;" valign="top" width="477"><div align="justify" class="western"> <span style="font-size: small;"><span style="font-size: x-small;"><span lang="en-GB"><b>Course Code:</b></span></span><span style="font-size: x-small;"><span lang="en-GB"> 1431</span></span></span></div> <div align="justify" class="western"> <span style="font-size: small;"><span style="font-size: x-small;"><span lang="en-GB"><b>Course Title:</b></span></span><span style="font-size: x-small;"><span lang="en-GB"> Fundamental of Computers</span></span></span></div> <div align="justify" class="western"> <span style="font-size: small;"><span style="font-size: x-small;"><span lang="en-GB"><b>Instructor Name:</b></span></span><span style="font-size: x-small;"><span lang="en-GB"> D.EF</span></span></span></div> <div align="justify" class="western"> <span style="font-size: small;"><span style="font-size: x-small;"><span lang="en-GB"><b>Instructor Location:</b></span></span><span style="font-size: x-small;"><span lang="en-GB"> A-0002</span></span></span></div> </td> </tr> <tr valign="top"> <td style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: none; border-top: 1px solid #000000; padding-bottom: 0in; padding-left: 0.08in; padding-right: 0in; padding-top: 0in;" width="104"><div align="center" class="western" lang="en-GB"> <span style="font-size: x-small;"><b>Student ID</b></span></div> </td> <td style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: none; border-top: 1px solid #000000; padding-bottom: 0in; padding-left: 0.08in; padding-right: 0in; padding-top: 0in;" width="113"><div align="center" class="western" lang="en-GB"> <span style="font-size: x-small;"><b>Student Name</b></span></div> </td> <td style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: none; border-top: 1px solid #000000; padding-bottom: 0in; padding-left: 0.08in; padding-right: 0in; padding-top: 0in;" width="113"><div align="center" class="western" lang="en-GB"> <span style="font-size: x-small;"><b>Major</b></span></div> </td> <td style="border: 1px solid #000000; padding: 0in 0.08in;" width="105"><div align="center" class="western" lang="en-GB"> <span style="font-size: x-small;"><b>Grade</b></span></div> </td> </tr> <tr valign="top"> <td style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: none; border-top: 1px solid #000000; padding-bottom: 0in; padding-left: 0.08in; padding-right: 0in; padding-top: 0in;" width="104"><div align="center" class="western" lang="en-GB"> <span style="font-size: x-small;">25210</span></div> </td> <td style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: none; border-top: 1px solid #000000; padding-bottom: 0in; padding-left: 0.08in; padding-right: 0in; padding-top: 0in;" width="113"><div align="center" class="western" lang="en-GB"> <span style="font-size: x-small;">AA</span></div> </td> <td style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: none; border-top: 1px solid #000000; padding-bottom: 0in; padding-left: 0.08in; padding-right: 0in; padding-top: 0in;" width="113"><div align="center" class="western" lang="en-GB"> <span style="font-size: x-small;">SE01</span></div> </td> <td style="border: 1px solid #000000; padding: 0in 0.08in;" width="105"><div align="center" class="western" lang="en-GB"> <span style="font-size: x-small;">A+</span></div> </td> </tr> <tr valign="top"> <td style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: none; border-top: 1px solid #000000; padding-bottom: 0in; padding-left: 0.08in; padding-right: 0in; padding-top: 0in;" width="104"><div align="center" class="western" lang="en-GB"> <span style="font-size: x-small;">23735</span></div> </td> <td style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: none; border-top: 1px solid #000000; padding-bottom: 0in; padding-left: 0.08in; padding-right: 0in; padding-top: 0in;" width="113"><div align="center" class="western" lang="en-GB"> <span style="font-size: x-small;">BC</span></div> </td> <td style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: none; border-top: 1px solid #000000; padding-bottom: 0in; padding-left: 0.08in; padding-right: 0in; padding-top: 0in;" width="113"><div align="center" class="western" lang="en-GB"> <span style="font-size: x-small;">DF02</span></div> </td> <td style="border: 1px solid #000000; padding: 0in 0.08in;" width="105"><div align="center" class="western" lang="en-GB"> <span style="font-size: x-small;">B+</span></div> </td> </tr> <tr valign="top"> <td style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: none; border-top: 1px solid #000000; padding-bottom: 0in; padding-left: 0.08in; padding-right: 0in; padding-top: 0in;" width="104"><div align="center" class="western" lang="en-GB"> <span style="font-size: x-small;">27265</span></div> </td> <td style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: none; border-top: 1px solid #000000; padding-bottom: 0in; padding-left: 0.08in; padding-right: 0in; padding-top: 0in;" width="113"><div align="center" class="western" lang="en-GB"> <span style="font-size: x-small;">CD</span></div> </td> <td style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: none; border-top: 1px solid #000000; padding-bottom: 0in; padding-left: 0.08in; padding-right: 0in; padding-top: 0in;" width="113"><div align="center" class="western" lang="en-GB"> <span style="font-size: x-small;">SE03</span></div> </td> <td style="border: 1px solid #000000; padding: 0in 0.08in;" width="105"><div align="center" class="western" lang="en-GB"> <span style="font-size: x-small;">C+</span></div> </td> </tr> <tr valign="top"> <td style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: none; border-top: 1px solid #000000; padding-bottom: 0in; padding-left: 0.08in; padding-right: 0in; padding-top: 0in;" width="104"><div align="center" class="western" lang="en-GB"> <span style="font-size: x-small;">27399</span></div> </td> <td style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: none; border-top: 1px solid #000000; padding-bottom: 0in; padding-left: 0.08in; padding-right: 0in; padding-top: 0in;" width="113"><div align="center" class="western" lang="en-GB"> <span style="font-size: x-small;">DE</span></div> </td> <td style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: none; border-top: 1px solid #000000; padding-bottom: 0in; padding-left: 0.08in; padding-right: 0in; padding-top: 0in;" width="113"><div align="center" class="western" lang="en-GB"> <span style="font-size: x-small;">DB04</span></div> </td> <td style="border: 1px solid #000000; padding: 0in 0.08in;" width="105"><div align="center" class="western" lang="en-GB"> <span style="font-size: x-small;">D+</span></div> </td> </tr> <tr valign="top"> <td style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: none; border-top: 1px solid #000000; padding-bottom: 0in; padding-left: 0.08in; padding-right: 0in; padding-top: 0in;" width="104"><div align="center" class="western" lang="en-GB"> <span style="font-size: x-small;">...</span></div> </td> <td style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: none; border-top: 1px solid #000000; padding-bottom: 0in; padding-left: 0.08in; padding-right: 0in; padding-top: 0in;" width="113"><div align="center" class="western" lang="en-GB"> <span style="font-size: x-small;">...</span></div> </td> <td style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: none; border-top: 1px solid #000000; padding-bottom: 0in; padding-left: 0.08in; padding-right: 0in; padding-top: 0in;" width="113"><div align="center" class="western" lang="en-GB"> <span style="font-size: x-small;">...</span></div> </td> <td style="border: 1px solid #000000; padding: 0in 0.08in;" width="105"><div align="center" class="western" lang="en-GB"> <span style="font-size: x-small;">...</span></div> </td> </tr> </tbody></table> </dd></dl> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: small;"><span style="font-size: x-small;"><span lang="en-GB">Q. 4 a) What do you meant by <a href="https://en.wikipedia.org/wiki/Referential_integrity" target="_blank">referential integrity</a>? Give the basic<a href="http://devzone.advantagedatabase.com/dz/webhelp/advantage8.1/server1/referential_integrity.htm" target="_blank"> rules for insertion and deletion that assure referential integrity.</a> </span></span><span style="font-size: x-small;"><span lang="en-GB"><b>(10)</b></span></span></span></div> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: small;"><span style="font-size: x-small;"><span lang="en-GB"> b) What are the<a href="http://www.essentialsql.com/what-is-the-difference-between-a-primary-key-and-a-foreign-key/" target="_blank"> major differences between primary key & foreign key</a>? Explain it in detail with the help of suitable examples. </span></span><span style="font-size: x-small;"><span lang="en-GB"><b>(10)</b></span></span></span></div> <div align="justify" class="western" lang="en-GB" style="margin-left: 0.75in; text-indent: -0.75in;"> <br /></div> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: small;"><span style="font-size: x-small;"><span lang="en-GB">Q. 5 Write short notes on the following terms:</span></span></span></div> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: small;"><span style="font-size: x-small;"><span lang="en-GB"> a) <a href="http://www.uwinnipeg.ca/~ychen2/databaseNotes/third-norm-form.pdf" target="_blank">3NF </a></span></span><a href="http://www.uwinnipeg.ca/~ychen2/databaseNotes/third-norm-form.pdf" target="_blank"><span style="font-size: x-small;"><span lang="en-GB"><b>(05)</b></span></span></a></span></div> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: small;"><span style="font-size: x-small;"><span lang="en-GB"> b)<a href="http://www.siue.edu/~dbock/cmis450/3-ermodel.htm" target="_blank"> Gerund </a></span></span><a href="http://www.siue.edu/~dbock/cmis450/3-ermodel.htm" target="_blank"><span style="font-size: x-small;"><span lang="en-GB"><b>(05)</b></span></span></a></span></div> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: small;"><span style="font-size: x-small;"><span lang="en-GB"> c) <a href="https://www.lucidchart.com/pages/ER-diagram-symbols-and-meaning" target="_blank">Symbols </a></span></span><span style="font-size: x-small;"><span lang="en-GB"><b><a href="https://www.lucidchart.com/pages/ER-diagram-symbols-and-meaning" target="_blank">(</a>05)</b></span></span></span></div> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: small;"><span style="font-size: x-small;"><span lang="en-GB"> d) Subtypes </span></span><span style="font-size: x-small;"><span lang="en-GB"><b>(05)</b></span></span></span></div> <div align="justify" class="western" lang="en-GB" style="margin-left: 0.75in; text-indent: -0.75in;"> <br /></div> <div align="center" class="western"> <span style="font-size: small;"><span style="font-size: medium;"><b>ASSIGNMENT No. 2</b></span></span></div> <div align="center" class="western"> <span style="font-size: small;"><b>(Unit 5–8)</b></span></div> <h2 class="western"> Total Marks: 100 Pass Marks: 50</h2> <div align="center" class="western"> <br /></div> <div align="center" class="western" style="margin-left: 0.38in; text-indent: -0.38in;"> <span style="font-size: small;"><span style="font-size: x-small;"><i><b>Note: All questions are compulsory. Each question carries equal marks.</b></i></span></span></div> <div align="justify" class="western" lang="en-GB" style="margin-left: 0.75in; text-indent: -0.75in;"> <br /></div> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: small;"><span style="font-size: x-small;"><span lang="en-GB">Q. 1 a) Define<a href="https://en.wikipedia.org/wiki/Logical_data_model" target="_blank"> logical database model</a>. What are its types? Explain it in detail with the help of suitable examples. </span></span><span style="font-size: x-small;"><span lang="en-GB"><b>(10)</b></span></span></span><br /> <span style="font-size: small;"><span style="font-size: x-small;"><span lang="en-GB"><b>Ans types</b></span></span></span><br /> <span style="font-size: small;"><span style="font-size: x-small;"><span lang="en-GB"><b>(1) <a href="https://en.wikipedia.org/wiki/Physical_data_model" target="_blank">physiacal data model</a></b></span></span></span><br /> <a href="https://www.1keydata.com/datawarehousing/conceptual-data-model.html" target="_blank"><span style="font-size: small;"><span style="font-size: x-small;"><span lang="en-GB"><b>(2) conceptual data model</b></span></span></span></a><br /> <span style="font-size: small;"><span style="font-size: x-small;"><span lang="en-GB"><b>  </b></span></span></span></div> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: small;"><span style="font-size: x-small;"><span lang="en-GB"> b) <a href="https://en.wikipedia.org/wiki/Physical_data_model" target="_blank">Define physical database design</a>. Explain its main components and major objectives in detail. </span></span><span style="font-size: x-small;"><span lang="en-GB"><b>(10)</b></span></span></span></div> <div align="justify" class="western" lang="en-GB" style="margin-left: 0.75in; text-indent: -0.75in;"> <br /></div> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: small;"><span style="font-size: x-small;"><span lang="en-GB">Q. 2 a) <a href="https://en.wikibooks.org/wiki/Microsoft_Office/Create_a_basic_two_table_database_with_reports" target="_blank">Write down steps to create a simple form application to maintaininformation of employees of a company.</a> </span></span><span style="font-size: x-small;"><span lang="en-GB"><b>(10)</b></span></span></span></div> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> b) Explain briefly the<a href="http://library.bcu.ac.uk/learner/writingguides/1.02%20Reports.htm" target="_blank"> four basic components of a report.</a> (10)</div> <div align="justify" class="western" lang="en-GB" style="margin-left: 0.75in; text-indent: -0.75in;"> <br /></div> <div align="justify" class="western" style="margin-left: 0.38in; text-indent: -0.38in;"> <span style="font-size: small;"><span style="font-size: x-small;"><span lang="en-GB">Q. 3 What do you mean by a<a href="https://docs.oracle.com/cd/E15523_01/bi.1111/b32122/orbr_concepts1005.htm#RSBDR168" target="_blank"> report object navigator</a> and <a href="https://docs.oracle.com/cd/B28359_01/appdev.111/b28425/obj_types.htm" target="_blank">object type</a>? Give list of <a href="https://docs.oracle.com/cd/B28359_01/appdev.111/b28425/obj_types.htm" target="_blank">different report object types and their description</a>. </span></span><span style="font-size: x-small;"><span lang="en-GB"><b>(20)</b></span></span></span></div> <div align="justify" class="western" lang="en-GB" style="margin-left: 0.38in; text-indent: -0.38in;"> <br /></div> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: small;"><span style="font-size: x-small;"><span lang="en-GB">Q. 4 a) What is meant by a <a href="http://allenbrowne.com/casu-01.html" target="_blank">form object type</a>? <a href="https://www.techopedia.com/definition/24081/database-object" target="_blank">Give list of differentobject types and their description</a>. </span></span><span style="font-size: x-small;"><span lang="en-GB"><b>(10)</b></span></span></span></div> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: small;"><span style="font-size: x-small;"><span lang="en-GB"> b)<a href="http://www.codeproject.com/Articles/38998/Most-Commonly-Used-Functions-in-SQL-Server" target="_blank"> Explainsome of the important SQL functions with the help of examples.</a> </span></span><span style="font-size: x-small;"><span lang="en-GB"><b>(10)</b></span></span></span></div> <div align="justify" class="western" lang="en-GB" style="margin-left: 0.75in; text-indent: -0.75in;"> <br /></div> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: small;"><span style="font-size: x-small;"><span lang="en-GB">Q. 5 Write short notes on the following terms: </span></span><span style="font-size: x-small;"><span lang="en-GB"><b>(20)</b></span></span></span></div> <div align="justify" class="western" lang="en-GB" style="margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: x-small;"> a) <a href="http://laidbacksolutions.se/LiveDocs/CargoAdmin/2.3/layoutEditor/index.html" target="_blank">Layout Editor</a></span></div> <div align="justify" class="western" lang="en-GB" style="margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: x-small;"> b)<a href="https://help.sap.com/saphelp_nw73ehp1/helpdata/en/ef/d94b7bebf811d295b100a0c94260a5/content.htm" target="_blank"> Object Navigator</a></span></div> <div align="justify" class="western" lang="en-GB" style="margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: x-small;"> c) <a href="http://www.radpage.com/heitml2.1/compguide/forms.hei" target="_blank">Form Components</a></span></div> <div align="justify" class="western" lang="en-GB" style="margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: x-small;"> d) <a href="https://mariadb.com/kb/en/mariadb/database-design-phase-2-conceptual-design/" target="_blank">Conceptual Design</a></span></div> <div align="justify" class="western" lang="en-GB" style="margin-left: 0.75in; text-indent: -0.75in;"> <br /></div> <div align="justify" class="western" lang="en-GB" style="margin-left: 0.75in; text-indent: -0.75in;"> <br /></div> <div align="justify" class="western" lang="en-GB" style="margin-left: 0.75in; text-indent: -0.75in;"> <br /></div> <div class="western" lang="en-GB" style="line-height: 115%; margin-bottom: 0.14in; page-break-before: always;"> <br /> <br /></div> <div align="center" class="western"> <u><b>3410 Database-I</b></u></div> <div align="right" class="western"> <span style="font-size: small;"><b>Credit Hours: 4 (3 +1)</b></span></div> <div align="justify" class="western"> <span style="font-size: x-small;"><b>Recommended Book: </b></span> </div> <div align="justify" class="western"> <span style="font-size: x-small;"><b>Modern Data Base Management by Jeffery A. Hoffer and Oracle Developer/ 2000</b></span></div> <div align="justify" class="western"> <br /></div> <div align="justify" class="western"> <span style="font-size: x-small;"><b>Course Outlines:</b></span></div> <div align="justify" class="western"> <br /></div> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: small;"><span style="font-size: x-small;"><b>Unit–1 Database Foundation</b></span></span></div> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: x-small;"><span style="letter-spacing: -0.2pt;"> Introduction, Data and Information, Components, Advantages, Data Association, Entities, Keys and Its Types, Attributes, Data Associations, Data Structure Diagram</span></span></div> <div align="justify" class="western" style="letter-spacing: -0.2pt; margin-left: 0.75in; text-indent: -0.75in;"> <br /></div> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: small;"><span style="font-size: x-small;"><b>Unit–2 E-R Model</b></span></span></div> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: x-small;"> Basic Constructs (Symbols), Degree of Relationships, Cardinality, Gerund, Modeling Time Dependent Data, Super Types, Subtypes</span></div> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> <br /></div> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: small;"><span style="font-size: x-small;"><b>Unit–3 Data Models</b></span></span></div> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: x-small;"> Hierarchical, Network, Relational, Comparison of All Data Models, Relation, Characteristics of Relation, Converting E-R Model into Relation</span></div> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> <br /></div> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: small;"><span style="font-size: x-small;"><b>Unit–4 Normalization </b></span></span> </div> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: x-small;"> 1NF, 2NF, 3NF</span></div> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> <br /></div> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: small;"><span style="font-size: x-small;"><b>Unit–5 Data Base Design </b></span></span> </div> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: x-small;"> Conceptual Design, Physical Design</span></div> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> <br /></div> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: small;"><span style="font-size: x-small;"><b>Unit–6 SQL Introduction</b></span></span></div> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: x-small;"> Introduction, Creating, Altering & Deleting Table, Inserting, Updating, & Deleting Rows, Querying The Tables, SQL Functions (Arithmetic, Group (Avg, Count, Max, Min, Sum), Date, Special Functions (In, Between, Like, Null)), Managing Multiple Tables</span></div> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> <br /></div> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: small;"><span style="font-size: x-small;"><b>Unit–7 Introduction to Forms</b></span></span></div> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: x-small;"> Form Components, Form Module, Blocks, Items, Objects, Object Navigator, Properties Window, Layout Editor</span></div> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> <br /></div> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: small;"><span style="font-size: x-small;"><b>Unit–8 Basic Form Design</b></span></span></div> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: x-small;"> Using Wizard for Form Design, Customizing a Form, Defining Items (Buttons, Check Boxes, Display Items, List Items, Radio Groups, Text Items), Creating LOV, Creating Master Detail Form</span></div> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> <br /></div> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: small;"><span style="font-size: x-small;"><b>Unit–9 Introduction to Report</b></span></span></div> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> <span style="font-size: small;"><span style="font-size: x-small;"> Report Design Considerations, Report Objects, Basic Report Design.</span></span></div> <div align="justify" class="western" style="margin-left: 0.75in; text-indent: -0.75in;"> <br /></div> <div align="center" class="western" style="line-height: 0.19in; margin-left: 0.75in; text-indent: -0.75in;"> </div> <h1 align="center" class="western"> <span style="font-size: medium;"><span style="font-weight: normal;">                                                     </span></span></h1> <h1 align="center" class="western"> <span style="font-size: medium;"><span style="font-weight: normal;"> </span></span></h1> </div>

database 1(3410)solved Assignment-old papers-course outline -aiou-spring 2015

Solved Assighnments AIOU               Course: Databases-I (3410) Semester: Autumn 2015 Level: Associate Degree in ...

Continue Reading »