An Oracle SQL-based DBMS for managing healthcare data across patients, doctors, prescriptions, pharmacies, and pharmaceutical companies. Includes schema design, constraints, triggers, and PL/SQL ...

Name, DateofIssue, NameofBook, Status) 2. Fine(Roll_no,Date,Amt) Accept roll_no & name of book from user. Check the number of days (from date of issue), if days are between 15 to 30 then fine amount ...