WELCOME!

Services

WELCOME
welcome to my website by KARTHICKRAJA.thank u for visiting...வருகைக்கு நன்றி.|Krtamilanz இந்த BLOG யை நான் 2013 நவம்பர் 5 ல் துவங்கிய நோக்கமே நான் படித்த ,கேட்ட ,தெரிந்த விஷ​யங்கள் நீங்களும் அறியவேண்டும் என்ற நல்லெண்ண நோக்கமே தவிர வேறதும்மில்லை.இதில் வரும் சில பதிவுகள் இணையதளத்தில் இருந்தும், சில பதிவுகள் கேட்டவை ,படித்தவை , சில நானே தொகுத்தவை.௭ன்றும் அன்புடன் உங்கள் கார்த்திக்ராஜா...

Bookmark This Site



Latest News Study According to your Internal Marks, Pass Semester Exam!!

Important Services
Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Ad

info Links

entireweb

Friday, 21 November 2014

Diplomo computer Lab syllabus for .NET Practical

.Net Laboratory

sub Code: 25257
LAB EXERCISES
PART – A VB.NET PROGRAMMING
  1. Accept a character from console and check the case of the character.
  2. Write a program to accept any character from keyboard and display whether it is vowel or not.
  3. Write a VB.Net program to accept a string and convert the case of the characters.
  4. Develop a menu based VB.Net application to implement a text editor with cut, copy, paste, save and close operations.
  5. Write a program to implement a calculator with memory and recall operations.
  6. Develop a form in VB.NET to pick a date from Calendar control and display the day, month, year details in separate text boxes.
  7. Develop a VB.Net application to perform timer based quiz of 10 questions.
  8. Develop a VB.Net application using the File and Directory controls to implement a common dialog box.
  9. Develop a database application to store the details of students using ADO.NET
  10. Develop a database application using ADO.NET to insert, modify, update and delete operations.
  11. Develop a VB.Net application using Datagrid to display records.
  12. Develop a VB.Net application using Datagrid to add, edit and modify records.
PART – B ASP.NET and XML PROGRAMMING
  1. Create a simple ASP.NET page to Output Text with a form, two HTML text boxes, an HTML button, and an HTML <span> element. Create an event procedure for the button.
  2. Create a web application in ASP.NET using three different controls to the ASP.NET page for reserving rooms in hotel. The three controls are a button control, a label control, and a drop-down list control.
  3. Create a application for Accessing a SQL Database by Using ADO.NET by connecting to the SQL Server database and call a stored procedure. You then display the data in a Repeater control.
  4. Develop a web application to read the details of the selected country stored in XML database and display back to the user usingWeb controls
  5. Develop a web application to read an XML document containing subject, mark scored, year of passing into a DataSet

Diplomo computer Lab syllabus for RDBMS Practical

RDBMS Laboratory

"L" Scheme - Sub Code: 25256
LAB EXERCISES
PART - A
1 Create a table “Customer” with the following fields: Id, Company name, Last name, First name, Address, City, State, Pin code and Perform the following operations
  • Find the customer who does not have last name.
  • Change the pin code of any customer
  • Insert new record into the table
  • Update the field’s First name and Last name into Name.
2. Implement the following Transaction Control Statements a. Commit b. Rollback c. Save point
3. Create a table client master with the following fields client_no, name, address 1, address2, city, state, pincode, remarks, bal due with suitable data types. Create another table supplier table from client
master. Select all the fields and rename client no with supplier no and name with supplier name.
  • Insert data into client master.
  • Insert data into suppliermaster from client master.
  • Delete the selected row in the client master.
4. Create a table to show the salary details of the employees and perform the following operations
  • Create an updatable view to modify and display the details of the employees for the above table.
  • Grant select and update privileges on above table to other users.
  • Grant all the privileges to some other users.
  • Revoke all the above granted permissions.
