Department of Electronics & Telecommunciation,
Don Bosco Institute of Technology, Mumbai.
Course Coordinator: Mr. Jithin Isaac
To learn & implement a Derived Attribute, Views & Triggers on a database
- Software:
- MariaDB
- XAMPP
- Heidi SQL
- Git
- 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)
- Import the Dreamhome database in HeidiSQL
- Run SQL queries to implement Derived attribute & Views
- Import the database required for Triggers from triggers.sql file
- Create a trigger for various events
Screenshots & Video of outputs obtained for the following queries
- Derived Attribute using CREATE TABLE syntax
- Derived Attribute using SELECT syntax
- Creating & Selecting a View from single table
- Creating & Selecting a View from multiple tables
- Creatign a View for Update operation without CHECK OPTION & Updating it by Inserting & Deleting rows in the view
- Creatign a View for Update operation with CHECK OPTION & Updating it
- Creating Single Table dependency trigger for Before Insert
- Creating Single Table dependency trigger for Before Update
- Creating Multiple Table dependency trigger for Before Insert
- Add the procedure that you used to complete the experiment
- Add screenshots of your output along with a link to your video
- Submitted on 09-05-2021
- Submitted by Mr/Ms. XYZ
- Roll No. 999