/Nursery-DBMS

Nursery Management System developed using SQL and PL/SQL

Primary LanguagePLSQLMIT LicenseMIT

Nursery-DBMS

Objectives

  • Implementing a system that helps to manage a nursery database.
  • Using SQL commands to execute different queries.
  • Using nested query, join commands.
  • Using procedures, functions, triggers.
  • Using PL/SQL efficiently.

Description

My project is based on a database management system.
I am using Oracle Database 10g XE which is one of the easiest to store our information.
The project Nursery Database Management system contains the information of Customers, Plants, payment, order info including plant quantity.

It consists of the following schema:

Schema

  • Cust_order(order_no, amount, order_date)
  • Customer_info(customer_id, fname, lname, address,email, password, phone, order_no)
  • Payment(payment_id, customer_id, order_no, payment_date, amount)
  • Plant(plant_id, plant_name, quantity,price)
  • order_details(plant_id, quantity, order_no)

Schema Diagram

Schema

License

MIT License © Nursery-DBMS