5. Create two tables “Item details” with the fields of Item id,, Order Id, Part Id, Quantity, Total and Create a another table “Order Details: with the fields of Order id, Customer id, Order Date and
Perform the following operations
  • Create the view that calculates the total for all the items in each order
  • Create view to join order and corresponding line item information from the above two tables.
6. Create a table student with their elective paper as one field.
  • Create another table staff with the subject names they have handled and number of times handled.
  • Construct a English sentence to display the rows in the staff table.
  • Use sub-queries to display the information about student's name and staff names where both have same subject names.
  • Display the subject name, staff names where same subject is handled by more than one staff.
  • Display the student, subject name where the subject is not at all handled any staff in the staff table.
7. Create two tables ”Department” and “Staff Details”. Apply a Master Transaction relationship between them.
8. Create a table sales_order with s_order_no and product_no as primary key. Set other fields to store client number, delivery address, delivery date, order status.
  • Add a new column for storing salesman number using ALTER command.
  • Set the s_order_no as foreign key as column constraint
  • Set the s_order_no as foreign key as table constraint
  • Enforce the integrity rules using CHECK.
PART - B
  1. Create a table 'master_book' to contain the information of magazine code, magazine name, publisher, Weekly/biweekly/monthly, price. Write PL/SQL block to perform insert, update, delete operations on the above table.
  2. Create a table to store the salary details of the employees in a company. Declare the cursor id to contain employee number, employee name and net salary. Use cursor to update the employee
  3. Create a table to store the salary details of the employees in a company. Declare the cursor to contain Employee number, Employee name and Net salary. Use cursor to update update the employee salaries.
  4. Write a PL/SQL trigger to update the records while deleting the one record in another table.
  5. Create a table to contain phone number, user name, address of the phone user. Write a function to search for a address using phone number.
  6. Create a table 'stock' to contains the itemcode, itemname, current stock, date of last purchase. Write a stored procedure to seek for an item using itemcode and delete it, if the date of last purchase is before one year from the current date. If not, update the current stock.
  7. Write a PL/SQL block to handle built-in exception like No_DATA_FOUND and TOO_MANY_ROWS.
  8. Write a PL/SQL block to create and handle any two user defined exception.
PART – C - MINI PROJECT
Maximum 4 Students in a batch
Using any front end tool develop an application involving minimum 2 – 4 tables. Include the coding and output screens in the lab record.

 

"K" Scheme - LAB Manual

