DBMS Project

Part 1

  1. In this part we will create the database and load all out tables using relevent DDL files
  2. We will also load relevent data depicting the business use cases through DML files
  3. We will also highlight specific triggers and all the business constrints

Setup steps

Note: We need to install docker to run this mysql server

  1. To run mysql server use command - docker-compose up -d
  2. To stop the server use command - docker-compose down
  3. Server Details are available in docker-compose.yml which include passwords and user and database schema
  4. To connect to the database use client like DBWeaver