Archive sem III and sem V DMS and ENDS

 Archive sem III and sem V DMS and ENDS


 Study Notes

Unit I Introduction To Database System 


IMP Questions Unit 2 Relational Data Model 


IMP Questions Unit 3 Interactive SQL and Performance Tuning 


Imp Questions Unit 4 PL SQL Programming


IMP Questions Unit 5 Database Administration





CT 2 Question Bank with Model Answers  Click here







Click here for TY CSE Click here


SY DMS Curriculum Click here

Chapter 3 Notebook Notes Click here

Notes on Index Click here

Chapter 4 Notebook Notes Click here

Chapter 5 Notebook Notes Click here


Outline of DMS Micro Project Report Click here


SY CSE DMS Experiment Dates Click here

DBMS Experiment 2 Click here      Submit Screenshot

DBMS Experiment 3 Click here

DBMS Experiment 4 Click here

DBMS Experiment 5 Click here

DBMS Experiment No 6 Click here

DBMS Experiment No 10 Click here

DBMS Experiment No 15 Click here

DBMS Experiment No 16 Click here

DBMS Experiment No 17 Click here

DBMS Experiment No 18 Click here

DBMS Experiment No 19 Click here

DBMS Experiment No 20 skip it

DBMS Experiment No 21 Click here

DBMS Experiment No 22 Click here

DBMS Experiment No 23 Click here

DBMS Experiment No 24 Click here

DBMS Experiment No 25 Click here

DBMS Experiment No 26 Click here





2nd Sept Practice Click here

Link to install MySQL Workbench Click here




Important Questions




TO FILL DATA CLICK HERE


What Are Codd’s Rules? Click here

Unit - II  Relational Data Model Click here


LLO 2.1 Create Database schema for given application Click here

for guidance video   click here




Assignment no. 1  Click here

What is Database and DBMS? Click here

File System vs. DBMS Click here

Applications of DBMS Click here

Data Abstraction and Independence Click here

Database Schema Click here 

Codd’s Rules Click here


What is SQL Click here

Inside Amazon's Massive Data Center click here






Tutorial 1

LLO 1.1 Install database software
Install the provided database software
LLO 1.1: Install database software (MySQL database software)

----------------------------------------------------------------------------------------------------------------------------

Tutorial 2

LLO 2.1 Create Database schema for given application

Note :- Ensure to Carry out following activities before creating database:
- Draw ER diagram for given problem
- Normalize the relation up to 3NF
1) Create Database for given application
2) Create tables for the given application
3)Assign Primary key for created table
4) Modify the table as per the application needs




----------------------------------------------------------------------------------------------------------------------------

To read How to develop your logic to write SQL schema click here 
To read Extra Information on Normalization Justification (3NF) Click here



1. Introduction to SQLite

2. Create and Read SQLite Databases using DB Browser

16 July Lecture

Unit - I Introduction To Database System


2.1  https://www.youtube.com/watch?v=N6CRIdBnFXU

2.2  https://www.youtube.com/watch?v=HjMaK8JgOnE

2.3  https://www.youtube.com/watch?v=KUW1bE749d4

2.4  https://www.youtube.com/watch?v=mND2TdMBqks&list=PLC66lp0nzF3Lay2H2Xtsms1o4QtOC1BAH&index=9

2.5  https://www.youtube.com/watch?v=tF5PK02WVVg



Playlist  https://www.youtube.com/playlist?list=PLC66lp0nzF3Lay2H2Xtsms1o4QtOC1BAH



ER Diagrams click here

Project topics Click here

Popular posts from this blog