Question

JECRC University B.Tech(CSE-IV Sem) Database Management System Lab Experiments with Solutions

JECRC Home

Answer 1

JECRC University B.Tech(CSE-IV Sem) Database Management System Lab

S.No.	List of Experiments
1.	Installation of MySQL.
2.	Analyze the problem and come with the entities in it.
3.	Represent all entities relationships .
4.	Creating of Tables on given problem.
5.	Applying Not Null, Check, Unique Constraints on database Tables.
6.	Applying Primary Key, Foreign Key Constraints on database Tables.
7.	Applying Insert, Select, Distinct Clause, Where Clause on database Tables.
8.	Applying Update, Delete, Drop, on database Tables.
9.	Applying table creation with select, Insert data using select, Renaming on database Tables.
10.	Practice Queries using MINUS, UNION, INTERSECT.
11.	Practice Queries using Group Functions.
12.	Practice Queries using Group By, Having, Order By Functions.
13.	Practice Queries using Arithmetic Operators, Comparison Operator.
14.	Practice Queries using Logical Operator.
15.	Practice Queries using any four String Functions.
16.	Practice Queries using any four String Functions.
17.	Practice Queries using Numeric Functions.
18.	Practice Queries using Date Functions.
19.	Creating index