Products for Hire

The Bookings table records detailed information about each rental transaction. It includes fields such as the Booking Number, the Customer Name, and the Booking Status (active, completed, or canceled). It also tracks key financial aspects like the Amount Payable, Discounts, Outstanding Amounts, and Refunds. Additionally, it records whether products were returned damaged, providing a comprehensive overview of each rental booking.

The Customers table records each customer, including their First Name, Last Name, and Gender, along with a rating field (Good Or Bad Customer) that indicates their reliability. The table also tracks important dates, such as when the customer first hired a product (Date Became Customer) and their most recent rental (Date Last Hire), helping identify long-term or repeat customers.

The Payments table logs the financial transactions associated with bookings. It tracks the Booking Number, Payment Type, Amount Paid, and the Payment Date. This table is crucial for monitoring whether the customer has completed their payments and tracking any outstanding amounts for each booking.

The Products Booked table stores information about the products that were rented. It connects each product to the relevant booking via the Booking Number, and tracks whether the product was Returned and whether it was Returned Late. This table also captures the number of products hired (Booked Count) and the total cost associated with each booking (Booked Amount).

The Products For Hire table contains the list of items available for rental. It includes the Product Name, Type, Daily Hire Cost, and a Product Description. This table serves as the inventory, providing details on what is available for hire, along with pricing and other product-specific information.