III B.E. (Information Technology)

V SEMESTER

5 IT 10 DATA BASE LAB

Each experiment is designed for two lab classes. Student can use any DBMS tool (MS Access) ORACLE/PSQL/ Fox pro) at back and C++/VC++/Java at front end. Database connectivity tools ODBC/DAO/JDBC will be used.

1-2 Design a system for Hotel Management Systems. 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 an 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 is sue and return of video tapes/Cd’s and manage customer’s queries.

9-10 Design a Time Management System for an office with 10-executive who record their daily appointments in the system. When Manager wants to conduct a meeting of Executive on a particular day System finds a free time slot of 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 on patients a day.