Sub Code: 15055
Lab exercise:
  1. Execute and test all the SQL Editor commands.
  2. Work with the following conditions: Column formatting, alias and Column ordering.
  3. Use indexing on a table –simple and compound indexes.
  4. Work with the different categories of functions such as Math, Date, Aggregate and Conversion functions.
  5. a) Create a table to show the salary details of the employees.
    b) Grant select and update privileges on above table to other users.
    c) Grant all the privileges to some other users.
    d) Revoke all the above granted permissions.
  6. a) Create a table student_master with the following field’s name, Regno, dept and year with suitable data types. Use Select command to do the following.
    b) Select the student's name column
    c) Display the unique rows
    d) Sort the table in alphabetical order
    c) Display the rows of the table in the sales order date wise,
    e) Select all the students of a particular department.
  7. a) Create a table sales_order with s_order_no and product_no as primary key. Set other fields to store client number, delivery address, delivery date, order status.
    b) Add a new column for storing salesman number using ALTER command.
    c) Set the s_order_no as foreign key as column constraint
    d) Set the s_order_no as foreign key as table constraint
  8. Develop a Visual Basic Application with suitable Labels & TextBoxes for the columns of a Table . Add Command Buttons to perform the following: Display Records, Previous, Next, First and Last. Use the ODBC driver to connect the Application with the oracle
  9. Develop a Visual Basic Form with suitable Labels & TextBoxes for the columns of a Table . Add Command Buttons to perform the following: Insert record, Delete record, Update record, Locate Record
  10. a) Create a table student with their elective paper as one field.
    b) create another table staff with the subject names they have handled and number of times handled.
    c) Construct a English sentence to display the rows in the staff table.
    d) Use sub-queries to display the information about student's name and staff names where both have same subject names.
    e) Display the subject name, staff names where same subject is handled by more than one staff.
    f) Display the student, subject name where the subject is not at all handled any staff in the staff table.
  11. a) Create a sales_order table and client_master table with suitable fields.
    b) Find the total number of quantity ordered for a particular product.
    c) Display the rows of the table in the sales order date wise,
    d) Join the two tables and display the product number, product name, where the order_no in the sales_order table and order_no in client_master are equal.
    e) Join the sales_order table to itself and display the order number, client number and salesman number where client has been serviced by more than one salesman.
  12. a) Create table sales_order_details with the s_order_no as primary key and with the profit_percent, sell_price, supplier_name
    b) Select each row and compute sell_price*.50 and sell_price *1.50 for each row selected.
    d) Select product_no, profit_percent, sell_price where profit_per is not between 10 and 20 both inclusive.
    e) Select product_no, description. profit_percent, sell_price where profit_percent is not between 20 and 30.
    f) Select the supplier_name and product_no where suppliemame has 'r' or 'h' as second character.
  13. a) Create a table client_master with the following fields client_no, name, address 1 , address2,city, state, pincode, remarks, bal_due with suitable data types. Create another table supplier_table from client_master. Select all the fields andrename client_no with supplier_no and name with supplier_name.
    b) Insert data into client_master.
    c) Insert data into supplier_master from client_master.
    d) Delete the selected row in the client_master.
  14. Write a PL/SQL code to display the employee details for an employee.
  15. Write a PL/SQL code to calculate EB bill for the given units using if statement.
  16.  Write a PL/SQL block to handle built-in exception like No_DATA_FOUND,TOO_MANY_ROWS.
  17. Write a PL/SQL block to create and handle user defined exception.
  18. Write a PL/SQL block to use procedure and function and get the result.
  19. Write a PL/SQL trigger to update the records while deleting the one record in another table.
  20. Create a table to store the salary details of the employees in a company. Declare the cursor id to contain employee ber, employee name and net salary. Use cursor to num update the employee salaries.
HARDWARE REQUIRED
  1. A Server with Oracle 8i or higher (Oracle 10g is preferred)
  2. 36 computers networked and configured with TCP/IP.
SOFTWARE REQUIRED
  1. SQL *PLUS
  2. Microsoft Visual Basic 6.0

Diplomo computer Lab syllabus for Web Programming Practical

Web Programming Practical

"L" Scheme - Sub Code: 15255

PART – A
  1. Design a HTML page describing your profile in one paragraph. Design in such a way that it has a heading, a horizontal rule, three links and your photo. Also, write three HTML documents for the links.Include facilities for forward, backward and HOME.
  2. Design a HTML page about computer languages. List the language. Each Language’s name is a link. Prepare separate HTML documents for each language and call them in the appropriate link.
  3. Design a single page website for your polytechnic containing a description of the courses offered. It should also contain some general information about the college such as its history, the campus, its unique features and so on. The site should be colored and each section should have a different color.
  4. Make out a brief bio-data of yours and code it as an HTML page. You can consider using tables to show your academic history.
  5. Write a program using CSS to create a time table for the class.
  6. Write a program using CSS to set the background colors, fonts and paragraphs
  7. a)Write a Java script code that converts the entered text to uppercase b)Write a Javascript code to validate the username and password. The username and password are stored in variables.
  8. Write a Java Script code using frames and Events ( When a cursor moves over an object it should display the specification of the object in another frame )
  9. Create a site containing banner advertisement at the top of the page. The ads are changed every 10 or 15 seconds.
