Online Courses
Free Tutorials  Go to Your University  Placement Preparation 
Goeduhub's Online Courses @ Udemy in Just INR 570/-
Online Training - Youtube Live Class Link
0 like 0 dislike
413 views
in JNTU B.Tech (CSE-IV-Sem) Database Management Systems Lab by Goeduhub's Expert (7.1k points)

Jawaharlal Nehru Technological University(JNTU) B.Tech (CSE-IV-Sem) Database Management Systems Lab Experiments and Solutions With Required Theory

JNTU Home

Goeduhub's Top Online Courses @Udemy

For Indian Students- INR 360/- || For International Students- $9.99/-

S.No.

Course Name

 Coupon

1.

Tensorflow 2 & Keras:Deep Learning & Artificial Intelligence

Apply Coupon

2.

Natural Language Processing-NLP with Deep Learning in Python Apply Coupon

3.

Computer Vision OpenCV Python | YOLO| Deep Learning in Colab Apply Coupon
    More Courses

1 Answer

0 like 0 dislike
by Goeduhub's Expert (7.1k points)
edited by
 
Best answer

Jawaharlal Nehru Technological University(JNTU) B.Tech (CSE-II-II-Sem/IV-Sem) Database Management Systems Lab

S.No.List of Experiments
1.

Concept design with E-R Model

Data modeling using Entity Relationship Model: E.R. model concept, notation for ER diagrams mapping constraints, Keys, Concept of super key, candidate key, primary key generalizations, Aggregation, reducing ER diagrams to tables, extended ER model

2.

Relational Model

3.

Normalization

Database normalization is a technique for designing relational database tables to minimize duplication of information and, in so doing, to safeguard the database against certain types of logical or structural problems, namely data anomalies.

4.

Installation of Mysql and practicing DDL commands

5.

Practicing DML commands

6.

Querying

7.Querying (continued…)
8.

Triggers

This week student works on Triggers. Creation of insert trigger, delete trigger, update trigger. 

9.

Function

In this session the student learns Creation of stored function, Execution of function  Practice functions using the above database.

3.3k questions

7.1k answers

394 comments

4.6k users

Related questions

 Goeduhub:

About Us | Contact Us || Terms & Conditions | Privacy Policy || Youtube Channel || Telegram Channel © goeduhub.com Social::   |  | 
...