I – SEMESTER : COMPUTER SCIENCE-I

(Introduction to computers & Programming)

UNIT-I
Introduction to Computers - Role of computers, Definition, Characteristics and
Applications, Generations of Computer, Basic block diagram, CPU, Primary and Secondary
storage devices and I/O Devices. Information Concepts: Data and its representation,
Information and its characteristics, Categories of information, Number System: basic
concepts, converting from one system to another, Introduction System software and
Application Software. Generation of computer languages, types of languages, Language
translators-Assembler, Interpreter, compiler, Link and Loader. Introduction to Computer
Networks, History and usage of Internet, Browser and its types, Domain Name System (DNS),
WWW, Electronic Mail (e-mail) , Search Engines and Intranets.

UNIT-II
Introduction to Programming - definitions and developing Algorithms and flowcharts for
simple programs. Introduction to C Programming: Origin and history of c programming,
character set, Identifiers and keywords data types, constants, variables, operators, symbolic
constants, Expressions, compound statements, structure of C Program, Input and output
function.

UNIT-III
C Statements – selection statements- if ,nested if’s, the if-else-if ladder the conditional
expressions, switch statement nested switch statements, iteration statements- the for loop, for
loop variations, the while loop, ,the do-while loop, declaring variables within selection and
iteration statements, jump statement, the rwturn statement, the go to statement, break
statement, exit() function, the continue statement, expression statement. Block statements

UNIT-IV
Arrays- Array What is an array?-Array Declaration, Array Initialization-Accessing individual
elements of an array-Two Dimensional Arrays- -Passing an array element to a function-Rules
of using an array What are strings? String I/O, String Manipulation .Functions - The General
Form of a Function,elements of function ,function categories, types of functions, Function
Arguments Call by Value, Call by Reference , return Statement. Uses of functions. C pre-
processor, storage classes-Automatic, Register, Static and external.

Recommended Text and Reference Books:

1. Let Us C by Yashwanth Kanetkar

2. “Programming in ANSI C “ by E-Balaguruswamy
3. Complete Reference of C++by Herbert Schilde
4. Introduction to Computers with MS-Office -2000 by Alwxis Lecon & Mathew Lecon
5. Introduction to Computers by Peter Norton
6. Introduction to Information Technology –Breaking Wave.
 I SEMESTER : COMPUTER SCIENCE LAB-1
(Introduction to computers & Programming-Lab)

PC-tools

I. MS WORD
1) Design a visiting card for Managing Director of A Company with the following
specifications
1. Size of Visiting card is 3.5” x 2”
2. Name of a company with Big Font using water mark
3. Phone No, Fax No, and email address with appropriate symbols
4. Office and Residence Address Separated by line.
2) Create a letter head of a company
1. Name of company on the top of the page with big font and good style.
2. Phone no, fax No and e-mail address with appropriate syllabus.
3. Main products manufactured to be described at the bottom
4. Slogans if any should be specified
3) Create of Your Bio-Data: Consisting Name, e-mail-id, Contact Address, Career Objective,
Educational Qualifications, Social Activities, Achievements
4) Creation of word document involving all Mathematical functions and symbols.
5) Use the mail merge option to write letters to your friends for inviting them to dinner on
the occasion of your birth day.
6) Create templates for Notices, Question papers, Programs, CVs, Leave Application etc.

II. MS EXCEL
7) Create an electronic spread sheet in which you enter the following decimals numbers and
convert Octal, Hexadecimals and Binary numbers Vice Versa.
Solve the following using function
1. Concatenate two texts
2. Length of the text
3. Trim the text
8) Create worksheet with the following columns Employee code, Name, Age, Department,
salary Enter the data into the worksheet and do the following with auto filter option.
1. Find the employees whose age is greater then 25
2. find the employees whose names starts with letter s’
3. Find the employees who are belonging to particular department
4. Find all employees who are belonging to the comp. department and salary is greater
then 5000.
9) Create the work sheet with the following information S.no, faculty , Class, teaching
subjects, no of classes(weekly)
Find the following with the advanced filter option
1. Names of the faculty who are teaching for BSc I st year
2. Teaching subjects of the particular faculty
3. Find the records whose faculty name is ‘y’ or teaching subject is ‘x’
4. Find the records whose teaching subject is ‘xx’ and no of classes greater than 18.

10) Prepare the following worksheet

a) The ABC Company shows the sales of different products for 5 years. Create Bar
graph and Pie, 3D chart for the following
 A B C D E

Year Product –I Product –II Product –III Product -IV

1 2006 1000 800 900 1000

2 2007 800 80 500 900

3 2008 190 190 400 300

4 2009 1200 200 300 1000

5 2010 1300 400 400 1200

