CSE-216 Project — Online Art Marketplace

A full-stack web application built as part of the CSE-216 (Database Systems) course at BUET. The project is an online art marketplace where users can browse artworks, follow artists, manage a cart, and place orders.

What it does

• Browse and discover artworks listed by artists across 30+ categories (paintings, digital art, photography, sculpture, etc.)
• View artist profiles with portfolios and contact details
• Follow artists to keep track of their work
• Add artworks to a cart and place orders
• Rate artworks (average rating stored per artwork)
• Payment support for bKash, Rocket, Nagad, and cash on delivery

Tech stack

• Frontend — React (my-react-app/)
• Backend — Node.js (Backend/)
• Database — Oracle Database 19c (schema in MYPROJECT.sql)

Database schema

The Oracle schema covers the following tables:

Table	Description
USERS	Registered buyers
ARTISTS	Artists with portfolio and contact info
ARTWORK	Artworks with price, medium, category, and average rating
CATEGORIES	30 artwork categories
CARTITEMS	Shopping cart entries per user
ORDERS	Order records with date and payment method
ORDERITEMS	Individual items per order with quantity and price
FOLLOWS	User–Artist follow relationships
REVIEWS	User ratings and reviews on artworks

Setup

Database

Import the schema and seed data into Oracle Database 19c:

-- Run in SQL*Plus or SQL Developer connected to your Oracle instance
@MYPROJECT.sql

Refer to University Schema Install.pdf for the full setup guide.

Backend

cd Backend
npm install
node index.js

Frontend

cd my-react-app
npm install
npm start

Open http://localhost:3000.

Project structure

CSE-216-Project/
├── Backend/              # Node.js REST API
├── my-react-app/         # React frontend
├── MYPROJECT.sql         # Oracle schema + seed data (1953 lines)
└── University Schema Install.pdf