DEDUCATION DATABASE

About The Project

dEducation is an ed-tech platform where tutors,students and coaching centers get connected to each other. Students can find their desired tutors and join coaching centers. On the other hand, tutors can get tuitions and create their own coaching centers.

ERD

Languages, Tools and Frameworks:

• Oracle 19C
• Navicat Premium

Getting Started

Follow the step by step installation procedure to install and run this on your machine

Prerequisites

Make sure you have oracle installed in your device.

Oracle: Install Oracle from here and register for an account of your own

Setting up the database

1. Go to sql plus

2. Enter credentials

   username: sys as sysdba
   password: password

3. Create a new user c##deducation

create user c##deducation identified by password;
grant dba to c##deducation;

5. Head over to your favourite database GUI and connect deducation with that.

6. Import data from sql file depending upon the GUI.

7. List of sql files:

- tables/CREATE_ALL_TABLES.sql
- types/CREATE_TYPES.sql
- triggers/CREATE_TRIGGERS.sql
- functions/CREATE_FUNCTION_PROCEDURES.sql
- data/GENERATE_SAMPLE_DATA.sql

8. If no errors are shown we are good to go!

Supervisor

• Khaled Mahmud Shahriar

  • Assistant Professor

    ▶️ Contact:

    Department of Computer Science and Engineering Bangladesh University of Engineering and Technology Dhaka-1000, Bangladesh

(back to top)