I GENERAL INFORMATION



Department of Information Technology

Hand Book (2013-14)

II B.Tech – II Semester [Branch: IT]

Guru Nanak Institutions Technical Campus

School of Engineering & Technology

Ibrahimpatnam, R R District – 501 506 (A. P.)

Department of Information Technology

I.GENERAL INFORMATION

About the College:

Guru Nanak Engineering College was established in 2001 with a single - minded aim to provide a perfect platform to students in the field of Engineering, Technology and Management for their academic and overall personality development. Five programmes namely CSE, ECE, EEE , IT and Mechanical Engineering have been accredited by the National Board of Accreditation (NBA), AICTE. Civil and Aeronautical engineering accreditation process is in progress. The College is also accredited by NAAC and strives for Technical campus.

Highlights:

▪ Teaching methodology involves technical case studies, creative exercises, online assignments & descriptive tests.

▪ E-class rooms

▪ Industry focused knowledge is imparted by R & D and Industry peer members.

▪ Tie up with MNC companies and foreign Universities

▪ State of art laboratories, sophisticated equipment and advanced software

▪ Library is equipped with National and International Journals, 50000 volumes and more than 7500 titles of books, NPTEL, SONET CDs and internet lab for students and staff.

▪ IEEE online journals and IEL online journals through AICTE INDEST CONSORTIUM

▪ Wi-Fi campus with 12 Mbps bandwidth.

▪ Oracle, Microsoft Development suite, Microsoft academic license for Microsoft Software Products, MAT LAB, PSPICE, VHDL, TINAPRO and DSP softwares are available

▪ State of art English Language lab and 800 computers connected with dedicated high-end servers.

▪ Scholarship and free books for meritorious students.

▪ Book Bank Scheme facility to the students.

▪ A new and unique Laptop lab with latest configuration Most of the classrooms are fixed with LCDs and screens.

▪ All major professional societies’ student chapters like ISTE, CSI, IETE and IEEE etc.

Training & Placement:

• Modern training department is established as per the corporate standards.

• College has JKC training centre and special training is providing in the area of soft skills and technical skills for students which is a part of their regular time-Table.

▪ Large Number of students placed with Microsoft Inc, Infosys, Mahendra Satyam Ltd, Infosys, IBM, TCS, ADP, Wipro, Sutherland Technologies, CMC, SEMANTIC SPACE, InfoTech Enterprises.

▪ Industry experts are invited for guest lectures, seminars and student presentations to maintain a strong Industry and Institution Interaction. Also, industrial visits are arranged for students to enrich their knowledge.

Contact Information:

Associate Director : Prof. P Partha Sarathy 809 618 5678

Associate Director : Prof. R K Singh 809 617 5678

Dean (A&T) : Prof. Rishi Sayal 809 660 9846

Dean (R&D) :Dr. S. V. Ranganayakulu 809 660 9824

HOD CIVIL : Prof. L P Dasika 809 660 9822

HOD EEE : Prof. M Narendra Kumar 809 660 9840

HOD MECH : Prof. V. Shanmukha Prasad 809 660 9816

HOD ECE : Prof. Anita Swamidas 809 660 9843

HOD CSE : Dr. Shaik Masood Ahamed 809 660 9844

HOD IT : Prof. Prasanna Balaji N 809 621 5678

HOD AERO : Prof. M A Irfanr 809 660 9825

HOD H & S : Prof.E.ChandraSekhar 809 660 9831

Manager Admin : Rt. Col Rajesh 809 660 9847

Administrative officer : Mr. Chary 809 660 9815

Transport Officer : Mr. Venu Gopal 809 660 9841

College Land Line No : 08414-202120/21

II. ACADEMICS

1. Departmental Profile

The Department of IT offers a B. Tech. program in Information Technology since college inception in 2001; the branch has attracted lot of young talents wanting to make a mark in this field. Information Technology being the buzzword over the last decade, extreme care has been taken to design the syllabi keeping in minds the latest trends and developments.

Department has separate library and has 523 books, digital study material etc. Books of the library are issued to the Faculty. Students can refer and read in the library.

The department has effective counseling by staff based on the performance in internal exams, special descriptive exams and on previous performance in university exams. The HOD and the class mentors take the student’s feed back four times in a Semester. The students can freely express their academic administrative and even personal problems and seek professional guidance.

2. Highlights

• The Department has tie-up with IBM academic initiave, IEEE , CSI and ISTE student chapter.

▪ Focus on industry oriented teaching to bridge the gap between industry demands and course curriculum.

▪ All industry and research oriented projects from IBM,IEEE,HCU,RCI,SIERRA ATLANTIC,XIOTECH,SURVEY OF INDIA,NIC,ECIL,DRDL,OPS,NMDC,BEL and BHEL completed by fourth year students .

▪ Department has tie-up with IBM, under IBM Academic initiative program, students are working on IBM real time projects.

▪ Department focuses on publishing research based papers in international journals/Conferences, and more then 50 papers in span of two years.

▪ Department has got strong research oriented team with more then 50 papers in international journals/Conferences.

▪ Department stresses on academic growth of student/faculty by conducting conferences/workshops/seminars in collaboration with IEEE, CSI and ISTE chapters.

3. Faculty Strength:

The faculty in the department consists of Senior and well experienced Professors, Associate Professors and Assistant Professors with Ph. D. / M. Tech and B. Tech qualifications. An experienced System Administrator and well-qualified Lab staff support the conduct of Laboratories.

|Sl.No |Name of Faculty |Designation |

|1 |Prof.N.Prasanna Balaji |Professor |

|2 |Ms.M.Nishantha |Asst.Professor |

|3 |Mr.T.Janardhan Rao |Assoc.Professor |

|4 |Mr.Ch.Ravindra |Asst.Professor |

|5 |Mr.P.Harishankar |Asst.Professor |

|6 |Ms.Y.Sowjanya |Asst.Professor |

|7 |Ms.Swetha EnReddy |Asst.Professor |

|8 |Ms.Kareemunnisa |Asst.Professor |

|9 |Mr.P.Vinay Bhushan |Asst.Professor |

|10 |Mr.S V Subramanyam |Assoc.Professor |

|11 |Mr.Ravi Raju B |Asst.Professor |

|Non- Teaching Staff |

|1 |Ms.S.Anjali |Programmer |

|2 |Mr. Chamkaur Singh |Lab Asst |

|3 |Mr.Raju |Attender |

|1. |In charge of Discipline and 2nd person in the Dept. -- Ms. M. Nishantha |

|2. |In charge for conduct of Labs and 3rd person in Dept. – Ms.Swetha EnReddy |

4. Course Calendar for the Semester

|Event |From |To |No.of Weeks/Days |

|Commencement of class work |09.12.2013 |

|I Spell of Instructions |09.12.2013 |10.01.2014 |5 Weeks |

|Pongal Holidays |11.01.2014 |19.01.2014 |9 Days |

|I Spell of Instructions (Continued) |20.01.2014 |07.02.2014 |3 Weeks |

|I mid examinations |10.02.2014 |12.02.2014 |3 Days |

|II Spell of Instructions |13.02.2014 |05.04.2014 |7 Weeks 3 Days |

|II mid examinations |07.04.2014 |09.04.2014 |3 Days |

|Preparations & Practical examinations |10.04.2014 |19.04.2014 |9 Days |

|End semester examinations |21.04.2014 |03.05.2014 |2 Weeks |

|Supplementary Examinations |05.05.2014 |17.05.2014 |2 Weeks |

|Summer vacation |18.05.2014 |15.06.2014 |4 Weeks |

|Commencement of class work for Next Semester |16.06.2014 |- |- |

5. Procedures for Laboratories

a. Equipment in the lab for the use of student community. Students must use the equipment with care. Any damage caused is punishable.

b. Students should carry their observation book along with the record book with completed exercises/ calculations while attending the lab.

c. Students are supposed to occupy the experiment setup allotted to them and maintain discipline in the lab.

d. Labs can be used in free time / lunch hours by the students with prior permission from the lab in-charge.

e. 15 marks are awarded for continuous evaluation in the laboratory.

Lab records need to be submitted on or before date of submission

MONITORING AND GUIDANCE:

1. Student Feedback

Incase the students’ find it difficult to cope up / understand a particular subject, they are advised to discuss it with the concerned Teacher /The Class Teacher/Counselor/HOD/ Principal

Students can use the suggestion boxes for communicating their problems. Necessary action will be taken by the concerned authorities. If required, Principal/HOD will discuss the student to solve the problems.

Class Teacher:

|S.No. |Year |Name of the faculty & Phone Number |

|1 |II B.Tech IT |Mr.T.Janardhan Rao & 7416147658 |

Counselor:

One counselor is assigned to a group fo 30students.. Students can directly discuss their college related or personal problems related to academics with them. The Counselors are accessible to the students and they can talk to them, whenever they are free from class / lab work. counselors will interact the students once in a fortnight and discuss with them to discuss the progress.

Class Representatives and their role

Two students from each class are selected as Class representatives from the department based on their academic performance and discipline.

Responsibilities of the Class Representatives:

▪ Communicating the departmental / college directives & information to the students.

▪ Communicating the Problems faced by the students and also communicating the suggestions for improvement.

▪ Coordinating academic events and co-curricular activities.

▪ Encourage students to interact for better studies& sharing the knowledge and information.

II B. Tech Semester I Class Representatives are:

|Roll No |Name of the Student |

|12WJ1A1203 |Ms.ANSHU PRIYA PRASAD |

|12WJ1A1218 |Mr.JIBRAN SHAJIE |

Role of a class Teacher:

• Ensuring the conduct of classes

• Monitoring the students attendance