b) Calculate the pay of the employees following the conditions given below
(pay roll for the month of Jan 2007)

A B C D E F G H I
Emp.No Emp.Name Basic DA HRA GPF GROSS IT Net pay

1 10002 RAVALI 8000

A : 56 % of the basic pay if basic pay <8000 else 44 %

HRA :12.5% of the basic pay subject to a maximum of Rs.1000
GPF 10% of the basic pay
Income Tax: Take the rates prevailing present?
Find who is getting Biggest salary? Who is the lowest?

11) a) Create the work sheet with the following columns

Project number, Project name, development organization , software used , cost. Enter the
data into the work sheet and sort on the basis of
1. Cost
2. Software used
3. Development organization, software used ,cost
b) Create a macro to enter a series of dates across one row of worksheet
Centre the date in each cell and then apply border format to the row.

III. MS ACCESS

12) a) Create a table Order with the following fields

1. Order_id
2. Customer_id
3. customer name
4. employee_id
5. order_date
 6. Purchaseorder_number
Queries
1. Order_id <5 and purchaseorder_number <104
2. customer _id =101
3. Employee_id=501 and purchaseorder_number>110
4. customer name starts with ‘a’
b) Create a table ‘fees’ with following fields
1. number
2. Name
3. Date
4. Amount
Queries
1. Sort numbers in Ascending order
2. Find the students who paid between 1/1/2007 to 12/07/2007

13) a) Create a table member with following fields

1. Member _ID 2. Member name 3. Address 4. City
5. State 6. Postal code 7.home phone
8.Work phone 9.Date of Birth 10. Joining Date
Create a form for the given data and enter data into the table form the form
b) Create a form for the given data and enter data into the table from the form . Student
entry form
1. Application number 2. Name
3. Fathers Name 4. Date of birth
5. Gender 6. Class

14) a) Create a report for the given data with primary key as Book ID
Book ID Book Title
Title Types Author ID
Publisher ID Price Total Pages

b) Create a report for the table with the given fields

Salesman No, Salesman Name
Product Name ,No. Of products sold
Price for each quantity,Total amount

Calculate the total using total amount = No of products sold * price for each quantity

15) Create the below Macros

1. Open Form 2. Open Query
3. Maximize 4. Minimize
5. Close 6. Message Box

IV. MS POWER POINT

16) Create a presentation consisting of four slides with the following information
Slide 1. Name of your college in bold letters
Slide 2. Address of your College
Slide 3. List of all available courses
Slide 4. Extra Curricular activities
Apply the transition effects and reharsh the timings 3 seconds for each slide and view in the
slide show.
17) Make a power point presentation on any Current affair (Not less than 8 slides).
 18) Make a Power point presentation to represent your college profile.

19) Create a power point presentation by importing a chart from Microsoft Excels
V. List of C and C++ Programs:-
1. Practice on few Dos commands.
2. Simple programs on data types.
3. Input / Output statements.
4. Various Control statements.
5. Programs on all loops.
6. Programs on break and exit statement.
7. Programs using functions.
8. At least five Programs are using iteration and Recursive Functions using concepts like –factorial,
Fibonacci, sum of n-numbers, displaying array elements using recursive functions, display first
n numbers.
9. Arrays (Matrix operations).
10. Swapping of two numbers using function.
11. Programs on all function categories
12. Programs on sorting the given numbers
13. Programs on inserting and deleting the numbers using arrays
14. Passing arrays to functions.
15. Programs on string handling function (built-in and user defined).

II SEMESTER : COMPUTER SCIENCE-II

(Advanced Programming)
UNIT-I
Pointers –definition, pointer variables, pointer expressions, arithmetic pointers, pointers and
arrays, initializing pointers, pointers and functions and problems with pointers. Structures –
definition, accessing structure members, structure assignments, array of structures, passing
structures to functions, nested structures, structure pointers, uses of structures Unions-
definition, difference between structure and union, type def, Files-introduction to streams and
files, basics of files-file pointer, opening and closing files, writing and reading character, file
functions.

Unit-II
Introduction to OOPs concept-The origin of C++, What is OOPs ,introduction to
classes, features of OOPS concept. Classes and Objects-classes, structures related with
classes and unions related with classes, Inline functions, static data members and
member functions, constructors and types of constructors, destructors. Array of objects,
dynamic memory allocation, Dynamic objects-Introduction, pointers to objects, creating
and deleting dynamic objects, pointers to object members, this operator, friend
functions and lasses.

