Type of event: Guest Lecture

Title of the event:Normalization, PL/SQL-Procedures & Triggers in DBMS

Resource Person: Dr. E Padmalatha, Associate Professor, Dept of CSE, CBIT Hyderabad

Description: The guest lecture was very informative and insightful. The resource person discussed the importance of normalization in organizing data efficiently in a database to minimize redundancy and improve data integrity. They explained the different normal forms and how they help in structuring databases effectively.In terms of PL/SQL, the lecture highlighted how it extends SQL by adding procedural capabilities, allowing for the creation of stored procedures, functions, and triggers within Oracle databases. The resource person demonstrated the use of PL/SQL blocks for writing procedural code to perform tasks like control structures, loops, and exception handling. The resource person showcased how procedures can be stored in the database and called by applications to execute specific tasks. Lastly, the discussion on triggers focused on their significance in automatically executing actions in response to specific events in the database, such as INSERT, UPDATE, or DELETE operations.
Overall, the guest lecture provided a comprehensive overview of normalization, PL/SQL, procedures, and triggers in DBMS, offering valuable insights into these fundamental concepts of database management.

Organized by: Information Technology

Date: 16th July 2024

No. of participants attended : 148