• SMS, phone calls to the parents and interacting with parents

• Class Discipline

• Arranging extra classes for coverage of syllabus

• Ensuring the conduct of special tests, remedial classes for slow learners

• Communicating the student’s attendance, Mid marks, special test marks, attendance of Remedial classes etc.

Role of the Counselor

• Talk to the student at least once in a fortnight

• Updating the counseling book

• Problems of the student may be discussed with the concerned faculty/mentor/HOD

• Identify the strengths , weakness and motivate the student

Counselors will evaluate the student individually for the following:

a. Less marks in Internal exams

b. Continuous Absence (3 days)

c. Not understanding the subject

d. Students from Telugu medium

e. Assistance for back log subjects etc.

2. Special Tests:

Two Special tests will be conducted for students before the Mid exams to improve their

performance in the mid examinations. If any student is not performed , he/she will be asked to

attend the reexam to ensure the understanding of the subject. If required the teacher will guide

the student in the subject.

3. Remedial classes:

Remedial classes will be conducted for students who are academically weak and who do not perform well in their internal examinations and special class tests.

4. Backlog Management

The Class Teacher maintains a complete record of Examination results of each student and they counsel and guide them in preparing for backlogs. Students are provided with material and important questions are discussed.

5. Correspondence with Parents

Parents will be informed about the performance of their ward from time to time during the course period, however parents are advised to contact class Teacher / Department Head periodically.

6. NPTEL Classes

Department conducts NPTEL classes with Technical DVD’s as virtual/visual classes through faculties from IIT’S, NIT’S and IIIT’S

7. CSA activities

The department regularly organizes technical quiz, seminar, group discussions etc. as part of promote curricular and extra curricular activities.

|Subject |Principles of programming Languages |

|Faculty |Ms. M. Nishantha |

|Reference Books |

|Book 1 |Programming Language, 2nd Edition, A.B. Tucker,R.E. Noonan. |

|Text Books (to be acquired by the Students) |

|Book 2 |Concepts of Programming Languages Robert .W. Sebesta 6/e, Pearson Education. |

|Book 3 |2. Programming Language Design Concepts –D.A. Watt. |

|Unit |Topic |Chapters |No of Classes |

| | |Book 1 | | |

|II |Reasons for studying Programming |T1,T2 | |8 |

| |Languages | | | |

|III |Programming Domains, Evaluation Criteria |T1 | |8 |

|IV |Influences on Language Design, Language |T1,T2 | |7 |

| |Categories | | | |

|V |Language Paradigms |T1,T2 | |7 |

|VI |Language Implementation |T2 | |7 |

|VII |Programming Environments |T2 | |7 |

|VIII |Test/Revision | | |5 |

| Contact classes for syllabus coverage |56 |

|Special Descriptive Tests |02 |

|Tutorial classes |06 |

|Guest Lecture Classes |02 |

|Total No. of classes |66 |

JNTU Syllabus

Programming Language, 2nd Edition, A.B. Tucker,R.E. Noonan.

| Principles of programming Languages |

|Unit – 1 |Preliminary Concepts: Reasons for studying, concepts of programming languages, Programming domains, Language Evaluation Criteria, influences on |

| |Language design, Language categories, Programming Paradigms – Imperative, Object Oriented, functional Programming , Logic Programming. |

| |Programming Language Implementation – Compilation and Virtual Machines, programming environments. |

|Unit – II |Syntax and Semantics: general Problem of describing Syntax and Semantics, formal methods of describing syntax - BNF, EBNF for common programming |

| |languages features, parse trees, ambiguous grammars, attribute grammars, denotational semantics and axiomatic semantics for common programming |

| |language features. |

|Unit –III |Data types: Introduction, primitive, character, user defined, array, associative, record, union, pointer and reference types, design and |

| |implementation uses related to these types. Names, Variable, concept of binding, type checking, strong typing, type compatibility, named |

| |constants, variable initialization |

|Unit – IV |Expressions and Statements: Arithmetic relational and Boolean expressions, Short circuit evaluation mixed mode assignment, Assignment Statements,|

| |Control Structures – Statement Level, Compound Statements, Selection, Iteration, Unconditional Statements, guarded commands. |

|Unit – V |Subprograms and Blocks: Fundamentals of sub-programs, Scope and lifetime of variable, static and dynamic scope, Design issues of subprograms and |

| |operations, local referencing environments, parameter passing methods, overloaded sub-programs, generic sub-programs, parameters that are |

| |sub-program names, design issues for functions user defined overloaded operators, co routines. |

|Unit – VI |Abstract Data types: Abstractions and encapsulation, introductions to data abstraction, design issues, language examples, C++ parameterized ADT, |

| |object oriented programming in small talk, C++, Java, C#, Ada 95 |

| |Concurrency: Subprogram level concurrency, semaphores, monitors, massage passing, Java threads, C# threads |

|Unit – VII |Exception handling : Exceptions, exception Propagation, Exception handler in Ada, C++ and Java.Logic Programming Language : Introduction and |

| |overview of logic programming, basic element of prolog application of logic programming. |

|Unit –VIII |Functional Programming Languages: Introduction, fundamentals of FPL, LISP, ML, Haskell, application of Functional Programming Languages and |

| |comparison of functional and imperative Languages. |

| |ScriptingLanguage:Pragmatics,KeyConcepts,caseStudy:Python-values and types, variables, storage and control Binding and scope, Procedural |

| |Abstraction, Data Abstraction, Separate Compilation, ModuleLibrary. |

Concepts of Programming Languages Robert .W. Sebesta 6/e, Pearson Education.

Programming Language Design Concepts –D.A. Watt.

Principles of programming Languages Assignment & IMPORTANT QUESTIONS

| Unit – 1 Assignment QUESTIONS |

|Date of submission:24/12/2013 |

|1. |Explain the potential benefits of studying programming language concepts. |

|2. |Discuss the various programming domains and their associated languages |

|3. |Explain in detail about Evaluation criteria |

|4. |Discuss about the programming language implementation |

|IMPORTANT QUESTIONS |