UNIT-III
Overloading - Creating a Member Operator Function Creating Prefix and Postfix
Forms of the Increment and Decrement Operators ,,Operator Overloading
Restrictions ,Operator Overloading Using a Friend Function, Using a Friend to
Overload ++ or – – Friend Operator Functions , Overloading [] , Overloading ( ),
Overloading –> ,Overloading the Comma Operator. Inheritance-Introduction , base
classes and derived class, types of inheritance, overloading base classless ,virtual base
class members, public, protected and private inheritance, constructors and destructors in
derived classes, virtual base classes, abstract class

UNIT-IV
Polymorphism and Virtual Functions -Virtual Functions ,Calling a Virtual Function Through
a Base Class, Reference ,The Virtual Attribute Is Inherited ,Virtual Functions Are
Hierarchical ,Pure Virtual Functions, Abstract Classes, using Virtual Functions, Early vs. Late
Binding. C++ streams- stream classes, unformatted I/O operations, formatted I/O operations,
manipulators, introduction to templates.

Recommended Text and Reference Books:

1. Let Us C by Yashwanth Kanetkar

2. “Programming in ANSI C “ by E-Balaguruswamy
3. Complete Reference of C++ by Herbert Schilde (Unit-II, III, IV)

II SEMESTER : COMPUTER SCIENCE LAB-II

(Advanced Programming-Lab)
Advanced Programming Lab

1. Programs on Pointers and structures.

2. Program on type def.
3. Handling array elements using pointers.
4. Swapping of two numbers using pointers and a function.
5. Sorting of an array using pointers and functions.
6. Pointer Arithmetic.
7. Sorting and array of structures.
8. Passing of individual elements of a structure to a function
9. Passing an entire structure to function.
10. Structures-Arrays-Pointers
11. Inline Function
12. Function Overloading
13. Programs on Classes
14. Constructors, Destructors
15. Static Members
16. Friend Function, Friend Class
17. Dynamic Memory Allocation using new and delete
18. Pointer to object
19. Overloading unary operator, Overloading binary operators
20. Overloading binary operators using Friend function
21. Single and Multilevel Inheritance, Multiple Inheritance, Hierarchical Inheritance
22. Constructors and Destructors in derived classes
23. Virtual Function
24. Programs on file handling using classes.

III SEMESTER : COMPUTER SCIENCE-III

(Data Structure)
UNIT-I
Introduction to data structures- types of data structures – liner & non linear
structures, examples -Arrays- operations such as insertion, deletion, searching-
traversing - combining arrays – representation of stacks and queues using arrays -
programs.
Stack Applications - Infix, Postfix, Prefix concepts, converting algebraic expressions
from infix to postfix, infix to prefix - string manipulation, recursive functions
implementations.

UNIT-II
Linked Lists- dynamic storage management – types of lists - Single, double and
circular Linked lists - creation of single and double linked list, operations like
insertion, deletion, traversing - representation of stacks and queues using single linked
lists – programs.

UNIT-III
Trees-Terminology –Finding Node-Inserting Node- Binary Trees: Strictly Binary
Tree, complete Binary tree, Almost Complete Binary tree, Binary Search Tree-
Creation , deletion , Insertions, Traversals-Finding Maximum and Minimum Values-
deleting Node –Efficiency of Binary trees-Trees represented as Arrays. Graphs-Types
of graphs-Directed-Non directed-Weighted Graphs Representations: Adjacency
Matrix –Linked Representation - Minimum spanning tree

UNIT-IV
Sorting –Efficiency-linear sort-Bubble sort-Quick Sort-Selection sort-Insertion Sort.
Advanced Sorting: Quick sort.
Searching: Linear Search, Binary Search, Hashing, Binary Search Tree.

Recommended Text and Reference Books:

1. E. Balaguruswamy, Programming with Java, A primer, 3e, TATA McGraw-Hill
Company(2008),(Chapters:1 to 14)
2. Robert Lafore, Data Structures & Algorithms in Java, Second Edition, Pearson
Education(2008)
3. John R. Hubbard, Programming with Java, Second Edition, Schaum’s outline Series,
Tata McGrawhill(2007)
4. Timothy Budd, Understanding Object Oriented Programming with Java, Pearson
Education(2007).
5. Adam Drozdek, Data Structures and Algorithms in Java, Second Edition, Cengage
Learning(2008).
6. John R. Hubbard, Anita Hurry, Data Structures with Java, Pearson Education(2008).
7. Java and Object Oriented Programming Paradigm, PHI (2007).
8. Deitel & Deitel, Java TM: How to Program, 7th Edition, PHI (2008).

III SEMESTER : COMPUTER SCIENCE LAB--III

 (Data Structure-Lab)

List of Experiments:

1. Program to Create , insert and display operations on single linked list

