Medical Database Management System - Project
• Created normalized tables and Entity Relationship diagrams for Admin, Company, Medicine, Employee, Customer, and related entities.
• Implemented data integrity via primary keys, foreign keys, and constraints (CHECK constraints for mobile numbers and passwords).
• Developed PL/SQL triggers for automating discount applications for regular customers (post-insert bill info) and order processing.
• Executed efficient data manipulation operations, ensuring accurate and up-to-date transactional records for suppliers.