|1 |Discuss the general methods of implementing a programming language? (April-May,2012,set- |

|2 |Why are strongly typed languages compiled while weakly typed languages interpreted?(Nov-Dec,2012) |

|3 |What is hybrid implementation of languages? Explain? (Nov-Dec,2012) |

|4 |Discuss about various programming domains & their associated languages? (Nov-Dec,2012) |

|Unit – 2 Assignment QUESTIONS |

|Date of submission:09/01/2014 |

|1. |Write short notes on lexemes, language recognizers and language generators. |

|2. |What are the syntactic structures or element that can be described using BNF notation? |

|3. |How do you express the operator precedence in parse trees? explain with examples |

|4. |Discuss various features of programming language features. |

|IMPORTANT QUESTIONS |

|1 |Describe the approach of using axiomatic semantics to prove the correctness of a program? (April-May,2012,set-2) |

|2 |List the differences between an intrinsic attribute and a non-intrinsic synthesized attribute? (April-May,2012,set-3) |

|3 |Write a BNF description of the Boolean expressions of Java, including the three operators &&, ||, ! and the relational expressions? |

| |(April-May,2012,set-3) |

|4 |What is the primary use of attribute grammars? How is the order of evaluation of attributes determined for the trees of a given attribute |

| |grammar? (April-May,2012,set-3) |

|Unit – 3 Assignment QUESTIONS |

|Date of submission:24/01/2014 |

|1. |Discuss in detail about various data types. Why every programming language supports different data types. |

|2. |Discuss names and variables in detail. |

|3. |Explain in detail various design issues of character string types. |

|4. |Why are the reference variables in c++ better than the pointers for formal parameters? |

|IMPORTANT QUESTIONS |

|1 |Dynamic type binding is closely related to implicit heap – dynamic variables. Explain this relationship. (April-May,2012,set-3) |

|2 |Describe the operations of general language generator and general language recognizer. (April-May,2012,set-4) |

|3 | Describe how each of the two mathematical models of language description, define the syntax of a programming language. |

| |(April-May,2012,set-4) |

|4 |What is the general problem with static scoping? How is a reference to a non local variable in a static scoped program connected to its |

| |definition? (April-May,2012,set-2) |

|Unit – 4 Assignment QUESTIONS |

|Date of submission:07/02/2014 |

|1. |Discuss precedence and associativity rules of different programming language. |

|2. |What is the role of parentheses with relate to precedence of operators? |

|3. |Explain in detail relational expressions, Boolean expressions and short-circuit evaluation |

|4. |Explain about the assignment statements & compound statements. |

|IMPORTANT QUESTIONS |

|1 |Discuss the design issues of multiple- selection statements and logically controlled loop statements. (April-May,2012,set-2) |

|2 |Briefly explain about the mixed – mode assignments that are allowed in Ada and Java languages(April-May,2012,set-3) |

|3 |What advantages does Java’s break statement have over C’s and C++’s break statements(April-May,2012,set-3) |

|4 |Explain the advantages and disadvantages of the Java For statement compared to Ada? (April-May,2012,set-4) |

|Unit – 5 Assignment QUESTIONS |

|Date of submission:26/02/2014 |

|1. |Discuss in detail the Characteristics of sub programs. |

|2. |What is the general problem with static scoping & explain dynamic scoping? |

|3. |What is block? How scope of a variable depends on block? |

|4. |Discuss about the design issues for functions user defined overloaded operators? |

|IMPORTANT QUESTIONS |

|1 |Describe the design issues for functions. (April-May,2012,set-1) |

|2 |Discuss the issues that arise when subprogram names are parameters. (April-May,2012,set-2) |

|3 |Define shallow and deep binding for referencing environments of subprograms that have been passed as parameters? (April-May,2012,set-3) |

|4 |What are formal and actual parameters? Discuss the advantages and disadvantages of keyword parameters. (April-May,2012,set-4) |

|Unit – 6 Assignment QUESTIONS |

|Date of submission:13/03/2014 |

|1. |Describe the two problems that appear in construction of large programs that led to the development of encapsulation constructs. |

|2. |Describe abstract data types with suitable examples. |

|3 |Explain data abstraction in Ada. |

|4 |Give an abstract specification of a stack in Ada. |

|IMPORTANT QUESTIONS |

|1 |Explain how information hiding is provided in Ada package? (April-May,2012,set-2) |

|2 |What are friend functions and friend classes? Give the reasons that Java does not have friend functions or friend classes. |

| |(April-May,2012,set-3) |

|3 |What are language design requirements for a language that supports abstract data types? (April-May,2012,set-1) |

|4 |Describe the fundamental differences between C# structs and its classes. (April-May,2012,set-4) |

|Unit – 7 Assignment QUESTIONS |

|Date of submission:26/03/2014 |

|1. |Explain basic concepts of exception handling. |

|2. |What is exception handling? How it can be implemented in Ada? |

|3. |Explain exception handling in Java. |

|4. |Discuss in detail about standard functions in prolog |

|IMPORTANT QUESTIONS |

|1 |Explain the connection between automatic theorem proving and Prolog’s inferencing process. (April-May,2012,set-4) |

|2 |What is difference between checked and unchecked exceptions in Java? Can you disable a Java Exception? How? (April-May,2012,set-3) |

|3 |What are possible frames of exceptions in Ada? How can an exception be explicitly raised in Ada? (April-May,2012,set-2) |

|4 |Explain how backtracking works in Prolog with suitable example(April-May,2012,set-1) |

|Unit – 8 Assignment QUESTIONS |

|Date of submission:07/04/2014 |

|1. |Discuss in detail about fundamentals of FPL,LISP,ML,Haskell |

|2. |Discuss about functional programming languages in detail. |

|3. |Explain the procedural & data abstraction. |

|4. |Explain about Comparisons of functional & imperative languages. |

|IMPORTANT QUESTIONS |

|1 |What are the differences between the evaluation method used for the Scheme special form DEFINE and that used for its primitive functions? |

| |(April-May,2012,set-4) |

|2 |What are the differences between CONS, LIST and APPEND. (April-May,2012,set-3) |

|3 |Write a Scheme function that takes a simple list of numbers as its parameters and returns the largest and smallest numbers in the |

| |list(April-May,2012,set-2) |

|4 |What are the ways in which ML is significantly different from Scheme(April-May,2012,set-1) |

|Subject |Database Management Systems(54013) |

|Faculty | Prof.N. Prasanna Balaji |

| |

|Text Books (to be acquired by the Students) |

|Book 1 |Data base Management Systems, Raghurama Krishnan, Johannes Gehrke, TATA McGrawHill 3rd Edition. |

|Book 2 |Data base System Concepts, Silberschatz, Korth, Sudharshan. McGraw hill, IV Edition. |

|Reference Books |

|Book 3 |Data base Management System, Elmasri Navrate Pearson Education |

|Book 4 |Introduction to Database Systems, C.J. Date Pearson Education. |

| |

|Unit |Topic |Chapters |No of Classes |

| | |Book 1 |Book 2 | | |

|II |History of Data base Systems |Ch-2 |Ch-1 | |07 |

|III |Introduction to the Relational Model |Ch-3,4 | | |07 |

|IV |Form of Basic SQL Query |Ch-5 | | |08 |

|V |Schema refinement – Problems |Ch-19 | | |07 |

|VI |Transaction Concept- Transaction | |Ch-15,16 | |07 |

|VII |Recovery and Atomicity | |Ch-17 | |08 |

|VIII |Data on External Storage |Ch-8,10 | | |05 |

|Contact classes for syllabus coverage |56 |

|Tutorial Classes |06 |

|Descriptive Tests |02 |

|Guest Lecture Classes |02 |

|Total No. of classes |66 |

| |

|Database Management Systems (54013)-- Syllabus |

|UNIT-1 |Database System Applications - Database System VS File System – View of Data – Data Abstraction – Instances and Schemas – Data Models – The |

| |ER Model – Relational Model – Other Models – Database Languages – DDL –DML – Database Access for Application Programs –Database Users and |

| |Administrator – Transaction Management – Database System Structure – Storage Manager – The Query Processor |

|UNIT-2 |History of Database Systems –Database Design and ER diagrams – Beyond ER Design Entities – Attributes and Entity Sets – Relationships and |

| |Relationship Sets – Additional features of E-R Model – Concept Design with the ER Model – Conceptual Design for Large Enterprises. |

|UNIT-3 |Introduction to Relational Model – Integrity Constraints over Relations – Enforcing Integrity Constraints – Querying Relational Data |

| |–Logical Database Design – Introduction to Views – Destroying / Altering Tables and Views. |

| |Relational Algebra – Selection and Projection Set Operations – Renaming – Joins – Division – Examples of Algebra Overviews – Relational |

| |Calculus – Tuple Relational Calculus – Domain Relational Calculus – Expressive Power of Algebra and Calculus . |

|UNIT-4 |Form of basic SQL Query – Examples of Basic SQL Queries – Introduction to Nested queries – Correlated Nested Queries Set – Comparison |

| |Operators – Aggregate Operators – NULL values – Comparison using NULL Values – Logical Connectivity’s – AND,OR and NOT – Impact on SQL |

| |Constructs – Outer Joins – Disallowing NULL Values – Complex Integrity Constraints in SQL Triggers and Active Databases |

|UNIT-5 |Schema refinement- Problem caused by redundancy-Decompositions-Problem related to decomposition-reasoning about FDS-FIRST, SECOND, THIRD |

| |Normal forms-BCNF-Lossless join decomposition-Dependency preserving Decomposition-Schema refinement in Data base Design-Multi valued |

| |Dependencies-FORTH Normal Form. |

|UNIT-6 |Transaction concept- Transaction state- Implementation of atomicity and Durability-Concurrent executions- Serializability- Recoverability- |

| |Implementation of Isolation-Testing for serializability- Lock – Based protocols- Validation based protocols – Multiple Granularity. |

|UNIT-7 |Recovery and Atomicity – Log Based recovery – Recovery with concurrent transactions – Buffer management – Failure with loss of nonvolatile |

| |storage – Advance recovery systems – Remote Backup systems |

|UNIT-8 |Data on External Storage – File Organization and Indexing – Cluster Indexes, Primary and Secondary Indexes – Index Data Structures – Hash |

| |based Indexing – Tree base Indexing – Comparison of File Organizations - Indexes and Performance Tuning – Intuitions of tree Indexes– Index |

| |sequential Access Methods ( ISAM) – B+ Trees, A dynamic Index structure. |

|Database Management Systems Assignment & Important Questions: |

| |

|Unit – 1 Assignments |

|Date of submission: 24/12/2013 |

|1. a). Discuss the reasons for storing data in a DBMS instead of in operating system files. |

|b). Indentify the main components in a DBMS and briefly explain what they do. |

|2. a) Explain the advantages of using a query language instead of custom programs to process data. |

|b) What is data independence? And how does DBMS support it? |

|3. a) Explain the database system structure. |

|b) Discuss weak entity set in ER model. |

|4. a) Explain the functionalities of database administrator. |

|b) Discuss class hierarchies and the constraints associated with them. |

|Important Questions |

|1.What is data abstraction? Discuss in detail about DML,DDL, database users and administrator |

|2. Compare and Contrast file systems versus DBMS. |

|3. Explain about various Data Models |

|4. Explain the difference between logical and physical data independence |

|5. Give the structure of DBMS and its components. |

|Unit – 2 Assignments |

|Date of submission: 09/01/2014 |

|1). a). What is an ER diagram? Discuss with suitable examples the Binary and Ternary relationships in ER diagrams |

|b). What is meant by aggregation in ER diagrams? Give a suitable example to it. |

|2. a) Define the terms: entity, entity set, attribute, key. |

|b) Discuss with an example how we can use ternary relationship instead of aggregation in ER diagrams. |

|3. a) What is a view? Discuss its role in database security. |

|b) Explain in detail the division operation in Relational Algebra. |

|4. a) What is an assertion? Discuss suitable examples. |

|b) Explain various types of join operations. |

|Important Questions |

|1.Construct an E-R diagram for a hospital with a set of patients and a set of medical doctors. Associate with each patient a log of the various |

|tests and examinations conducted. |

|2. Explain Relational Model? |

|3. Explain the following |

|(i) Key Constraints (ii) Foreign key constraints (iii) General constraints |

|4. Explain how Relational Algebra is used in Query evaluation |

|5. Explain the various operations for query Processing |

|Unit – 3 Assignments |

|Date of submission: 24/01/2014 |

| 1. a) What SQL Construct enables the definition of a relation? What constructs allow modification of relation instances? |

|b) What are the SQL constructs to modify the structure of tables and destroy tables and views? |

|2. a) What is a relation? Differentiate between a relation schema and a relation interface. |

|b) What are integrity constraints? Define the terms primary key constraints and foreign key constraint. |

|3. a) Compare nested query and correlated query. Discuss suitable examples. |

|b) What is a trigger? How are integrity constraints enforced? |

|4.a) Discuss comparison operators in SQL with suitable examples. |

|b) What is an active database? Explain. |

|Important Questions |

|1.a). Explain the set-Intersection operation. Natural-join operation, and Division operation in Relational algebra. Give suitable ex ample to each |

|of them. |

