snowybe1le/class-inventory-management-system ? reverse-engineered prompt

Build me a relational database for a school inventory and class management system for Darul Niswah PPWK Demit.

I want it to handle students, class registration and enrollment, class schedules, payment tracking, inventory for materials and equipment, and supplier information. Please design the tables so the relationships make sense, with proper primary keys, foreign keys, not null rules, and a structure that is normalized up to 3NF.

Also include SQL to create the schema, insert some realistic sample data, and a set of useful queries that show things like joins, totals, grouped summaries, and nested queries for common reports. If it fits, make the queries practical for a school admin who wants to see student payments, class lists, and current inventory at a glance.

Use Oracle friendly SQL since this will be used with Oracle APEX, and if you need to check current Oracle syntax or best practices, look them up online.