PART - B
  1. Collect the definitions of 5 items in Open Source. These definitions are stored in two string arrays name[] and defn[]. Write a JSP which has these two arrays and supplies the definition on request.
  2. Write a HTML document which gets the user input of the name of the item and sends the request to the JSP.
  3. Write a JSP code to manipulate cookies.
  4. Write a JSP code to upload data from client side.
  5. Create a JSP application using image map to give information about the institution
  6. Write a program to check how many users have visited a website. Use Application object.
  7. Write a Code in Java Script to count number of times you move over a link or record.
  8. Write a program to check whether a person will be permitted to open a particular page or not. Use permission checker component.
  9. Develop a simple Hello World application using AJAX Develop an AJAX application to get the server date time from a JSP page using AJAX.
  10. Develop a html search page using Ajax functionality and a server side script that returns results based on search criteria. Develop a html search page containing a textbox for taking search string as input from the user and get the results from the server using Ajax functionality, and display them on the page.
PART – C - MINI PROJECT
Maximum 2 Students in a batch
Design a static web site having a minimum of 6 web pages using all the html features studied. Include the coding and output of the above mini project in the lab record.

 

"K" Scheme - Lab Manual

Sub Code: 15045
Lab Exercise:
  1. Design a HTML page describing your profile in one paragraph. Design in such a way that it has a heading, a horizontal rule, three links and your photo. Also, write three HTML documents for the links. Include facilities for forward, backward and HOME.
  2. Design a HTML page about your friends. List your friends. Each friend’s name is a link. Prepare separate HTML documents for each friend and call them in the appropriate link.
  3. Design a single page website for your polytechnic containing a description of the courses offered. It should also contain some general information about the university such as its history, the campus, its unique features and so on. The site should be colored and each section should have a different color.
  4. a.) Create a web page that provides links to five different websites.
    b.) Design a web page that has 5 equal columns. The table should look the same in all screen resolutions.
  5. Make out a brief bio-data of yours and code it as an HTML page. You can consider using tables to show your academic history.
  6. a.) Write a Java script code that converts the entered text to uppercase
    b.) Write a Javascript code to validate the username and password. The username and password are stored in variables.
  7. Write a Java Script code using frames and Events ( When a cursor moves over an object it should display the specification of the object in another frame
  8. a.) Write Javascript function that finds the maximum of three given numbers.
    b.) Write HTML document with Javascript to count the number of vowels in a text typed in a TextArea..
  9. Create a site containing banner ads at the top of the page. The ads are changed every 10 or 15 seconds.
  10. Collect the definitions of 10 items in chemistry. These definitions are stored in two string arrays name[] and defn[]. Write a JSP which has these two arrays and supplies the definition on request. Write a HTML document which gets the user input of the name of the item and sends the request to the JSP.
  11. Write a JSP code to manipulate cookies.
  12. Write a JSP code to upload data from client side.
  13. Create a JSP application using image map to give information about the institution.
  14. Write a program to create the chatting application using Application and Session object.
  15. Write a program to check how many users have visited a website. Use Application object.
  16. Write a Code in Java Script to count number of times you move over a link
  17. Write a program to check whether a person will be permitted to open a particular page or not. Use permission checker component.
  18. Write a program for incorporating entities in to XML document using internal DTD.
  19. Write a program using CSS to create a time table for the class.
  20. Write a program using CSS to set the background colors, fonts and paragraphs.
REQUIREMENTS:Software: (i) Notepad or any one Editor (ii) Web Browser (Internet Explorer or any one web browser) (iii) Apache Tomcat 4.0.x or JRun 3.x
Hardware:
• Computer with Pentium IV / Dual core Processors – 36 Nos
• Printers - 6 Nos

Diplomo computer Lab syllabus for Communication Lab Practical

Communication and Life Skills Practical

Sub Code: 20002
PART A: MONODIC COMMUNICATION
  1. Vocabulary enrichment: recording important words and terminology alphabetically connected to the concerned department – playing antakshari.
  2. Introducing oneself: using greeting phrases – opening and closing with courteous notes – supplying personal information.
  3. Introducing others: using greeting phrases – opening and closing with courteous notes – with information.
  4. Welcome address, vote of thanks and compering a program: keeping notes – and personal information of the dignitaries – concerned.
  5. Making an Oral Presentation: Preparing the presentation - Talking about people, animals and places – Keywords technique and the rehearsal – Presentation outline – Performing the presentation – answering the questions.
  6. Oral description: a picture from an English magazine – a visual ad – a natural scene.
  7. Auditory/Oral comprehension – small passage – small dialogue -very short story – note - taking skill.
  8. News Caption: giving caption for a news item from an English daily.