|b). Give suitable ex ample for Domain Relational Calculus. |

|2. Give differences between Embedded SQL and Dynamic SQL |

|3. Explain the QBE method for SQL |

|4. Explain the following terms |

|(i) Relational Database query (ii) Query Language |

|Unit – 4 Assignments |

|Date of submission: 07/02/2014 |

|1. a) Relational algebra and relational calculus are said to be equivalent in expressive power. Discuss. |

|b) Define all the variations of the ‘join operation’. Why is the join operation given special attention? |

|2.a) Describe the set operations of relational algebra with suitable examples. |

|b) What is the difference between tuple relational calculus and domain relational calculus? |

|3.a) Describe multi valued dependencies with examples. |

|b) Explain the problems caused by redundancy. |

|4.a) Describe functional dependencies and computation of closure of F. |

|b) Explain the need of schema refinement in detail |

|Important Questions |

|1. a). Explain clearly the aggregative operations in SQL. |

|b). Discuss about outer joins and disallowing NULL value |

|2. What does Database Schema mean? |

|3. What is normalization and how it is implemented |

|4. Explain the concept of the Functional Dependencies and multi valued Dependencies |

|5. Explain Various Normal Form in Database? |

|Unit – 5 Assignments |

|Date of submission: 26/02/2014 |

|1.Define 1NF, 2NF, 3NF and BCNF, what is the motivation for putting a relation in BCNF? What is the motivation for 3NF? |

|2. What is decomposition and how does it address redundancy? Discuss the problems that may be caused by the use of decompositions. |

|3. a) What is a schedule? Explain the distinction between the terms serial schedule and serializable schedule. |

|b) Discuss about the performance of locking. |

|4. a) What is a transaction? Explain ACID properties. |

|b) Discuss the transaction support in SQL. |

|Important Questions |

|1. . a). Discuss about schema refinement in database design. |

|b). Explain the fourth normal form with a suitable example. |

|2. Explain the ACID properties of Transaction. |

|3. What is concurrency control and list various schemes for implanting the same |

|4. What is a schedule and explain its implementation |

|Unit – 6 Assignments |

|Date of submission: 13/03/2014 |

|1. Discuss about Lock – based protocols and validation – based protocols in transaction management |

|2. what is meant by transaction state? Discuss about Timestamp based protocols. |

|3.a) Explain dead lock prevention policies employed in databases. |

|b) Briefly discuss write ahead log protocol. |

|4.a) Explain 2PL and conservative 2PL. |

|b) Briefly discuss ARIES algorithm. |

|Important Questions |

|1. a). List the ACID properties. Explain the usefulness of each. |

|b). Explain the conflict serializability with a suitable example |

|2. What is Security and List some measures to implement it |

|3. Explain the difference between media crash and system crash |

|4. Explain the various methods of Crash Recovery |

|Unit – 7 Assignments |

|Date of submission: 26/03/2014 |

|1.Discuss indetail how we can achieve recovery with concurrent transactions. |

|2. Discuss indetail the Log-based recovery and Remote backup systems. |

|3. a) What is an index? Differentiate between sparse and dense indices. |

|b) Make a comparison of sorted file organization with heap file organization. |

|4.a) What is an index? Differentiate between clustered and unclustered indices. |

|b) Make a comparison of hash file organization with sorted file organization. |

|Important Questions |

|1. Explain about buffer management and remote backup systems. |

|2. Explain various File Organization methods |

|3. What is Indexing? Explain various methods. |

|4. Explain Hashing for data management |

|Unit – 8 Assignments |

|Date of submission: 07/04/2014 |

|1.Explain about Indexed Sequential Access methods (ISAM) and B+ - trees. |

|2. Explain with suitable examples the Cluster Indexes, Primary and Secondary indexs |

|3. a) Write a detailed note on buffer management. |

|b) Explain delete operation on B+ tree structure |

|4.a) Write a detailed note on disk space management. |

|b) Is extendible hashing a dynamic indexing structure? Justify your answer. |

|Important Questions |

|1. Discuss about cluster indexes, indexed sequential file access methods and B+ trees. |

|2. Explain Memory Hierarchy? |

|3. Explain ISAM? |

|4. Explain various hashing methods? |

|Subject |Object Oriented Programming (54014) |

|Faculty |Ms.Y.Sowjanya |

| |

|Text Books |

|Book 1 |Java; the complete reference, 7th editon, Herbert schildt, TMH. |

|Book 2 |Understanding OOP with Java, updated edition, T. Budd, pearson eduction. |

|Suggested / Reference Books |

|Book 3 |An Introduction to programming and OO design using Java, J.Nino and F.A. Hosch, John wiley & sons |

|Book 4 |An Introduction to OOP, second edition, T. Budd, pearson education |

|Unit |Topic |Chapters |Total No. of |

| | | |Hours |

| | |Book1 |Book2 |Book3 | |

|II |Java Basics |Ch3,4,5,6,7 | | |7 |

|III |Inheritance |Ch8 | | |7 |

|IV |Packages and Interfaces |Ch9 | | |8 |

|V |Exception handling |Ch10 | | |7 |

|VI |Multithreading |Ch11 | | |8 |

|VII |Event Handling |Ch12, 19 | | |6 |

|VIII |Applets & Swing |Ch18 | | |8 |

|Contact classes for syllabus coverage |56 |

|Tutorial Classes |06 |

|Descriptive Tests |02 |

|Guest Lecture Classes |02 |

|Total No. of classes |66 |

| |

|Object Oriented Programming --Syllabus |

|UNIT-1 |Object oriented thinking :- Need for oop paradigm, A way of viewing world – Agents, responsibility, messages, methods, classes and |

| |instances, class hierarchies (Inheritance), method binding, overriding and exceptions, summary of oop concepts, coping with |

| |complexity, abstraction mechanisms. |

|UNIT-2 |Java Basics History of Java, Java buzzwords, datatypes, variables, scope and life time of variables, arrays, operators, expressions, |

| |control statements, type conversion and costing, simple java program, classes and objects – concepts of classes, objects, |

| |constructors, methods, access control, this keyword, garbage collection, overloading methods and constructors, parameter passing, |

| |recursion, string handling. |

|UNIT-3 |Inheritance – Hierarchical abstractions, Base class object, subclass, subtype, substitutability, forms of inheritance- |

| |specialization, specification, construction, extension, limitation, combination, benefits of inheritance, costs of inheritance. |

| |Member access rules, super uses, using final with inheritance, polymorphism- method overriding, abstract classes. |

|UNIT-4 |Packages and Interfaces : Defining, Creating and Accessing a Package, Understanding CLASSPATH, importing packages, differences |

| |between classes and interfaces, defining an interface, implementing interface, applying interfaces, variables in interface and |

| |extending interfaces. |

| |Exploring packages – Java.io |

|UNIT-5 |Exception handling -- Concepts of exception handling, benefits of exception handling, Termination or resumptive models, exception |

| |hierarchy, usage of try, catch, throw, throws and finally, built in exceptions, creating own exception sub classes. String Handling, |

| |Exploring java.util |

|UNIT-6 |Multithreading - Differences between multi threading and multitasking, thread life cycle, creating threads, thread priorities, |

| |synchronizing threads, inter thread communication, daemon threads, thread groups. Enumerations, autoboxing, annotations, generics. |

|UNIT-7 |Event Handling : Events, Event sources, Event classes, Event Listeners, Delegation event model, handling mouse and keyboard events, |

| |Adapter classes, inner classes.The AWT class hierarchy, user interface components- labels, button, canvas, scrollbars, text |

| |components, check box, check box groups, choices, lists panels – scrollpane, dialogs, menubar, graphics, layout manager – layout |

| |manager types – boarder, grid, flow, card and grib bag. |

|UNIT-8 |Applets – Concepts of Applets, differences between applets and applications, life cycle of an applet, types of applets, creating |

| |applets, passing parameters to applets. |

| |Swing – Introduction, limitations of AWT, MVC architecture, components, containers, exploring swing- JApplet, JFrame and JComponent,|

| |Icons and Labels, text fields, buttons – The JButton class, Check boxes, Radio buttons, Combo boxes, Tabbed Panes, Scroll Panes, |

| |Trees, and Tables. |

OOPS Assignment & Important Questions:

| Unit – 1 |

|Date of submission: 24/12/2013 |

|1. |What is the need of OOP paradigm? |

|2. |Explain how Java is platform independent. |

|3. |Explain the OOP Concepts? |

|4. |Explain classes and instances, class hierarchies. |

|Unit -1 Important Questions |

|1. |Write briefly on the features of Java Programming language. |

|2. |Write a java program to print the sum of positive numbers. |

|3. |Explain method binding. |

|4. |Explain class hierarchies. |

| Unit – 2 |

|Date of submission: 09/01/2014 |

|1. |Explain Type Conversion and casting with example? |

|2. |Explain with an example of nested classes. |

|3. |Write in detail on the usage of static and final keywords in java. |

|4. |What are the Control Statements? Explain with example. |

|Unit 2 Important Questions |

| |Explain Member access rules. |

| |Explain Method Overloading and Constructor Overloading with examples. |

| |Explain with an example of inner classes. |

| |Explain Parameter passing mechanism with the example of recursion |

| Unit – 3 |

|Date of submission: 24/01/2014 |

|1. |Explain with example how new classes can be derived from existing classes. |

|2. |Explain the Abstract classes with an example. |

|3. |Explain Method Overloading and Method Overriding with example. |

|4 |Explain the concept of final with inheritance. |

|Unit – 3 Important Questions |

|1 | Write in detail on interfaces and abstract classes in java language. Give any 3 interfaces and abstract classes from java. |

|2 |What are benefits of inheritance? |

