Work Integrated Learning IT – DMA

• Beginners should familiarize themselves with the interface.
• Beginners should go through demos and tutorials.
• Special routine needed for providing rating to a seller: Yes, a routine for inserting and updating ratings
• Functionalities that should be supported by class Product: insert_seller, delete_seller, modify_seller, display_seller
• Changes needed in PAYMENT table for refunding payment: Yes, a routine for updating payment status and refunding the payment
• Routines associated with the newly added wish list information: insert_wish, delete_wish, display_wish
• Extra information that can be added to the database CUSTOMER: Wish list
• The XYZ Shopping Website allows users to shop online with 24 X 7 access.
• Customers can select items and add them to their shopping cart.
• The CATEGORY table stores information such as category id, name, and description.
• The SELLER table stores details about the sellers including seller id and rating.
• The website allows users to compare products before making a choice.
• Once payment is made, goods are delivered to the specified address.
• The website layout includes a left panel with product categories, a center panel with product pictures, and a right panel with offers, contact links, login, and order tracking.
• The CUSTOMER table stores customer details including customer id, password, first name, last name, address, email id, and contact number.
• The website offers a wide range of products including books, clothes, stationery, kitchen appliances, and electronic items.
• Payment options include Cash on Delivery, credit/debit card, and net banking.
• The PRODUCT table stores details of products including product id, name, category id, price, quantity, discount, brand, color, size, and seller id.
• The database for the shopping application includes tables for categories, products, customers, sellers, wish lists, and orders.
• The WISH_LIST table stores details about products that customers wish to buy in the future, including customer id and product ids.
• The ORDER table stores details of all the orders placed till date.
• Database management systems have found application in various domains as they provide efficient storage and fast retrieval of data.
• Database applications may be used for storing information such as student details, marks and result.
• Database applications may be used for storing information about faculty and staff members.
• Database applications may be used for storing details about school/college such as infrastructure details, department and offered course details.
• Database applications may be used for storing information about customers.
• Database applications may be used for storing personal details such as address, age, PAN card, occupation, contact numbers.
• Database applications may be used for storing accounts and loans related information.
• Database applications may be used for storing information regarding daily transactions.
• Database applications may be used for storing employee details such as their personal information, salary, leaves taken, joining date, retirement year.
• Database applications may be used for maintaining information regarding patients such as their personal details, health records, hospitalization date.
• Database applications may be used for storing information regarding doctors, nurses, staff members, rooms, medical equipment, and medicines.
• Database applications may be used for storing details of electoral roll, all types of taxes (Income tax, sales tax, house tax etc.), criminal records.
• Database applications may be used for storing details of PAN cards, AADHAR cards, vehicle registration, birth/death certificate registration.
• Database applications may be used for storing information regarding employees such as name, address, contact number, salary, position, joining date.
• Database applications may be used for maintaining information regarding the projects handled by employees.
• Database applications may be used for keeping track of infrastructure, sales, and investments.
• Database applications may be used for storing information regarding products such as price, quantity, quality, manufacturing date, seller.
• Database applications may be used for storing information regarding customers such as name, contact number, address and their orders.
• Database applications may be used for storing information about flight details such as arrival time, departure time, fares, passenger capacity, number of bookings.