IT Skill Training & Jobs @ Faith Infotech Academy, Technopark, Thiruvananthapuram

B uild a   real-time inventory system example   using: Inventory and transaction tables Data records A  cursor  for low-stock alerts A  trigger  for auditing sales ✅ Inventory System  Tables: tblProducts : holds product details and stock tblSales : tracks product sales tblSales_Audit : logs all sales automatically via trigger ✅ Step 1: Create Tables -- Product master table CREATE TABLE tblProducts (     product_id    NUMBER PRIMARY KEY,     product_name  VARCHAR2(100) NOT NULL,     quantity      NUMBER(10) NOT NULL,     price         NUMBER(10,2) NOT NULL ); -- Sales table CREATE TABLE tblSales (     sale_id      NUMBER PRIMARY KEY,     product_id   NUMBER NOT NULL,     quantity_sold NUMBER NOT NULL,     sale_date    DATE DEFAULT SYSDATE,     FOREIGN KEY (product_id) REFERENC...

Oracle 11g PL/SQL: User Authentication System with Stored Procedure and SQL*Plus Integration Creating the tblUsers and tblRoles tables with sequences and 6 records, creating a stored procedure sp_UserNameAndPassword that returns user details as an OUT parameter (using a record type), and modifying the login.sql script to accept username and password, call the procedure, and display the results in SQL*Plus.  The solution will include "what," "why," "how" explanations, comments, and adhere to coding standards with exception handling. Step-by-Step Solution 1. Create Tables and Insert Records Create the tables with sequences for primary keys and insert 6 records. -- Create tblRoles table with sequence for RoleId CREATE TABLE tblRoles ( RoleId NUMBER ( 10 ) PRIMARY KEY , roleName VARCHAR2 ( 50 ) NOT NULL ) ; CREATE SEQUENCE role_seq START WITH 1 INCREMENT BY 1 ; -- Insert 4 roles INSERT INTO tblRoles ( RoleId , roleName ) VAL...