|3 |What is inheritance? Explain member Access rules? Usage of SUPER Keyword in inheritance |

|4 |Explain run time polymorphism. |

| Unit – 4 |

|Date of submission: 07/02/2014 |

|1. |Explain the concept of a package and how new packages can be created and used in other classes in java. |

|2. |What are the differences between classes and interfaces? |

|3. | Give the names of classes from the packages java.io and java.util.* |

|4. |What is interface? How to implement interfaces in java? |

|Unit – 4 Important Questions |

|1 |What is package? How to create and accessing a package? |

|2 |Explain about interfaces? |

|3 |Write in detain about the usage of class path. |

| 4 |Give the names of Built-in Packages. |

| Unit – 5 |

|Date of submission: 26/02/2014 |

|1. |Explain the concept of Exception handling? |

|2. |Explain the types of exception in java with examples? |

|3. |Explain the functions of String comparisons? |

|4. |Explain how a new Exception class can be created and used in another program. |

|Unit – 5 Important Questions |

|1 |Explain Java Built-in Exceptions? |

|2 |Explain about Exception Hierarchy? |

|3 |How to create own exception? |

|4 |Explain about String Buffer? |

| Unit – 6 |

|Date of submission: 13/03/2014 |

|1. |Write briefly on multithreaded programming in java. |

|2. |Explain Thread life cycle? |

|3 |Explain inter thread communication? |

|4 |Explain the following terms. a) Enumerations b) Auto boxing |

|Unit – 6 Important Questions |

|1. |Difference between Multi threading and multi tasking? |

|2. |How to create thread? Explain |

|3. |Explain about Thread Priorities? |

|4. |Explain about Annotations? |

| Unit – 7 |

|Date of submission: 26/03/2014 |

|1. |Explain Event Delegation Model. |

|2. | Write a program on Mouse Handling events. |

|3. |Write briefly on Adapter classes and Listener classes in Java? |

|4. | Write in detail with a sample program on event handling in java. |

|Unit – 6 Important Questions |

|1 |What are layout managers? Explain in detail. |

|2 |What are the user interface components? Explain in detail |

|3 |What are the Event classes? |

|4 |Write a program on Keyboard events. |

| Unit – 8 |

|Date of submission: 07/04/2014 |

|1. | What is Applet? What are the differences between applets and applications? |

|2. | What is AWT? What are the limitations of AWT? |

|3. | Explain MVC Architecture. |

|4. |Write a java program to copy a file into another file. |

|Unit – 6 Important Questions |

|1 | Explain life Cycle of an Applet |

|2 |Create one Application using Label, Text Fields, and Buttons. |

|3 |Explain about Swing Buttons. |

|4 |Explain about JScrollPane, JComboBox, and JTable. |

|Subject |Environmental Studies (54004) |

|Faculty | Ms.M.Sudha Rani |

| |

|Text Books (to be acquired by the Students) |

|Book 1 | Environmental studies from crisisto cure by R Rajagopalan 2005 |

|Book 2 |Text book environmenta science and technology by M Anji Reddy 2007 |

|Reference Books |

|Book 3 |Environmental Studies by Anubha Kaushik & C.P. Kaushik, New Age internal (P) Ltd. |

|Book 4 |Environmental Science & Engineering by P. Anandan & P. Kyumarabelan, SCITECH publications. |

| |

|Unit |Topic |Chapters |No of Classes |

| | |Book 1 |Book 2 | |

|II |Natural resources |2 |1.4-1.11 |08 |

|III |Biodiversity and its conservation |3 |2.1-2.9 |08 |

|IV |ENVIRONMENTAL POLLUTION AND CONTROL |4 |2.10-2.18 |08 |

|V |GLOBAL ENVIRONMENTAL PROBLEMS AND GLOBAL |5 |3.1-3.14 |08 |

| |EFFORTS: | | | |

|VI |ENVIRONMENTAL IMPACT ASSESMENT (EIA) |6 |4.1-4.17 |08 |

| |AND ENVIRONMENTAL MANAGEMENT PLAN | | | |

|VII |ENVIRONMENTAL POLILCY, LEGISLATION, RULES AND |7 |5 |06 |

| |REGULATIONS | | | |

|VIII |TOWARDS |8 |-- |06 |

| |SUTAINABLE FUTURE | | | |

|Contact classes for syllabus coverage |56 |

|Tutorial Classes |06 |

|Descriptive Tests |02 |

|Guest Lecture Classes |02 |

|Total No. of classes |66 |

| |

|Environmental Studies (54004) -- Syllabus |

|UNIT-1 |I Multidisciplinary nature of environmental studies: Definition, scope importance- need for public awareness. |

|UNIT-2 |Natural resources: Renewable and non-renewable resources- Natural resources and associated problems- Forest resources – use and over – |

| |exploitation, deforestation, case studies, Timber extraction- mining, dams and other effects on forest and tribal people – water |

| |resources- use and over utilization of surface and ground water – floods, drought, conflicts over water, dams –benefits and problems of |

| |mineral resources. Use and exploitation, environmental effects of extracting and using mineral resources, case studies. Food resources: |

| |world food problems, changes caused by agriculture and overgrazing effects of modern agriculture, fertilizer- pesticide problems, water |

| |logging, salinity, case studies. – Energy resources: growing energy needs, renewable and non- renewable energy sources use of alternate |

| |energy sources, case studies. Land as a resource, land degradation, man induced landslides, soil erosion and desertification. Role of an|

| |individual in conservation of natural resources. Equitable use of resources for sustainable lifestyles. |

|UNIT-3 |Ecosystems: Concept of an ecosystem. Structure and function of an ecosystem. – producers, consumers and decomposers. – Energy flow in |

| |the ecosystem- Ecological succession. – Food chains, food webs and ecological pyramids. – Introduction, types, characteristic |

| |features, structure and function of the following ecosystems: |

| |a.Forest ecosystem b. Grassland ecosystem c. Desert ecosystem d. Aquatic ecosystems (pond, streams, lakes, rivers, oceans, |

| |estuaries) |

|UNIT-4 |Biodiversity and its conservation: Introduction- definition, genetic, species and ecosystems diversity- bio geographical classification |

| |of India – Value of biodiversity: Consumptive use, productive use, social, ethical, aesthetic and option values.- biodiversity at |

| |global, national and local levels. – India as a mega diversity nation – Hot-spots of biodiversity- threats o biodiversity: habitat loss,|

| |poaching of wildlife, man wildlife conflicts. – Endangered and endemic species of India – Conservation of biodiversity: In-situ and |

| |Ex-situ conservation of biodiversity. |

|UNIT-5 |Environmental pollution: Definition, causes, effects and control measures of: |

| |Air pollution Water pollution Soil pollution Marine pollution Noise pollution Thermal Pollution Nuclear pollution |

| |Solid waste management: Causes, effects and control measures of urban and industrial wastes. – Role of an individual in prevention of |

| |pollution. – Pollution case studies. – Disaster management: floods, earthquake, cyclone and land slides. |

|UNIT-6 |Social issues and the environment: From unsustainable development to sustainable development – urban problems related to energy – water |

| |conservation, rain water harvesting, watershed management- resettlement and rehabilitation of people; Its problems and concerns. Case |

| |studies – environmental ethics: Issues and possible solutions. – climate change, global warming, acid rain, ozone later depletion, |

| |nuclear accidents and holocaust., case studies. – Waste land reclamation, Consumerism and waste products, Environmental protection act. |

| |–Air (prevention and control of pollution) act.- Water (prevention and control of pollution) act – wildlife protection act – Forest |

| |conservation act –issues involved in enforcement of environmental legislation – public awareness. |

|UNIT-7 |Human population and the environment: Population growth, variation among nations. Population explosion – Family welfare programme. – |

| |environment and human health. – human rights. – value education. – HIV/AIDS. Women and child welfare. -Role of information technology in|

| |environment and human health. Case studies. |

| |visit to a local area to visit document environmental assets river/ forest/grassland/hill/mountain – visit to a local pollution site- |

|Unit-8 |urban/ rural/ industrial/ agricultural -study of common plants, insects, birds. – study of simple ecosystems – ponds, river, hill |

| |slopes, etc. |

| Environmental Studies -- Assignments |

|Unit-I Assignments Questions |

|Date of submission: 24/12/2013 |

|1. |Give an account of objectives of Environmental education |

|2. |Definition of ecosystem? Scope and importance |

|3. |Explain ecological pyramids and their importance? |

|4. |Explain the nitrogen and carbon cycle? |

|Unit – 1 Important Questions |

|1 |Explain Classification Of Ecosystem |

|2 |Explain the functions of food chains and food webs |

|3 |Explain the values of eco systems |

|4 |Write about the bio-magnification |

|Unit-II Assignments Questions |

|Date of submission: 09/01/2014 |

|1. |Define environment. Write environmental problems due to over utilization of natural resources. |

|2. |Write about renewable and non-renewable energy resources. |

|3. |Effects of deforestation on tribal people with case studies. |

|4. | Environmental impacts of dams with case studies. |

|Unit – 2 Important Questions |

|1 |Write about the water resources |

|2 |Explain landslides and land use /land cover mapping |

|3 |Explain the mineral resources |

|4 |Write about the energy resources |

|Unit-III Assignments Questions |

|Date of submission: 24/01/2014 |

|1. |Write about –value of biodiversity, conservatism of biodiversity, threats to biodiversity |

|2. |Indian endangers flora and fauna |

|3. |write about the hotspots of biodiversity |

|4. | explain about the In-situ and Ex-situ conservation |

|Unit–3 Important Questions |

|1 |Define genetic species and Eco –system diversity \ |

