JNTU B.Tech (CSE-IV-Sem) Database Management Systems Lab

Question

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

JNTU Home

Answer 1

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 Relational Data Model and Language: Relational data model concepts, integrity constraints, Keys domain constraints, referential integrity,  triggers .  relational algebra Intersection operation relational calculus, tuple calculus Domain relational calculus
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. Normalisation part 1 Normalisation part 2
4.	Installation of Mysql and practicing DDL commands Installation of MySql. In this week you will learn Creating databases, How to create tables Perform the following operation for demonstrating the insertion, updation and deletion
5.	Practicing DML commands DML commands are used to for managing data within schema objects.
6.	Querying This week practice on queries (along with sub queries)
7.	Querying (continued…) This students practices on queries using Aggregate functions (COUNT,SUM, AVG, and MAX and MIN), GROUP BY, HAVING   Creation and dropping of Views.
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.