2. Program to Create , insert and display operations on double linked list
3. Program to Create , insert and display operations on circular linked list
4. Program implement the Insertion sort.
5. Program to implement PUSH and POP operations on Stack using arrays method.
6. Program to implement insert and delete operations on queue using array method
7. Program to construct Binary search Tree and implement tree traversing Techniques.
8. Program to selection sort.
9. Program to implement Bubble sort
10. Program to implement Quick Sort.

IV SEMESTER : COMPUTER SCIENCE-IV

 (Database Management System)

UNIT-I
Database Environment – Basic Concepts and definitions, Traditional file processing
systems, Database approach, Range of database applications, Advantages of database
approach, costs and risks of database approach, Components of database environment.

UNIT-II
SQL-History, role, environment, defining databases in SQL, inserting, updating and
deleting data, internal schema, processing single tables, joins, processing multiple
tables, view, definition, transaction integrity.

UNIT-III
Database development process-System Development Life Cycle, Enterprise Modeling,
Conceptual Data Modeling, Logical Database Design, Physical Database Design and
Creation, Database Maintenance, Database Implementation, Alternative IS
Development Approaches, The Role of CASE and a Repository.
UNIT-IV
Database Analysis – E-R Model-Entities, attributes, Relationships, degree and
cardinality. Enhanced E-R Model-Super type, specialization and generalization,
constraints, disjoint ness, subtype discriminator, super type/subtype hierarchies. E-R
object oriented environment, class diagram, relation between classes, E_R modeling of
classes.

Recommended Text and Reference Books:

1. Data base System: Ramez Elmasri and Shamkant B Navathe (Pearson Education
Asia) 2002.
2. Data base System Concepts : Abramham Silbersehatz.Henry F Korth and S Sudarshan
Tata McGraw Hill 2002
3. Modern Data Base Management Jeffrey A Hoffer, Mary B. Prescott and Fred R Mc
Fadden Pearson Education Asia – Sixth Edition.
4. Database Management System: Raghurama Krishna and Johannes Gehrke McGraw
Hill 2002. 5. Database Management System: Gerald V Post Tata McGraw Hill 2002
5. Ivan Baross, SQL/PLSQL The Programming Language Oracle, BPB Publications.

IV SEMESTER : COMPUTER SCIENCE LAB-IV

 (Database Management System-Lab)