|2 | explain the threats to bio-diversity |

|3 |explain man and wild life conflicts |

|4 |explain food resources |

|Unit-IV Assignments Questions |

|Date of submission: 07/02/2014 |

|1. |What are air pollutants, and where do they come from? |

|2. |What are the harmful effects of air pollutants? |

|3. |What is eutrophication, and write about water pollutants. |

|4 |Write about soil pollutants, solid waste disposal techniques, disaster management. |

|Unit–4 Important Questions |

|1 |How to control noise pollution. |

|2 |write about the water pollution |

|3 |soil pollution |

|4 |thermal pollution |

|Unit-V Assignments Questions |

|Date of submission: 26/02/2014 |

|1. |Write about the green house effect |

|2. |write about the global warming |

|3. |ozone depletion |

|Unit–5 Important Questions |

|1 |explain the green house effect of gases |

|2 |explain the increasing of sea levels and climate change |

|3 |earth summit Kyoto proto call and montreal protocol |

|4 |Write about the chloroflouro carbons and halo carbons |

|Unit-VI Assignments Questions |

|Date of submission: 13/03/2014 |

|1. |Write about Environmental Assessment |

|2. |environmental managent plan |

|3. |Explain green belt-development movement |

|4 |Write about the human health flora fauna and society |

|Unit–6 Important Questions |

|1 |Write about the positive and negative reversible irreversible impacts |

|2 |Explain about the technological solutions |

|3 |Explain the rain water harvesting |

|4 |Explain the methods of EIA |

|Unit-VII Assignments Questions |

|Date of submission: 26/04/2014 |

|1. |explain the environmental protection act and water act |

|2. |explain the municipal solid waste management and handling rules |

|3. |explain the bio- medical waste management |

|4. |explain the forest conservation act |

|Unit–7 Important Questions |

|1 |write about the air pollution act |

|2 |water pollution cess |

|3 |bio medical handling rules |

|4 |municipal solid waste management |

|Unit-VIII Assignments Questions |

|Date of submission: 07/04/2014 |

|1. |Explain the concept of sustainable development |

|2. |explain environmental education |

|3. |concept of green building |

|4. |clean development mechanism |

|Unit–8 Important Questions |

|1 |Population and explosion |

|2 |Conservation of resources |

|3 |Urban sprawl and sustainable cities |

|4 |Role of IT in environment |

|Subject | Probability And Statistics |

|Faculty | Mr.K.Santhosh Kumar |

|Text Books (to be acquired by the Students) |

|Book1 |A text Book of Probability and Statistics, by T. K. V. Iyengar, B. Krishna Gandhi and Others.S.Chand publications. |

|Reference Books |

|Book1 |Probability and Statistics by William Mendenhall and others.Cengage publications. |

|Book2 |Probability and Statistics for Engineers by G.S.S.Bhisma Rao, Scitech publications |

|Book3 |Higher Engineering Mathematics by B.S.Grewal, Khanna publications. |

|Book 4 |Probability and Statistics for Engineers, Miller and John E.Freund, Prentice Hall of India. |

| |

|Unit |Topic |Chapters |No of Classes |

| | |Book 1 |Book 2 |Book 3 | |

|II |Distributions |2 |2 |2 |08 |

|III |Testing of Hypothesis-1 |3 |3 |3 |07 |

|IV |Testing of Hypothesis-2 |4 |4 |4 |07 |

|V |Small Samples |5 |5 |5 |07 |

|VI |Correlation and Regression |6 |6 | 6 |07 |

|VII |Queuing Theory |7 |7 |7 |06 |

|VIII |Stochastic Process |8 |8 |8 | 06 |

|Contact classes for syllabus coverage |56 |

|Tutorial Classes |06 |

|Descriptive Tests |02 |

|Guest Lecture Classes |02 |

|Total No. of classes |66 |

JNTU Syllabus

|Unit – I |Sample Space and events – Probability- the axioms of probability- some elementary theorems- conditional probability- Baye’s theorem-|

| |Random variables- discrete and continuous |

| | |

|Unit – II |Binomial, Poisson and Normal Distributions – Related properties. Sampling distributions-Sampling distributions of means (σ known and|

| |unknown) |

|Unit – III |Tests of hypothesis point estimations- interval estimations baysian estimation. Large samples, Null hypothesis- Alternative |

| |hypothesis, Type-1 and Type2 errors- critical region confidence interval for mean – testing of single variance- difference between |

| |the mean. |

|Unit – IV |Confidential interval for the proportions – test of hypothesis for the proportions single and difference between the proportions. |

|Unit – V |Confidence interval for the t distribution – tests of hypothesis- t distribution, F-distribution Chi-Square distribution. |

|Unit – VI |Coefficient of correlation- regression coefficient – the lines of regression- the rank correlation. |

|Unit – VII |Arrival theorem – pure birth and death process – M/M/1 Model. |

|Unit – VIII |Introduction to Stochastic Process- Markov process classification of states- exaples of Markov chains, stochastic matrix, limiting |

| |probabilities. |

| Probability and Statistics Assignment |

| |

|Unit-I |

|Date of submission: 24/12/2013 |

|1. |State and prove the addition theorem of probability |

|2. |In a certain town 40% have brown hair, 25% have brown eyes and 15% have both brown hair and brown eyes. A person is select at random|

| |from the town |

| |If he has brown hair, what is the probability that he has brown eyes also |

| |If he has brown eyes, determine the probability that he does not have brown hair |

|3. |In a bolt factory machines A,B,C manufacture 20%,30% and 50% of the total of their output and 6%,3%,and 2% are defective. A bolt is |

| |drawn at random and found to be defective. Find the probabilities that it is manufactured from |

| |i Machine A ii. Machine B iii. Machine C |

|4. | State and prove Bayes theorem |

|Unit-II |

|Date of submission: 09/01/2014 |

|1. |Find the mean and variance of Binomial distribution. |

|2. |Prove that Poisson distribution is the limiting case of binomial distribution |

| |For very large number of trails with very small probability. |

|3. |Define Poisson distribution and find its variance and the mean |

|4. |Find the mean and standard deviation of a normal distribution in which 7% of items are under 35 and 89% are under 63 |

|Unit-III |

|Date of submission: 24/01/2014 |

|1. |Write the properties of Estimators |

|2. |Define i. one and two tailed tests ii. Type I and Type II Errors. Iii level of significance |

|3. |What is Interval Estimation. Give the relations used to find the confidence |

|4. |A sample of size 400 is taken from a population whose standard deviation is 16. Find the standard error and probable error. |

|Unit-IV |

|Date of submission: 07/02/2014 |

|1. |A random sample of 400 items is found to have mean 82 and S.D. of 18. Find the maximum error of estimation at 95% confidence |

| |interval. Find the confidence limits for the mean if x= 82. |

|2. |20 people were attacked by a disease and only 18 survived will you reject the hypothesis that the survival rate if attacked by this |

| |disease is 85% in favour of the hypothesis that is more at 5% level. |

|3. |In a large consignment of oranges a random sample of 64 oranges revealed that 14 oranges were bad. If it reasonable to ensure that |

| |20% of the oranges are bad. |

|4 |Explain the procedure generally followed in ‘Testing of Hypothesis |

|Unit-V |

|Date of submission: 26/02/2014 |

|1. |Write the properties of t- distribution |

|2. |The manufacture of a certain make of electric bulbs clains that his bulbs have a mean life of 25 months with a S.D of 5 months . A random|

| |sample of 6 such bulbs gave the following values. Life of months 24,26,30,20,20,18. Can you regarded the producers, claims to be valid at|

| |i% level of significance. |

|3. |The following is the distribution of hourl.y number of trucks arriving at a company’s Ware house: |

| | |

| |No of trucks |

| |0 |

| |1 |

| |2 |

| |3 |

| |4 |

| |5 |

| |6 |

| |7 |

| |8 |

| | |

| | |

| |Frequency |

| |52 |

| |151 |

| |130 |

| |102 |

| |45 |

| |12 |

| |5 |

| |1 |

| |2 |

| | |

|4. |A die is thrown 60 times with the following results. |

| | |

| |Face |

| |1 |

| |2 |

| |3 |

| |4 |

| |5 |

| |6 |

| | |

| |Frequency |

| |8 |

| |7 |

| |12 |

| |8 |

| |14 |

| |11 |

| | |

| | |

|Unit-VI |

|Date of submission: 13/03/2014 |

|1. |Customers arrive at a sales counter manages by a single person according to a poisson process with a mean rate of 20 per hour. The time |

| |required to serve a customer has an exponential distribution with mean of 100 seconds. Find the average waiting time of customer |

|2. |What are the assumptions of single channel Queue |

|3. |At a election commission office, for the Voter’s Card, a Photographer takes passport size at an average rate of 24 photos per hour. The |

| |photographer must wait until the voter blinks or scowls, so the time to take a photo is exponentially distributed. Customers arrives at |

| |poisson distributed average rate of 20 voters per hour. Find. |

| |What is the utilization of photographer. |

| |How much time, the voter has to spend at the election commison office on an average. |

| |

|Unit-VII |

|Date of submission: 26/03/2014 |

|1. |Define stoachproce ? |

|2. |Explan Marco chine? |

|3. |Check whether the following matrices are stoachproces are not? |

|Unit-VIII |

|Date of submission: 07/04/2014 |

|1. |A manager of a local hamburger restaurant is prrparing to open a new fast food restaurant called Hasty Burgers. Based on the arrival |

| |rates at existing outlets. Manager expects customers to arrive at the drive in window according to a Poisson distribution, with a mean of|

| |20 customers per hour. The service rate is flexible, however the service times are expected to follow an exponential distribution . The |

