III B.E. (Computer Engg.)

VI SEMESTER

6CP8 DATABASE APPLICATION LAB

Each experiment is designed for two lab classes. Student can use any DBMS tool (MS Access/ORACLE/PLSQL/Foxpro) at backend and C++/VC++/JAVA at front end. Database connectivity tools ODBCI DAO/JDBC WILL BE USED.

1.-2        Design a system for Hotel Management System. System provides facility for room reservation (for different category rooms), and Catering service billing. Customer's order for various food items are recorded during his stay at Hotel and Complete Bill (Including Room Rent and Food consumed) is generated when customer checkouts.

3.-4      Design a Computer Terminal Booking System for booking of 5 named Computer Terminals. for 12-hour duration each day. User may book Terminals after entering their User ID and password and they can book a terminal for maximum 5 hour/day (in continuous slot or fragmented slots). Terminal booking chart is generated for each day for each terminal.

5.-6    Design a Loan Approval and Repayment System to handle Customer's Application for Loan and handle loan repayments by depositing installments and reducing balances.

7.-8    Design a Video Library Management System for managing issue and return of Video tapes/CD's and manage customer's queries.

9.-10 Design a Time Management System for an Office with 10-executives who record their daily appointments in the system. When Manager wan~ to conduct a meeting of Executives on a particular day System finds a free time slot to conduct the meeting.

11.-12  Design an Outdoor- Management System for a Hospital where several experts sit in outdoor room and system registers patients and sends them to appropriate expert. Each Expert can handle a limited number of patients a day.