List of Experiments:
The Order Tracking Database consists of the following defined six relation schemas.
Employees (Eno, Ename, Zip, Hdate)
Parts (Pno, Pname, Qoh, Price, Level) (Hint:Qoh:Quality On Hand)
Customers (Cno, Cname, Street, Zip, Phone)
Orders(Ono, Cno, Eno, Received Date, Shipped Date)
Odetails (Ono, Pno, Qty)
Zipcodes (Zip, City)
Solve the following queries
1. Get all pairs of customer numbers for customers based on same zip code.
2. Get part numbers for parts that have been ordered by at least two different customers.
3. For each odetail row get ono, pno, pname, qty and price values along with the total
price for the item.(total price=price*qty)
4. Get customer name and employee pairs such that the customer with name has placed an
order through the employee.
5. Get customer names living in FORT or LIBERAL
6. Get cname values of customer whop have ordered a product with pno=10506
7. Get pname values of parts with the lowest prise
8. Get cname value of the customer who have placed at least one order through the
employee with no 1000.
9. Get the cities in which customer and employees are located
10. Get the total sales in dollars on all orders
11. Get the part name values that cost more than the average cost of all parts
12. Get part names of parts ordered by at least two different customer
13. Get for each part get pno, pname and total sales
14. for each part get pno, pname, total sales whose total sales exceeds 1000.
15. Get pno, partname of parts ordered by at least two different customers
16. Get cname values of customers who have ordered parts from any 1 employee based
WITCHITA OR LIBERAL.
SHIPMENT DATABASE.
AN enterprise wishes to maintain the details about his supplier and other corresponding
details for that it uses the following tables.
Table S (SID,SNAME,ADDRESS)
TABLE P(PID,PNAME,COLOR)
TABLE CAT(SID,PID,COST)
REFERENCE KEY: SID REFERENCED S.SID
PID REFERENCE P.PID
Solve the following queries
1. Find the pnames of parts for which there is some supplier
2. Find the snames of suppliers who supply every part.
3. Find the snames of suppliers who supply every red part.
4. Find the pnames of parts supplied by london supplier and by no one else.
5. Find the sids of suppliers who charge more for some part other than the average cost of
that part
6. Using group by with having clause get the part numbers for all the parts supplied by
more than one supplier
7. Get the names of the suppliers, who do not supply part p2.
8. Find the sids of suppliers who supply a red and a green part
9. Find the sids of suppliers who supply a red or a green part.
10. Find the total amount has to pay for that suppliers by part located from london
Employee Database
An enterprise wishes to maintain a database to automate its operations. Enterprise divided
into certain department and each department consists of employees.The following two tables
describes the automation schemas.
DEPT(DEPTNO,DNAME,LOC)
EMP(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO)
1. Create a view, which contain employee names and their manager names working in
sales department.
2. Determine the names of employee, who earn more than their managers.
3. Determine the names of employee, who take highest salary in their departments
4. Determine the employees, who located at the same place.
5. Determine the employees, whose total salary is like the minimum salary of any
department.
6. Update the employee salary by 25%, whose experience is greater than 10 years.
7. Delete the employees, who completed 32 years of service.
8. Determine the minimum salary of an employee of an employee and his details, who join
on the same date.
9. Determine the count of employees, who are taking commission and not taking
commission.
10. Determine the department does not contain any employees.
11. Find out the details of top 5 earner of company.
12. Display those managers name whose salary is more than average salary of his
employees.
13. Display those employees who joined the company before 15th of the month?
14. Display the manager who is having maximum number of employees working under
him?
15. Print a list of employees displaying ‘less salary’ if less than 1500 if exactly 1500 display
as ‘exact salary’ and if greater than 1500 display ‘more salary’?
16. Display those employees whose first 2 characters from hire date – last 2 characters of
salary?
17. Display those employees whose 10% of salary is equal to the year of joining?
18. In which year did most people join the company? Display the year and number of
employees.
19. Display the half of the enames in upper case and remaining lower case.
20. Display ename, dname even if there no employees working in a particular department
(use outer join).
University Database
University wishes to computerize their operations by using the following relations.
Student(snum:Integer,sname:string,major:string, level:string, age:integer)
Class(name:String, Hour:Integer,room:string, fid:integer)
Enrolled(sum:integer,cname:string)
Faculty(fid:Integer,fname:String,deptid:integer)
Depart(deptid:Integer, dname:String, loc:integer)
By using above schema definitions, resolve the following queries.
1. Find the names of all juniors (level=jr) who are enrolled in a class taught by smith.
2. Find the age of the oldest student who is either a history major or is enrolled in the
course of smith.
3. Find the names of all classes that either meet r128 or have five or more students
enrolled.
4. Find the names of all students who are enrolled in two classes that meet at the same
hour.
5. Find the names of faculty members who teach in every room in, which some class is
taught.
6. Find the names of faculty members for whom the combined enrollment of the courses
that they teach is less than five.
7. Print the level and average age of students for that level, for each level.
8. Print the level and average age of the student for that level, for all levels except jr.
9. Find the names of students who are enrolled in the maximum number of classes.
10. Find the names of the students who are not enrolled in any class.
Airline Database
An Airline System would like to keep track their information by using the following
relations.
Flights (flno:integer, from:string, to:string, distance:integer, Price:integer)
Aircraft(aid:integer, aname:string, cruising_range:integer)
Certified(eid:integer, aid:integer)
Employees(eid:integer, ename:string, salary:real)
Note that the employees relation describes pilots and other kinds of employees as well;
every pilot is certified for aircraft and only pilots are certified to fly.
Resolve the following queries:
1. For each pilot who is certified for more than three aircraft, find the eid’s and the
maximum cruising range of the aircraft that he(or she) certified for.
2. Find the names of pilots whose salary is less than the price of the cheapest route from
los angeles to honolulu.
3. Find the name of the pilots certified from some boeing aircraft
4. For all aircraft with cruising range over 1,000 miles, find the name of the aircraft and
the average salary of all pilots certified for this aircraft.
5. Find the aid’s of all aircraft that can be used from los angels to chicago.
6. Print the e names of pilots who can operate planes with cruising range greater than
3,000 miles, but are not certified by boeing aircraft.
7. Find the total amount paid to employees as salaries.
8. Find the eid’s of employees who are certified for exactly three aircrafts.
9. Find the eid’s of employee who make second highest salary.
10. Find the aid’s of all than can be used on non-stop flights from bom to chennai.

V SEMESTER : COMPUTER SCIENCE-V

 (Java Programming)

UNIT-I
Overview - Introduction to Java programming : Features, The Java Virtual Machine,
Language fundamentals, Variables and data types, Conditional and looping
constructs, Arrays.
Object-oriented programming with Java Classes and Objects: Fields and Methods,
Constructors, Overloading methods, Garbage collection, Nested classes

UNIT-II
Inheritance: Overriding methods, Polymorphism, Making methods and classes final,
Abstract classes and methods, Interfaces
Packages, Access protection, importing packages,
Exception handling ----- Exception types, Using try and catch, multiple catch clauses,
Nested try
statements, throw, throws, finally, Java's Built-in-Exceptions, Creating own
exceptions..

