Work Integreted Learning Notes – Class 12 IT(802)

Here are exam-focused, well-organized, and CBSE syllabus-aligned study notes for Work Integrated Learning of Class 12 Information Technology (Subject Code: 802). These work integreted learning notes are designed to simplify concepts, strengthen understanding, and help students prepare effectively for board examinations.

Work Integrated Learning IT – DMA

• Work Integrated Learning (WIL) is a method of education where students use what they learn in theory and apply it in real workplace settings or practical, work-related simulations.
• Specifically, this unit is centered on Database Management Applications (DMA), showing how information technology concepts are applied across different industries to manage, organize, and utilize data effectively in real-world situations.

Identification of Potential Work Areas

DBMS provides efficient storage and fast retrieval in various domains:

• Education: Stores student details, marks, results, faculty information, and infrastructure details.
• Banking: Stores customer personal details, accounts, loans, daily transactions, and employee details.
• Hospitals: Maintains patient health records, hospitalization dates, and information on staff and medical equipment.
• Government Sector: Stores electoral rolls, taxes (Income, sales, house), criminal records, and registration details (PAN, AADHAR, birth/death).
• Companies: Manages employee information, projects handled, sales, and investments.
• E-Commerce: Stores product details (price, quantity, seller) and customer order information.
• Airlines & (H) Railways: Tracks flight/train details (times, fares, capacity) and online/offline reservations.
• Telecommunications: Stores network data, customer call records, bills, and subscription plans.
• Hotels: Manages guest check-in/out, room allocations, staff, and menus.

A Shopping Website – A Case Study

The XYZ Shopping Website allows access to products like books, clothes, and electronics. Customers use a shopping cart, perform comparative analysis, and pay via Cash on Delivery, cards, or net banking.

Entities Involved

The following entities (tables) are identified for the database (Primary Keys are underlined):

1. CATEGORY (Category_id, Name, Description)
2. PRODUCT (Product_id, Name, Category_id, Price, Quantity, Discount, Brand, Color, Size, Seller_id, Description)
3. CUSTOMER (Customer_id, Password, First_name, Last_name, Address, Email_id, Contact_num)
4. SELLER (Seller_id, Rating)
5. WISH_LIST (Customer_id, Product_id)
6. ORDER (Order_id, Customer_id, Product_id, Shipment_id, Order_date, Current_status)
7. SHIPMENT (Shipment_id, Details, Shipment_date)
8. PAYMENT (Payment_id, Order_id, Payment_amount, Payment_date, Mode)

Functionality and Java Classes

The application manages these tables through specific Java classes:

• Class Category: Includes insert_category, delete_category, modify_category, and display_category (using SELECT).
• Class Product: Includes insert_product, delete_product, modify_product, and display_product.
• Class Seller: Includes insert_seller, delete_seller, modify_seller, and display_seller.
• Class Customer: Includes insert_customer and modify_customer to handle user registration and profile updates.
• Class WishList: Includes insert_wish, delete_wish, and display_wish.
• Class Payment: Includes insert_payment to store transaction details.
• Class Order: Includes insert_order, delete_order (for cancellations), and display_order (for tracking).
• Class Shipment: Includes insert_shipment_details to record dispatch information.

Sequence of Events for Order Completion

1. Add items to shopping cart.
2. Select “Buy” option.
3. Provide details or login.
4. Choose payment option (and pay if not Cash on Delivery).