Student can use MySql (preferred open source DBMS) or any other Commercial DBMS tool (MSAccess
/ 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 customer's queries.