UNIT-III
String Handling --- String Constructors, length, Special String operations --- literals,
concatenation, conversion and to String (), Character Extraction, Searching,
modifying, Changing the case of characters, String Buffer and its methods.

UNIT-IV
Java.io package ---- file, The Stream Classes, Byte Streams-IO streams, File IO
Stream, Byte Array IO Stream, Filtered Byte Streams, Buffered Byte Streams,
Sequence I/p
Stream, Print Stream, Random access file.
Character Streams:- Reader, Writer, File Reader ,FileWriter, CharArray Writer,
Buffered Reader, Buffered Writer, Pushback Reader, Print Writer.

Recommended Text and Reference Books:

1. Patric Naughton, Herbert Schildt - The Complete Reference Java 2, 4th edition.

V SEMESTER : COMPUTER SCIENCE

 (Elective-1 / Web Technologies)

UNIT-I HTML
Internet Basics-Communicating on the Internet-Internet Domains-Internet server
identities-Establishing connectivity on the internet –Client IP address-A Brief overview
of TCP/IP and its services-Transmission Control Protocol-(TCP)- Introduction to
HTML- Lists –Types of Lists, Tables, Frames.
UNIT-II DHTML
Introduction to DHTML, Cascading Style Sheets(CSS) – Class - Using <SPAN> Tag –
External Style Sheets(ESS) – Using <DIV> Tag - Layers.
UNIT-III Java Script
Introduction to JavaScript-The JavaScript Document object model-Forms used by a
Website-Cookies
UNIT-IV XML
Document type definition, XML Schemas, Document Object model, Presenting XML,
Using XML Processors: DOM and SAX

Recommended Text and Reference Books:

1. Web Enabled Commercial Application Development using HTML, DHTML,
JavaScript, Perl CGI-IvanBayross-BPB Publications-3rd Edition.

V SEMESTER : COMPUTER SCIENCE

 (Elective-2 / Data Base Design)

UNIT-I HTML
Relational model – Definitions, Integrity Constraints: Domain Constraints, Entity
Integrity, Referential Integrity, Transforming EER diagrams into Relations,
Normalization Basic Normal forms: 1NF, 2NF, 3NF, merging Relations, File
Organizations: sequential, Indexed, Hashed file Organization.

UNIT-II DHTML
Client-Server and middleware: client/server architectures, three-tier architecture, n-tier
architecture, Partitioning an application, Using parallel computer architectures, Using
middleware, Establishing client/server security, client/server issues. Transaction
processing concept, atomicity, consistency, isolation and durability.

UNIT-III JavaScript
Data and Database Administration, Introduction, The changing Roles of Data &
Database administration. database design for web approach, Managing Data Security,
Threats to Data Security, Views, Authorization Rules, User-Defined Procedures,
Encryption, Authentication Schemes, Controlling Concurrent access.

UNIT-IV JSP
Introduction, The general PL/SQL block, the PL/SQL execution environment, PL/SQL.
Oracle transactions, processing PL/SQL Block.
What is a cursor, cursor for loops, parameterized cursors, Error handling in PL/SQL
oracle , named Exception handlers. Triggers

Recommended Text and Reference Books:

1. Modern Data Base Management Jeffrey A Hoffer, Mary B . Prescott and Fred R Mc
Fadden Pearson Education Asia – Sixth Edition.
2. Ivan Baross ,SQL/PLSQL The Programing Language Oracle, BPB Publications
3. Data base System: Ramez Elmasri and Shamkant B Navathe (Pearson Education Asia)
2002.
4. Data base System Concepts : Abramham Silbersehatz.Henry F Korth and S Sudarshan
Tata MCGraw Hill 2002.

COMPUTER SCIENCE LAB-V

(Java Programming Lab)
Java Programming Lab

1. Program to demonstrate types of Constructors.

2. Program to find area of rectangle and volume of cube using method overriding.
3. Program to implement method overloading.
4. Program to perform sorting using arrays.
5. Program to implement inheritance.
6. Program to implement a package.
7. Program to create an Abstract class and its implementation.
8. Program to create an Interface.
9. Program to illustrate try/Catch using multiple catch blocks.
10. Program to illustrate string comparison and concatenation.
11. Program using string Buffer and its methods.
12. Program to illustrate Character Extraction.
13. Program to illustrate Buffered Reader classes.
14. Program to illustrate file class method.
15. Program to display serialization of object.

COMPUTER SCIENCE LAB- VI

(Web Technologies Lab)

Web Technologies Lab

1. Write a program using <font> tag