| |drive in window is single ever operation. |

| |What service rate is needed to keep the average number of customers in the service system to 4 |

| |For the service rate in part (i) what is he probability that more than 4 customers are in the line and being served. |

|2. |Explain the procedure generally followed in ‘Testing of Hypothesis”. |

|3. |Measurements of the weights of a random sample of 200 ball bearing made by a certain machine during one week showed a mean of 0.824 and a|

| |standard deviation of 0.042. Find maximum error at 95% confidence interval. Find the confidence limits for the mean if x=32. |

|Subject |Design and Analysis Of Algorithms (54016) |

|Faculty | Ms. Swetha EnReddy |

|Text Books (to be acquired by the Students) |

|Book 1 |Fundamentals of Computer Algorithms, Ellis Horowitz,Satraj Sahni and Rajasekharam, Galgotia publications pvt. Ltd. |

|Book 2 |Algorithm Design: Foundations, Analysis and Internet examples, |

| |M.T.Goodrich and R.Tomassia, John Wiley and sons. |

|Reference Books |

|Book 3 |Introduction to Algorithms, secondedition,T.H.Cormen,C.E.Leiserson, |

| |R.L.Rivest,and C.Stein,PHI Pvt. Ltd./ Pearson Education |

|Book 4 |Design and Analysis of algorithms, Aho, Ullman and Hopcroft,Pearson |

| |Education . |

|Unit |Topic |Chapters |No of Classes |

| | |Book 1 |Book 2 | | |

|II |Disjoint Sets |2 |1 | |07 |

|III |Divide and conquer |3 |2 | |07 |

|IV |Greedy method |4 |3 | |07 |

|V |Dynamic Programming |5 |4 | |07 |

|VI |Backtracking |6 |5 | |07 |

|VII |Branch and Bound |8 |7 | |06 |

|VIII |NP-Hard and NP-Complete problems |9 |11 | |07 |

| Contact classes for syllabus coverage |56 |

|Tutorial Classes |06 |

|Descriptive Tests |02 |

|Guest Lecture Classes |02 |

|Total No. of classes |66 |

Syllabus Design And Analysis Of Algorithms

|Unit – I |Introduction: Algorithm, Pseudo code for expressing algorithms, Performance Analysis-Space complexity, Time complexity, Asymptotic |

| |Notation- Big oh notation, Omega notation, Theta notation and Little oh notation ,Probabilistic analysis, Amortized analysis. |

|Unit – II |Disjoint Sets- disjoint set operations, union and find algorithms, spanning trees, connected components and biconnected components.|

|Unit – III |Divide and conquer: General method , applications-Binary search, Quick sort, Merge sort, Strassen’s matrix multiplication. |

|Unit – IV |Greedy method: General method, applications-Job sequencing with dead lines, 0/1 knapsack problem, Minimum cost spanning trees, |

| |Single source shortest path problem |

|Unit – V |Dynamic Programming: General method, applications-Matrix chain multiplication, Optimal binary search trees, 0/1 knapsack problem, |

| |All pairs shortest path problem, Travelling salesperson problem, Reliability design. |

|Unit – VI |Backtracking: General method, applications-n-queen problem, sum of subsets problem, graph coloring, Hamiltonian cycles. |

|Unit –VII |Branch and Bound: General method, applications - Traveling sales person problem,0/1knapsack problem- LC Branch and Bound solution, |

| |FIFO Branch and Bound solution |

|Unit –VIII |NP-Hard and NP-Complete problems: Basic concepts, non deterministic algorithms, NP -Hard and NP Complete classes, Cook’s theorem. |

|Design And Analysis Of Algorithms -- Assignments |

|Unit-I Assignments Questions |

|Date of submission: 24/12/2013 |

|1. |Define an algorithm. Describe the characteristics of the algorithm. |

|2. |Explain the asymptotic notations used in algorithm analysis. |

|3. |Define space complexity? Explain how to find space complexity of an algorithm with an example. |

|4. |Write an algorithm for finding the Fibonacci sequence and derive its time complexity. |

|Unit – 1 Important Questions |

| |Define time complexity, Describe different asymptotic notations used to represent the time complexities with suitable examples |

| |Explain the asymptotic notations used in algorithm analysis. |

| |Compare Big-oh notation and Little-oh notation. Illustrate with an example |

| |Describe the performance analysis in detail. |

|Unit-II Assignments Questions |

|Date of submission: 09/01/2014 |

|1. |Write an algorithm for UNION and FIND. |

|2. |Write a short note on spanning tree? |

|3. |Briefly explain about connected and biconnected components. |

|4. |Develop algorithms for UNION and FIND using weighing rule and collapsing |

| |rule respectively |

|Unit – 2 Important Questions |

|1 |Develop algorithms for UNION and FIND using weighing rule and collapsing rule respectively. |

|2 |Explain the usefulness of the following fundamental operations on sets: |

| |i) FIND ii) DELETE iii) UNION iv) INSERT |

|3 |Two sets S1 and S2 are given as below |

| |S1={1,2,4,6} and S2 ={7,8} |

| |a) Draw disjoint sets S1 and S2 using Trees |

| |b) Draw disjoint sets S3 using Trees such that S3=S1 U S2 |

| |c) Draw disjoint sets S4 using Trees such that S4=S2 U S1 |

| |d) Give Pointer representation of S1, S2, S3 and S4. |

|4 |Write and explain the final algorithm for collapse rule with an example. |

|Unit-III Assignments Questions |

|Date of submission: 24/01/2014 |

|1. |Write and explain the control abstraction for Divide and conquer and give the time complexity. |

|2. |Discuss Strassen’s matrix multiplication. |

|3. |Derive time complexity for Strassen’s matrix multiplication |

|4. |Derive time complexity for Quick sort. |

|Unit–3 Important Questions |

|1 |Discuss Strassen’s matrix multiplication and derive the time complexity. |

|2 |By applying Divide and Conquer strategy, write a recursive algorithm for finding the maximum and the minimum element from a list. |

|3 |Show how quick sort sorts the following sequences of keys in ascending order. |

| |12, 25, 35, 43, 48, 59, 77, 85, 86, 94? |

|4 |Show how Merge sort sorts the following sequences of keys in ascending order. |

| |12, 22, 33, 44, 48, 56, 57, 65, 76, 84 with a neat diagram representing sequence of recursion calls? |

|Unit-IV Assignments Questions |

|Date of submission: 07/02/2014 |

|1. |What is Greedy method? Write control abstraction for Greedy method. |

|2. |What is the solution generated by the function Job sequencing when N=7, (P1, P2, … …P7) = (3, 5, 20, 18, 1, 6, 30) and (d1, d2, … d7)|

| |= (1, 3, 4, 3, 2, 1, 2) |

|3. |Consider the following instances of Knapsack problem for n=3 (no. of objects) , m=20(maximum capacity of knapsack) with profits |

| |(p1,p2,p3) =(25,24,15) and weights(w1,w2,w3) =(18,15,10).Find the optimal solution using Greedy method. |

|4 |Write and explain single source shortest path algorithm with an example. |

|Unit–4 Important Questions |

|1 |What is Greedy method and discuss its applications. |

|2 |Write Kruskals algorithm that generates minimum spanning tree for every |

| |connected undirected graph. |

|3 |Find the feasible solution for job sequencing with deadlines for the instance n=5, |

| |(P1,…,P5)=( 20, 15, 10, 5, 1) and (d1,…,d5)= (2,2,1,3,3). |

|4 |Find an optimal solution to the Knapsack instance n=7, m=15, and (P1,P2,...P7)= |

| |(10,5,15,7,6,18,3) and (W1,W2,...W7)= (2,3,5,7,1,4,1). |

|5 |Explain the terms Feasible solution, optimal solution and objective function. |

|Unit-V Assignments Questions |

|Date of submission: 26/02/2014 |

|1. |Define merging and purging rules in 0/1 Knapsack problem. |

|2. |Solve the following 0/1 Knapsack problem using dynamic programming |

| |P= (11, 21, 31, 33), W= (2, 11, 22, 15), C=40, n=4. |

|3. |Consider three stages of a system with r1=0.3, r2=0.5, r3=0.2 and c1=30, c2=20, c3=30 Where the total cost of the system is C=80 and |

| |u1=2, u2=3, u3=2 find the reliability design. |

|4. |Explain matrix chain multiplication with an example. |

|Unit–5 Important Questions |

|1 |Solve the following 0/1 Knapsack problem using dynamic programming P= (11, 21, 31, 33), W= (2, 11, 22, 15), C=40, n=4. |

|2 |Consider three stages of a system with r1=0.3, r2=0.5, r3=0.2 and c1=30, c2=20, c3=30 Where the total cost of the system is C=80 and |

| |u1=2, u2=3, u3=2 find the reliability design. |

|3 |Find the minimum no of operations required for the following chain matrix multiplication using dynamic programming. A(30,40) * B(40,5) * |

| |C(5,15) * D(15,6). |

|4 |Differentiate between Greedy method and Dynamic programming. |

|5 |Design a three stage system with device types D1, D2, D3. The costs are Rs.30, Rs.15 and Rs.20 respectively. The cost of the system is to|

| |be not more than Rs.105. The reliability of each device type is 0.9, 0.8 and 0.5 respectively. |

|Unit-VI Assignments Questions |

|Date of submission: 13/03/2014 |

|1. |State and explain the n-Queen problem using backtracking. |

|2. |Explain general method of backtracking. |

|3. |Draw the state space tree for m coloring when n=3 and m=3. |

|4 |Explain sum of subset problem with an example. |

|Unit–6 Important Questions |

