1.Write class declarations and member function definitions for following employee(code, name, designation). Design derived classes as emp_account(account_no, joining_date) from employee and emp_sal(basic_pay, earnings, deduction) from emp_account ,Write a PHP Script to create 5 objects (pass details using parameterized constructor) and Display details of Employees who having Maximum and Minimum Salary.
2.Define an interface which has methods area(), volume(). Define constant PI. Create a class cylinder which implements this interface and calculate area and volume. (Use define())
3. Derive a class square from class Rectangle. Create one more class circle. Create an interface with only one method called area (). Implement this interface in all the classes. Include appropriate data members and constructors in all classes. Write a program to accept details of a square, circle and rectangle and display the area.
4. Create a login form with a username and password. Once the user logs in, the second form should be displayed to accept user details (name, city, phoneno). If the user doesn’t enter information within a specified time limit, expire his session and give a warning otherwise Display Details($_SESSION).
5. Define a class Employee having private members – id, name, department, salary. Define parameterized constructors. Create a subclass called “Manager” with private member bonus. Create 6 objects of the Manager class and display the details of the manager having the maximum total salary (salary + bonus).
6. Write a PHP Script to create a super class Vehicle having members Company and price.Derive 2 different classes LightMotorVehicle (members – mileage) and HeavyMotorVehicle (members – capacity-in-tons). Define 5 Object of each subclass and display details in table format.
7. Create employee table as follows EMP(eno, ename, designation, salary). Write Ajax program to select the employees name and print the selected employee’s details.
8. Write Ajax program to carry out validation for a username entered in textbox. If the textbox is blank, print ‘Enter username’. If the number of characters is less than three, print’ Username is too short’. If value entered is appropriate the print ‘Valid username’.
9. Write an Ajax program to print the content of the myfile.dat. This code asks the user to click a button, fetches data from the server using Ajax techniques and displays that data in the same web page as the button without refreshing the page.
10. Create a form to accept student information (name, class, address). Once the student information is accepted, accept marks in next form (Java, PHP, ST, IT, pract1, and project). Display the mark sheet for the student in the next form containing name, class, marks of the subject, total and percentage(Use $_COOKIE).
11. Write a program to create a shopping mall. User must be allowed to do purchase from three pages. Each page should have a page total. The fourth page should display a bill, which consists of a page total of whatever the purchase has been done and print the total. (Use $_SESSION).
12. Create student table as follows Student(sno, sname, per). Write Ajax program to select the student name and print the selected student’s details.
13. Considerer the following entities and their relationships. Student (Stud_id,name,class) Competition (c_no,c_name,type) Relationship between student and competition is many-many with attribute rank and year. Create a RDB in 3NF for the above and solve the following. Using above database write a script in PHP to accept a competition name from user and display information of student who has secured 1st rank in that competition.
14. Write Ajax program to print Movie details by selecting an Actor’s name. Create table MOVIE and ACTOR as follows with 1 : M cardinality MOVIE (mno, mname, release_yr) and ACTOR(ano, aname).
15. Write Ajax program to fetch suggestions when is user is typing in a textbox. (eg like Google suggestions. Hint create array of suggestions and matching string will be displayed).
16. Write Ajax program to get book details from XML file when user select a book name. Create XML file for storing details of book(title, author, year, price).
17. Write a PHP program to accept username and password from the user. Validate it against the login table in the database. If there is a mismatch between username and password, then, display the error message as ―invalid user name and password; else display the message as ―Login successful‖ on the browser.
18. Write a PHP program to implement Create, Read, Update and Display operations on Employee table with attributes(empno, empname, date_of_join, address, salary). (Use Radio Buttons).
19. Consider the following relational database: Project (P_Group_No, Project_Title) Student (Seat no, Name, Class, P_Group_No) Write a PHP script to accept project title and display list of students those who are working in a particular project.
20. Consider the following entities and their relationships Emp (emp_no,emp_name,address,phone,salary) Dept (dept_no,dept_name,location) Emp-Dept are related with one-many relationship. Create a RDB in 3NF for the above and solve following. Using above database write a PHP script which will a) Insert employee records in table . b) Print a salary statement in the format given below, for a given department. (Accept department name from the user).
21. Consider the following entities and their relationships Doctor (doc_no, doc_name, address, city, area) Hospital (hosp_no, hosp_name, hosp_city) Doctor and Hospital are related with many-many relationship Create a RDB in 3 NF for the above and solve following Using above database, write a PHP script which accepts hospital name and print information about doctors visiting / working in that hospital in tabular format.
22. Consider the following entities and their relationships Movie (movie_no, movie_name, release_year) Actor (actor_no, name) Relationship between movie and actor is many – many with attribute rate in Rs. Create a RDB in 3 NF for the above and solve following Using above database, write PHP scripts for the following: (Hint: Create HTML form having two radio buttons) a) Accept actor name and display the names of the movies in which he has acted. b) Insert new movie informationl
23. Consider the following entities and their relationships BillMaster(billno, custname, billdate ) BillDetails(itemname, qty, rate, discount) BillMaster and BillDetails are related with one-to-many relationship. Create a RDB in 3 NF for the above and solve following Write PHP script to print the bill in following format Accept the Bill number from user.
24. Create an application that reads “Book.xml” file into simple XML object. Display attributes and elements(Hint: use simple_xml_load_file() function)
25. Create a XML file which gives details of books available in “ABC Bookstore” from following categories. 1) Technical 2) Cooking 3) Yoga and elements in each category are in the following format
26.Write a script to solve following questions (Use “Book.xml” file) a) Create a DOM Document object and load this XML file. b) Get the output of this Document to the browser c) Save this [. XML] document in another format i.e. in [.doc] d) Write a XML program to print the names of the books available in “Book.xml” file.
27. Write a script to create “cricket.xml” file with multiple elements as shown below:
28. Write a PHP script to accept an .XML file which should comprise the following:
29. Write a PHP script using AJAX concept, to check user name and password are valid or Invalid (use database to store user name and password).
30. Write a script to create “cricket.xml” file with multiple elements as given below
Plzz give solutions of ty bca awt slips
ReplyDeletesir plz give me advnace java and advnace web tecnnlogies particla slip soltuion
ReplyDeletePlease can we download these solutions
ReplyDeletePlease Send me TYBCA Advance_Java And Advance_WT solved Slips
ReplyDeletemayurkotkar05@gmail.com