2. Write a program using <heading> tags and <pre> tag
3. Write a program using <u> <b><i> and teletype text
4. Write a program using <sub> and <sup>
5. Write a program to scroll text using marquee.
6. Write a program to create a table.
7. Write a program to implement a frame.
8. Write a program using hyperlink.
9. Write a program using ordered list, unordered list, definition list.
10. Write a program for creating table headings
11. Write a program to create a cascading style sheet
12. Program with JS operators
13. Program using if statement
14. Program to perform arithmetic operations
15. Program using switch statements
16. Write a program to get current time
17. Write an application to create a form using JS
18. Write a program to create student structure using XML
19. Write a program in XML to implement XML schemas.
20. Write a program in XML to implement DOM.

COMPUTER SCIENCE LAB- VI

 (Database Design Lab)

Database Design Lab

1. Program to add 2 numbers and to find largest of two numbers.

2. Program to find largest of three numbers.
3. Program to find reverse of a given number using for loop.
4. Program to find given number is odd or even.
5. Program to find factorial of a number using while loop
6. Program to calculate area of circle for a value of radius varying from 3 to 7. store the
radius and calculated area in table called "circle".
7. Write a PL/SQL program with exception handler (in case B = 0) which accepts two
numbers A & B, calculates C = A / B and displays the value of C.
8. Program to check number of rows affected by using an implicit cursors
9. Program to update the salary of each employee and to insert into the "emp_raise" table
using explicit cursor.
10. Program implementing named exceptions
11. Program implementing user defined exceptions.
12. Write a trigger which checks the value of SAL before insert or update statement on
EMP table and ensure that SAL below 500 is not inserted.
13. Write a trigger to keep backup of deleted records of EMP table. Assume that the deleted
records of EMP are inserted in EMP_BKUP table.
14. Program to implement a simple procedure.
15. Program to call a stored procedure.

VI SEMESTER : COMPUTER SCIENCE-VII

 (Operating System )

UNIT-I
Introduction:- What is a operating system, simple batch systems, multi-programme
batched systems, time-sharing, personal-computer systems, parallel systems,
Distributed systems, real-time systems, computer-system structures-computer system
operation, I/O structure, storage structure, storage hierarchy, introduction to hardware
protection.

UNIT-II
Operating-system structures - system components, o/s services, system calls.
Process - process concept, Process scheduling, operation on processes. CPU
scheduling - Basic concepts, scheduling criteria, scheduling Algorithms, multiple -
processor scheduling.

UNIT-III
Deadlocks - system model, Deadlock characterization, methods for handling
deadlocks, Deadlock prevention, Deadlock Avoidance, Deadlock detection, Recovery
from deadlock.

UNIT-IV
Memory Management - Logical versus physical address space, swapping, contiguous
allocation, paging, segmentation, segmentation with paging. Virtual memory -
Background, Demand paging, performance of demand paging, page replacement,
page - replacement algorithms, Allocation of frames, thrashing, Demand
segmentation.

Recommended Text and Reference Books:

1. Abraham Silberschatz, Peter Baer Galvin, - OS concepts, Wiley.

VI SEMESTER : COMPUTER SCIENCE-VIII

 (Elective-1 / .Net Technology)

UNIT-I
The .NET Framework - The .NET Programming Framework, VB.NET, c#, and the
.NET Languages, VB.NET versus VBScript and Visual Basic 6, The Common
Language Runtime, The .NET Class Library, ASP.NET, Visual Studio.NET,Learning
the .NET Languages,The .NET Languages,Learning the Language Basics,Basic
Differences Between C# and VB.NET

UNIT-II
DataTypes, Declaring Variables, Scope and Accessibility, Variable operations, Object-
Based Manipulation, Conditional Structures, Loop Structures, Functions and
Subroutines, Types Objects and Namespaces, The Basics About Classes, Value Types
and Reference Types, Advanced Class Programming, Understanding Namespaces and
Assemblies.

UNIT-III
Introduction to Programming and Visual Basic.NET, Input, Variables, Constants, and
Calculations, Making Decisions and Working with Strings, Lists, Loops, Validation,
Sub Procedures and Functions, GUI components, Multiple Forms, Standard Modules,
and Menus, Arrays, Timers, Files, Creating Applications with VisualBasic.NET

UNIT-IV
Developing ASP.NET Applications, Code-Behind, The Global. asax Application
File,ASP.NET Configuration, Web Form Fundamentals, Web Controls, Using Visual
Studio.NET, Validation and Rich Controls-The Calendar Control, Formatting the
Calendar, Restricting Dates, The Ad Rotator, The Advertisement File, The Ad Rotator
Class, Validation Controls, Validation Process, Validation Classes, A Simple Validation
Example, Understanding Regular Expressions .

Recommended Text and Reference Books:

