Be the first to review “DATABASE MANAGEMENT SYSTEMS (KTU SYLLABUS)” Cancel reply
DBMS concepts with laboratory-based questions along with answers. It is prepared especially for Kerala Technological University B.Tech CSE students.
Design a database schema for an application with ER diagram from a problem description
Creation, modification, configuration, and deletion of databases using UI and SQL Commands
Creation of database schema – DDL (create tables, set constraints, enforce relationships, create indices, delete and modify tables). Export ER diagram from the database and verify relationships** (with the ER diagram designed in step 1).
Database initialization – Data insert, Data import to a database (bulk import using UI and SQL Commands)
Practice SQL commands for DML (insertion, updating, altering, deletion of data, and viewing/querying records based on condition in databases).
Implementation of built-in functions in RDBMS
Implementation of various aggregate functions in SQL
Implementation of Order By, Group By & Having clause
Implementation of set operators nested queries, and join queries
Practice of SQL TCL commands like Rollback, Commit, Savepoint
Practice of SQL DCL commands for granting and revoking user privileges
Practice of SQL commands for creation of views and assertions
Implementation of various control structures like IFTHEN, IF-THEN-ELSE, IF-THENEL SIF, CASE, WHILE using PL/SQL
Creation of Procedures, Triggers and Functions
Creation of Packages
Creation of Cursors
Database backup and restore using commands
Design a database application using any front-end tool for any problem selected. The application constructed should have five or more tables
Reviews
There are no reviews yet.