A centralized database management system designed to digitize and streamline art gallery operations — managing artworks, exhibitions, sales, and customer relationships through a robust SQL-based backend.
Traditional art galleries are limited by physical space and geographic reach. This system solves that by providing an online platform where artists can showcase their work globally and customers can browse and purchase artwork from anywhere in the world.
- Eliminated manual inventory tracking through centralized database management
- Enabled online exhibitions removing geographic limitations for artists
- Automated sales and order management reducing human errors
- Built role-based access control for Admins, Artists and Customers
- Database: Oracle SQL / PL-SQL
- Concepts Used: Entity Relationship Modeling, Normalization, Stored Procedures, User Access Control, Transaction Management
- Designed complex ER diagrams with 10+ entities
- Implemented strict business rules and constraints
- Built user role management — Admin, Artist, Customer
- Secure transaction handling with non-cancellable order logic
- Multi-user access control using GRANT permissions
- Artwork inventory management across multiple categories
- Online exhibition scheduling and management
- Customer order processing and shipment tracking
- Artist registration and portfolio management
- Role based access — different permissions per user type
Developed as part of DMDD coursework at Northeastern University, Boston.
- Run
USERGRANT.sqlas Admin to create users and grant access - Login with credentials created in step 1
- Run
PROJECT3.sqlto create and populate the database