|1 |Explain the Back Tracking Strategy with an example. |

|2 |State and explain the n-Queen problem using backtracking. |

|3 |Draw the portion of the state space tree for m-colorings of a graph. |

|4 |Explain sum of subset problem with an example. |

|Unit-VII Assignments Questions |

|Date of submission: 26/04/2014 |

|1. |Write the control abstraction of LC search. |

|2. |Describe problem state, solution state and answer state with an example. |

|3. |Explain the general method of Branch and Bound. |

|4. |What is bounding? Explain the principles of bounding. |

|Unit–7 Important Questions |

|1 |Generate FIFO branch and bound on the traveling salesman problem and find the solution space tree. |

|2 |What is bounding? Explain the principles of bounding. |

|3 |Differentiate between Backtracking and Branch & Bound technique by considering 4-queen problem |

|4 |Write an algorithm to solve the Knapsack problem with the Branch and Bound. |

|Unit-VIII Assignments Questions |

|Date of submission: 07/04/2014 |

|1. |Explain the classes of P and NP. |

|2. |State and explain cook’s theorem. |

|3. |Explain non deterministic algorithms? Give some examples? |

|4. |Write a nondeterministic Knapsack algorithm. |

|Unit–8 Important Questions |

|1 |State and explain cook’s theorem and also discuss about NP complete classes |

|2 |Write a nondeterministic Knapsack algorithm. |

|3 |Explain about different types of NP problem. |

|4 |Describe clique decision problem and write the algorithm for the same. |

Object Oriented Programming -- Lab

Lab [Subject Code: 54618]

For the Academic year 2013-14

II B Tech Semester II– [IT]

Syllabus Programs (JNTU)

Objectives:

• To make the student learn an object oriented way of solving problems.

• To make the student write ADTS for all data structures.

Recommended systems/Software Requirements:

• Intel based desktop PC with minimum of 166 MHZ or faster processor with at least 64MB RAM and 100MB free disk space

|Week 1 |Name of the program |

|1 |Write a Java program that prints all real solutions to the quadratic equation ax2+bx+c=0. Read in a,b,c and use the quadratic |

| |formula. If the discriminant b2-4ac is negative, display a message stating that there are no real solutions. |

|2 |The Fibonacci sequence is defined by the following rule. |

| |The first two values in the sequence are 1 and 1. Every subsequent value is the sum of the two values preceding it. Write a Java |

| |program that uses both recursive and non recursive functions to print the nth value in the Fibonacci Sequence. |

|Week-2 | |

|3 |Write a java program that prompts the user for an integer and then prints out all prime numbers up to that integer. |

|4 | Write a java program to multiply two given matrices. |

|5 |Write a java program that reads a line of integers , and then displays each integer, and the sum of all the integers(use string |

| |tokenizer class of java.util) |

|Week-3 | |

|6 |Write a java program that checks whether a given string is a palindrome or not |

|7 |Write a java program for sorting a given list of names in ascending order. |

|8 |Write a java program to make frequency count of words in a given text. |

|Week-4 | |

|9 |Write a java program that reads a file name from the user, then displays information about whether the file is readable, whether the|

| |file is writable, the type of file and length of the file in bytes. |

|10 |Write a java program that reads a file and displays the file on the screen, with a line number before each line. |

|11 | Write a java program that displays the number of characters, lines and words in a text file. |

|Week-5 | |

|12 |Write a java program that : |

| |Implements ADT. |

| |Converts infix expression into postfix form. |

| |Evaluates the post fix expression. |

|Week-6 | |

|13 |Develop an Applet that develops a simple message. |

|14 |Develop an Applet that receives an integer in one text field , and computes its factorial values and returns it in another text |

| |field, when button named “compute “is clicked |

|Week-7 | |

|15 |Write a java program that works as a simple calculator. Use a grid lay out to arrange buttons for the digits and for the +,-,*.% |

| |operators. Add a text field to display the result. |

|Week-8 | |

|16 |Write a java program for handling mouse events. |

|Week-9 | |

|17 |Write a java program that creates that threads. First thread displays “Good Morning” every one second , the second thread display |

| |“Hello” , every third thread displays “welcome “ every three seconds. |

|18 |Write a java program that currently implements producer and consumer problem using the concept of inter thread communication. |

|Week-10 | |

|19 |Write a java program that creates a user interface to perform integer divisions. The er enters two numbers in to the text |

| |fields,num1,and num2. The division of num1 and num2 is displayed in the result field when the divide button is clicked. If num1 and |

| |num2 are not integer, the program would through a number format exception. If Num2 were zero the program would throw an arithmetic |

| |exception. Display the exception in the message dialog box. |

|Week-11 | |

|21 |a>Write a java program that simulates a traffic light. The program lets the user one of the three lights : red, yellow, or green. |

| |When a radio button is selected, the light is turned on , and only one light can be on at a time . No light is turned on When the |

| |program starts. |

| |b> Write a java program that allows the user to draw lines, rectangles |

| |and ovals. |

|Week-12 | |

|22 |Write a java program to create an abstract class named Shape that contains an empty method named numberOfsides(). Provide three |

| |classes named Trapezoid, Triangle and Hexagon such that each one of the classes extends the class Shape. Each one of the classes |

| |contain only the meth od numberOfsides( ) that shows the number of sides in the geometrical figures. |

| |Suppose that a table named Table.txt is stored in a text file. The first line in the file header, and the remaining lines |

| |corresponds to rows in the table. The elements are separated by commas. Write a Java program to display the table using Jtable |

| |component. |

Database Management Systems Lab [Subject Code: 54619]

For the Academic year 2013-14

II B Tech Semester II– [IT]

List of Lab Exercises

Syllabus Programs (JNTU)

|Week 1 |Name of the program |Page.no |

| |E.R Model. | |

|1 |The student is required to submit a document by writing the Entities and keys to the lab teacher. | |

| |Entities | |

| |1.Bus 2.Ticket 3.Passenger | |

|2 |Reservation: | |

| |1. reservation 2.Cancellation | |

|Week-2 | | |

| |Concept design with E-R Model | |

| | The student is required to submit a document by drawing the E-R Diagram for bus/Ticket/Passenger to the Lab Teacher | |

|Week-3 | | |

| |Relation Model | |

| |The Student is required to submit a document by represent relationship in a tabular fashion to the lab teacher? | |

| |Example: Name Age Sex Address Ticket_id | |

|Week-4 | | |

| |Normalization | |

|Week-5 | | |

| |Installation of Mysql and Practicing DDL Commands | |

| |Detailed Creation of tables is given at the end. | |

| |Create a Table for passenger? | |

|Week-6 | | |

| |Practicing of DML Commands | |

| | | |

|Week-7 | | |

|15 |Queries | |

| |Display unique PNR_no of all Passenger? | |

| |Display all names of male passenger? | |

| |Display the ticket numbers and names of all the passenger? | |

| |Find the names of passengers whose age is between 30 and 45? | |

| |Display all passenger names beginning with ‘A’? | |

|Week-8 | | |

| |Querying continued.. | |

| |Write a Query to display the Information Present in the Passenger and cancellation tables | |

| |Find number of tickets booked for each PNR_no using GROUP BY CLAUSE. | |

| | | |

|Week-9 |Querying continued.. | |

| |Display the number of days in a week on which the 9w01 bus is available. | |

| |Find the total number of cancelled seats. | |

|Week-10 | | |

| |Triggers | |

| |Create an insert trigger, delete trigger, update trigger? | |

|Week-11 | | |

| |Procedure | |

| | | |

| |Create the stored procedure, Execution of procedure, and modification of procedure? | |

|Week-12 | | |

| |Cursors | |

| |Declare a cursor that defines a result set | |

Guru Nanak Engineering College

Ibrahimpatnam, R R District – 501 506 (A. P.)

Assignment / Record No - _____

Department of ________________________

|Name |: |______________________________________ |

|Class / Year / Semester |: |B. Tech ______ Year __________ Semester |

|Roll No. |: |_________________________ |

|Subject |: |_________________________ |

|Branch |: |_________________________ |

|Date of Submission |: |_____ / _____ / __________ |

|________________ | |________________ |

| | | |

|Student Signature | |Faculty Signature |

Index Page

|S. No. |Date |Program / Experiment |Page No. |Sign / Remarks |

| | | | | |

| | | | | |

| | | | | |

| | | | | |

| | | | | |

| | | | | |

| | | | | |

| | | | | |

| | | | | |

| | | | | |

| | | | | |

| | | | | |

| | | | | |

| | | | | |

| | | | | |

| | | | | |

| | | | | |

| | | | | |

| | | | | |

| | | | | |

| | | | | |

| | | | | |

| | | | | |

| | | | | |

| | | | | |

| | | | | |

| | | | | |

| | | | | |

| | | | | |

| | | | | |

| | | | | |

| | | | | |

| | | | | |

| | | | | |

| | | | | |

| | | | | |

| | | | | |

| | | | | |

Guru Nanak Engineering College

Ibrahimpatnam, R R District – 501 506 (A. P.)

(Sponsored by: Guru Nanak Educational Society, Hyderabad (A. P.)

Department of ________________________

|This is to certify that |

|Name |: |______________________________________ |

|Class / Year / Semester |: |B. Tech ______ Year __________ Semester |

|Roll No. |: |_________________________ |

|Subject |: |_________________________ |

|Branch |: |_________________________ |

|Has successfully completed the course of programs / experiments prescribed by Jawharlal Nehru Technological University of the department |

|during the academic year 2013 – 2014. |

|________________ | |________________ |

| | | |

|Faculty Incharge | |Department Head |

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

Annexure - 1

Annexure - 2

Annexure - 3

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

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download