1. Starting Out With VISUAL BASIC .NET Programming by Tony Gaddis, Kip Irvine,
Bruce Denton – dream tech Press publications
2. ASP.NET :The Complete Reference by Matthew MacDonald-TATA McGRAW-
HILL EDITION

VI SEMESTER : COMPUTER SCIENCE-VIII

 (Elective-2 / Advance Java Programming)

UNIT-I
Multithreaded programming: creating threads, run()method, new thread, thread class,
stopping & blocking threads, life cycle of thread- newborn, runnable, running, blocked,
dead, waiting sleeping, suspended, blocked, using thread methods, thread exceptions,
thread priority, synchronization, implementing the Runnable interface
UNIT - II
Applet: what is an applet, applet lifecycle, applet class, applet context class, passing
parameters to applet, use of java .awt graphics class and its various methods in an applet
Graphical user interface(GUI): Layout managers (flow layout, border layout, card
layout grid bag layout, grid layout), AWT controls (labels, buttons, canvases,
checkboxes, check box group, choices, text fields, text areas, lists, scrollbars, panels,
windows, frames, menus, menubars)
UNIT-III
Event Handling: Event delegation model or event class hierarchy, all classes and
interfaces of event delegation model, programs related to event handling covering all
types of events
Java Swing: Working with JFrame, JApplet, Jpanel, JTextfield, JPasswordField,
Jbutton,Jcheckbox, Jradiobutton, Jlist, Jscrollpane, Jcombobox, Jmenu,
Jmenubar,JMenultem, JpopupMenu, JTree, JTable
UNIT-IV
Introduction to JDBC, architecture, types of statements
Introduction to Servlets: Need for Servlets, Introduction to Servlets , The Javax.servlet
Package, Life Cycle of a Servlet, Accessing a Servlet using an HTML page.
Introduction to JSP: Need for JSP, The JSP RequestResponse class.

Recommended Text and Reference Books:

1. Java Complete Reference

2. Subrahmanyam Allamaraju etc., - Professional Java Server Programming — J2EE 1.3
edition, Wrox Press 2001.

COMPUTER SCIENCE LAB -VII

-----------------------------------------------------------------------------------------
Paper Code: OP655(ii) Semester Exam: 35 Marks
Duration: 3 hours
Instruction: 3 h / week Internal Assessment: 15 Marks
-------------------------------------------------------------------------------------------------------

Operating Systems Lab

Unix/Linux

Display Good Morning, Evening, Afternoon and Night based on time

1. Calculate gross salary HRA-10%,DA-90% if BASIC>=1600 and HRA-15%,DA-
95% if BASIC>=10000
2. Display grade obtained by student based on Marks
3. Find factorial of a given number
4. Sum of digits of given number
5. Reverse the given number and print
6. Check whether given number is prime or not
7. copy contents from one file to other file
8. concatenate 2 files into a single file
9. convert file contents from lowercase to uppercase and store it on other file
10. convert file contents to sentence case
11. Program to find the GCD of given 2 numbers.

COMPUTER SCIENCE LAB – VIII

 (Elective-1 /.net Technologies Lab)

-----------------------------------------------------------------------------------------
Paper Code: OP656(ii)E1 Semester Exam: 35 Marks
Duration: 3 hours
Instruction: 3 h / week Internal Assessment: 15 Marks
-------------------------------------------------------------------------------------------------------

. Net Technologies Lab (VB.Net & ASP.Net)

VB.Net

1. Program for wage calculation.

2. Program to display various messages at run time.
3. Program to build the date string application.
4. Program to display simple calculator
5. Program for working with strings.

ASP.Net

6. Program for a simple Hello World. aspx web page.

7. Program for currency Converter.
8. Program to display automatic generation of tables.
9. Program using validation controls simple example.
10. Program for rewriting Global. asax file using code-behind programming.
 COMPUTER SCIENCE-VIII
(Elective-2 / Advanced JAVA Programming Lab)

------------------------------------------------------------------------------------------------------
Paper Code: OP606(ii)E2 Semester Exam: 70 Marks
Duration: 3 hours
Instruction: 3 h / week Internal Assessment: 30 Marks
------------------------------------------------------------------------------------------------------

Advanced JAVA Programming LAB

1. Program to create a thread.
2. Program to create multiple threads.
3. Program to create an Simple Applet
4. Program to create a Frame.
5. Program to illustrate Scrollbar.
6. Program to implement Flow Layout,
7. Program to implement border layout or card layout.
8. Program to illustrate Checkbox
9. Program to create a simple swing application
10. Program to implement JMenu.
11. Program to implement JTree
12. Program to implement JTable
13. Program to create a JDBC application using Prepared Statement
14. Program to create a Simple Servlet application.
15. Program to create an JSP application.

********************