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

Question

Biju Patanaik University of Technology(BPUT) B.Tech (CSE IV-Sem) Database Management System Lab Experiments and Solutions With Required Theory

BPUT Home

Answer 1

Biju Patanaik University of Technology(BPUT) B.Tech (CSE IV-Sem) Database Management System Lab

S.No.	List of Experiments
1.	Use of SQL syntax:  Design a Database and create required tables. For e.g. Bank, College Database.  Apply the constraints like Primary Key, Foreign key, NOT NULL to the tables.  Write a SQL statement for implementing ALTER,UPDATE and DELETE. Write the queries to implement the joins.
2.	Write the query to implement the concept of Integrity constrains.
3.	Write the queries about indexes and unique indexes
4.	Programs on database triggers. (1 class)
5.	Consider the following relational schema  For Complete solution click here Student (Rollno, Name, Address, DOB, C_id) Course ( C_id, Cname, Dur, Fees) Display rollno,name,cname,fees of each student Count the no of students in each course
6.	Programs on data recovery using  commit , save point technique. (1 class)
7.	Concurrency control problem using lock operations. (1 class)
8.	Programs on ODBC using either VB or VC++. (1 class)
9.	Programs on JDBC. (1 class)
10.	Programs on embedded SQL using C / C++ as host language. (1 class)