This is a repository for DBMS Lab assignments in Second year Information Technology of SPPU!
Do star ⭐ this Repository if you feel it helped & drop a follow!
💙 Happy Learning 💙
Language used : MYSQL
Database Management System (SEM-4) - ER/EER Diagram, DDL statements, primary key and foreign key constraint., SQL queries with different functions, Views, PL/SQL, Trigger (Row level and statement level) and cursor.
Design any database with at least 3 entities and relationships between them. Draw suitable ER/EER diagram for the system.
Design and implement a database (for assignment 1) using DDL statements and apply normalization on the.
Multinational Company Manages information of Employees. Each Employee has unique ID. Each Employee works on project in some department. Design ER Diagram for Employee Management System
Create table with primary key and foreign key constraint.
[a] Alter table with add and modify
[b] Drop Table
Perform following SQL queries on the database created in Assignment 1.
• Implementation of relational operators in SQL
• Boolean operators and pattern matching
• Arithmetic operations and built in functions
• Group functions
• Processing Date and Time functions
• Complex queries and set operators
Execute DDL statements which demonstrate use of Views.
Write and execute PL/SQL stored procedure and function to perform a suitable task on the database.
Write a database trigger (Row level and statement level)
Write a PL/SQL block to implement all types of Cursors
