Code Monkey home page Code Monkey logo

dbms-expt5's Introduction

Database Management Systems| ECCDLO6032

Department of Electronics & Telecommunciation, Don Bosco Institute of Technology, Mumbai.
Course Coordinator: Mr. Jithin Isaac

Laboratory Experiment No. 5

Objective

To learn & implement a Derived Attribute, Views & Triggers on a database

Tools used

  • Software:
    • MariaDB
    • XAMPP
    • Heidi SQL
    • Git

Experiment Outcome

  • Understanding Derived Attribute, Views & Triggers
  • To implement a Derived Attribute using different methods
  • To create, select, update & delete a View
  • To create a trigger for different events (Insert, Update, Delete)

Instructions

  1. Import the Dreamhome database in HeidiSQL
  2. Run SQL queries to implement Derived attribute & Views
  3. Import the database required for Triggers from triggers.sql file
  4. Create a trigger for various events

List of Deliverables for Expt 5

Screenshots & Video of outputs obtained for the following queries

  1. Derived Attribute using CREATE TABLE syntax
  2. Derived Attribute using SELECT syntax
  3. Creating & Selecting a View from single table
  4. Creating & Selecting a View from multiple tables
  5. Creatign a View for Update operation without CHECK OPTION & Updating it by Inserting & Deleting rows in the view
  6. Creatign a View for Update operation with CHECK OPTION & Updating it
  7. Creating Single Table dependency trigger for Before Insert
  8. Creating Single Table dependency trigger for Before Update
  9. Creating Multiple Table dependency trigger for Before Insert

Procedure

  • Add the procedure that you used to complete the experiment

Output

  • Add screenshots of your output along with a link to your video

Submission Details

  • Submitted on 09-05-2021
  • Submitted by Mr/Ms. XYZ
  • Roll No. 999

dbms-expt5's People

Contributors

jithinsisaac avatar

Watchers

 avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.