lab manual of software practices

PRACTICALS
1.(Using if….end if)
Create a table stud_muster (st_id, st_name, report_date,contact,sem,status) and write a PL/SQL
block to update the status of stud_muster by checking the difference of current date and
report_date,if it happens to be greater than 5 yrs set the status to “disqualified” else “pursuing”
using conditional operator if…end if.


 2.(Using Loop)
Write a PL/SQL code block to print the records of the students whose id ranges from 015 to
025 using for, while, simple loop. (Use stud_muster table as mentioned above).




3.(Using Implicit Cursor)
The bank manager of a branch say “ABC” has decided to activate all those accounts which
were previously marked inactivate for not performing transactions in last 365 days. Write a Pl/
SQL block to update the status of accounts. Display an appropriate message for the rows
affected.




4.( Using Explicit Cursor)
Write a PL/SQL block that will display the customer name, the fixed deposit number and the
fixed deposit amount of the first 10 customers holding highest amount in fixed deposits.
(Hint: Declare explicit cursor in the query).




5.(Using Procedure)
Write a procedure to check the status of various orders taken by an enterprise XYZ and display
the appropriate message using IN parameter.
Using OUT parameter –write a procedure to check the quantities ordered for various orders




6.(Using Functions)
Write a function and block code to execute to know the quantity on hand and reorder level
.Before ordering of new goods it is needed to check if they exceeded the maximum limit of
particular item.
If yes then they should be stored in some other function if no then they should be placed in
orders.




7. Design a form which insert & Delete a record of Student Details in Data Grid.




8. Develop a small Database entry form using ADO(Bounded) for Student Profile.
and Perform the Following operation.
• Insert a Record
• Delete a Record
• Update a Record
• Search a Record




9. Develop a small Database entry form using ADO(Unbounded) for employee profile
and Perform the Following operation.
• Insert a Record
• Delete a Record
• Update a Record
• Search a Record




10. Develop a small Database Management System for Student profile using following
Data Awareness Control with ADO.
• Data Grid
• Data Combo
• Data List




11. Develop a small Database entry form using ADO(Unbounded) for employee Profile. Fetch
the Record through Function or Store Procedure. Perform the Following operation.
• Insert a Record
• Delete a Record
• Update a Record
• Search a Record




12. Design a different Data Report for Employee/Student Profile.
(Fetch the Record from Database through Stored Procedure or Function)
• Singular Report
• All Employee/Student Report
• Joining Date Wise Report
• Age Wise Report
• Designation/Semester Wise Report

lab manual of software engineering

LABORATORY EXPERIENCES
1. To sturdy software characteristics.
2. To study different types of software applications.
3. To understand and development various process models.
4. To study Logical Data Flow Diagrams.
5. To study Logical Data Flow Diagrams.
6. To study & Explain software measurement metrics
7. To study Project Estimation.
8. To study software risks.
9. To Study Software Quality Assurance (S.Q.A.) concept.
10. To study different software testing methods
11. Overview of CASE Tool.