PART B: DYADIC COMMUNICATION: COMMUNICATIVE FUNCTIONS
  1. Dialogue: preparing and performing - Meeting people, exchanging greetings and taking leave – Giving instructions and seeking clarifications – Thanking someone and responding to thanks - minimum seven exchanges including the courteous openings and closings – ten common contexts.
  2. Telephonic dialogue: telephonic etiquette - Answering the telephone and asking for someone – Dealing with a wrong number – Taking and leaving messages – Making enquiries on the phoneordering for supply-bookings and arrangements-handling the complaints – calling for appointment.
PART C: PROFESSIONAL COMMUNICATION
  1. Group Discussion - Taking part in a Group Discussion – focus on team spirit.
  2. Interview - Frequently asked questions in an interview – Mock interview - Body language.
  3. Resume Writing – components.
PART D: LIFE SKILLS
  1. Preparing for and dealing with change.
  2. Motivation, goal-setting and self-esteem.
  3. Teamwork skills.
  4. Emotional intelligence skills
  5. Career planning.
  6. Assertive Skills.
  7. Interview skills.
References :-
  1. Malcolm Goodale, Professional Presentations with VCD, Cambridge University Press
  2. B.Jean Naterop and Rod Revell, Telephoning in English with 2 Audio CDs Cambridge University Press
  3. Priyadarshi Patnaik, Group Discussion and Interview Skills with VCD, Cambridge University Press
  4. Kamalesh Sadanand and Susheela Punitha, Spoken English: A Foundation Course for Speakers of Tamil, Orient BlackSwan.
  5. S. P. Dhanavel, English and Soft Skills, Orient BlackSwan
  6. Robert Sherfield and et al, Developing Soft Skills, Pearson Education.
  7. Poly Skills: A course in communication skills and Life skills, Cambridge University Press.
  8. English and Communication Skills for Students of science and Engineering by S.P.Dhanavel , Orient BlackSwan.
  9. Speak Well, edited by Kandula Nirupa Rani, Jayashree and Indira,OrientBlackSwan.
  10. Fifty ways to improve your telephoning and teleconferencing Skills by Ken Taylor Time management

Diplomo computer Lab syllabus for Data structures usinng C Practical

Data Structures Using C Practical


"L" Scheme - Subject Code : 25245

Lab Exercise:
  1. Write a program in ‘C’ to insert, delete an element from an array of elements. Also print the position of a particular element
  2. Write a program in ‘C’ to merge two sorted array elements into a single array
  3. Write a program in ‘C’ to create a two dimensional array with at least ten elements. Search for a particular element and print its position and address of the element.
  4. Write a program in ‘C’ to perform operations in stack by using array.
  5. Write a program in ‘C’ to convert an infix expression into postfix expression.
  6. Write a program in ‘C’ to evaluate a postfix expression.
  7. Write a program in ‘C’ to create a queue containing ten elements and perform delete and insert operations using array.
  8. Write a program in ‘C’ to create a singly linked list containing at least five elements. Make necessary assumptions.
  9. Write a program in ‘C’ to delete the first node that contains an integer data item of a single linked list.
  10. Write a program in ‘C’ to create and display the contents of a doubly linked list.
  11. Write a program in ‘C’ to create a binary tree.
  12. Write a program in ‘C’ for pre-order traversal of a binary tree.
  13. Write a program in ‘C’ for binary searching
  14. Write a program in ‘C’ to sort ‘N’ Numbers using Insertion sort.
  15. Write a program in ‘C’ to sort ‘N’ Numbers using bubble sort.
Related Posts Plugin for WordPress, Blogger...