5 IT 9. DATABASE LAB

Student can use MySql (preferred open source DBMS) or any other Commercial DBMS tool (MS-Access / ORACLE) at

backend and C++ (preferred) VB/JAVA at front end.

1.   (a) Write a C++ program to store students records (roll no, name, father name) of a class using file handling.

(Use C++ and File handling).

(b) Re-write program 1, using any DBMS and any compatible language.(C++/MySQL) (VB and MS-Access)

2.  Database creation/ deletion, table creation/ deletion.

(a)   Write a program to take a string as input from user. Create a database of same name. Now ask user to input two

more string, create two tables of these names in above database.

(b)  Write a program, which ask user to enter database name and table name to delete. If database exist and table

exist then delete that table.

3.  Write a program, which ask user to enter a valid SQL query and display the result of that query.

4.  Write a program in C++ to parse the user entered query and check the validity of query.

(Only SELECT query with WHERE clause)

5 - 6. Create a database db1, having two tables t1 (id, name, age) and t2 (id, subject, marks).

(a)  Write a query to display name and age of given id (id should be asked as input).

(b)  Write a query to display average age of all students.

(c)  Write a query to display mark-sheet of any student (whose id is given as input).

(d)  Display list of all students sorted by the total marks in all subjects.

7 - 8.   Design a Loan Approval and Repayment System to handle Customer's Application for Loan and handle loan

repayments by

depositing installments and reducing balances.

9 -10.  Design a Video Library Management System for managing issue and return of Video tapes/CD and manage