Database Management Systems DBMS Lab PCCSL408 Semester 4 KTU CS 2024 Scheme

 About Me

Scheme and Syllabus

Experiments






Build a web application based on sample database- use Php-MySQL

Comments

Post a Comment

Popular posts from this blog

Stored Procedures in MySQL

  CREATION OF STORED PROCEDURES IN MySQL 1. AIM To study and implement Stored Procedures in MySQL. 2. THEORY ✔ What is a Stored Procedure? A Stored Procedure is a precompiled block of SQL statements stored in the database and executed on demand. ✔ Advantages of Stored Procedures Improves performance (precompiled) Ensures reusability of code Helps maintain data integrity Reduces network traffic Provides security by restricting direct table access 3. GENERAL SYNTAX (MySQL) MySQL requires the DELIMITER command when creating procedures to avoid conflict with semicolons. DELIMITER $$ CREATE PROCEDURE procedure_name (parameter_list) BEGIN SQL statements; END $$ DELIMITER ; ✔ Calling a Procedure CALL procedure_name(arguments); 4. EXAMPLES  ⭐ Example 1: Procedure Without Parameters ▶ Create a table for demonstration CREATE TABLE employees ( id INT PRIMARY KEY, name VARCHAR ( 100 ), salary DECIMAL ( 10 , 2 ) ); ▶ Inse...
Read more

DBMS Lab PCCSL408 2024 Scheme and Syllabus

  DBMS LAB (Commonto CS/CD/CR/CA/AD/AI/CB/CN/CC/CU/CI/CG)   Course Code PCCSL408 CIE Marks 50 Teaching Hours/Week (L: T:P: R) 0:0:3:0 ESE Marks 50 Credits 2 Exam Hours 2Hrs.30 Min. Prerequisites(if any) None Course  Type Lab Course  Objectives: 1.        To equip students with comprehensive skills in SQL,PL/SQL, and NoSQL databases.   2.        To enable the learner to proficiently design,implement,and manage relational and non- relational databases to meet diverse data management needs   Expt. No. Experiments 1 Design a database schema for an application with ERdiagram from ap roblem  description.   2 Creation of database schema-DDL(createtables...
Read more