IGNOU BCSL 135 2026 2027 - Display the customer name, vehicle registration number, service

Question

Display the customer name, vehicle registration number, service date, and service type for all vehicles serviced during a specified month.

08 Aug 2026

Answer :

Word Count : 1071

In a vehicle service management database, customer, vehicle, and service information are generally stored in separate but related tables. To display the customer name, vehicle registration number, service date, and service type for all vehicles serviced during a specified month, SQL can be used to retrieve the required records by joining the relevant tables and applying a date-based condition. A suitable database design may contain the following tables: Customer Table | Field | Description | | ------------- | -------------------------------------------- | | Customer_ID | Unique identification number of the customer | | Customer_Name | Name of the customer | | Phone | Customer contact number | | Address | Customer address | Vehicle Table | Field | Description | | --------------- | ------------------------------------------- | | Vehicle_ID | Unique identification number of the vehicle | | Customer_ID | Identification number of the vehicle owner | | Registration_No | Vehicle registration number | | Model | Vehicle model | | Vehicle_Type | Type of vehicle | Service Table | Field | Description | | ------------ | --------------------------------------------- | | Service_ID | Unique service identification number | | Vehicle_ID | Identification number of the serviced vehicle | | Service_Date | Date on which service was performed | | Service_Type | Type of service performed | | Service_Cost | Cost of service | The relationship between these tables is established using primary and foreign keys. `Customer_ID` in the Vehicle table refers to the customer who owns the vehicle, while `Vehicle_ID` in the Service table identifies the vehicle that received the service. For

_______ _______ _______ __________ _________ _____ ___.
_________ ___ _________ __________ _______ ________ ___ _______ ___ ___.
_____ _________ __________ _______ ___ __________ _______ _____ _______.
________ _________ ____ _______ _________ ____ __________ __________ ____ ________.
__________ _________ ________ ___ ________ ___ _______ ____ _________ __________ ____ ___.
____ ________ __________ __________ ___ ____ ______ _______ _____.
___ _________ ___ ___ _______ ________.
_______ ______ _______ __________ _________ _____ ___ __________ _______.
_____ _____ _______ ________ ____.
___ __________ ___ ______ ________ _______ __________ __________.
__________ _______ _________ ____ _________ ____.
__________ ______ _________ ___ ____ ______.
________ __________ ______ ______ ______ ______ ________ ____.
_______ ________ ____ _____ _______ ____ ___ __________ _______ ___ _______ ______.
___ _________ _________ _____ ______ _________ ___ ______ _______ _________ __________ ________.
__________ _________ __________ _____ _________ _________ ______ ______ ________.
___ ______ _________ ________ __________ _____ _______ __________ _____ ____ __________ ________.
_________ ________ _________ _________ ___ ________ _______ ___ _______ ________ _________ _________.
___ ________ ____ _________ ___ __________ __________ _________ _________ _______.
____ ______ ____ ___ __________ __________ ________ ______ __________ ____ _______.
_______ ___ ________ _____ _______ _________ ____ ____.
_______ _______ ___ ___ ____ _________ ___ ____.
________ ___ ______ _____ ___ __________ _____ ___ ________ ______ _______ ____.
__________ __________ ________ __________ ________.
______ _______ ________ __________ ____ ___ ____ ________ ________.
____ ____ _______ ____ ____.
_____ ________ ______ _______ ___ ________ ____ ________ _________ ________ ____.
__________ ______ ____ __________ _______ __________ ________ ______ ____.
__________ _______ __________ _______ _________ __________ ______ _____.
_____ ________ ______ ____ _______ ___ ________ _______ _______ ____ ___ _____.
________ _______ _______ ____ _________ ______ ___.
________ ________ _______ _________ _________ _____ ________ _________ __________.
________ _____ _____ _______ _________ ___ ___ ______ ___ __________ _________.
______ ________ ____ ___ ________ ____.
__________ _______ ______ __________ ___ __________ ___ _________.
________ ________ ______ ___ ____ ______ ____.
______ ___ __________ ______ ______ ___.
_________ _______ _____ ______ ________ ____ _______ _____ ______.
_______ ________ _______ ________ _______ _______ ________ ______ __________ ____ ______.
__________ __________ ________ __________ ________ __________ __________.
________ _________ _______ _________ ____ __________ _________.
____ ________ _________ ___ ______ _____ ___.
__________ ________ _____ ____ _______ _______ ________ _________ _____ ___ ______ _____.
__________ __________ ________ _____ _______ ________ _________ _______ _____ __________.
______ ____ ______ ______ ______.
_____ __________ ______ ________ ________.
_________ ___ _______ _________ __________ _______ ____ __________ _____ _____ ____ ________.
___ __________ ______ ____ _____ ____ __________ _______ __________ ____ _______.
_____ ________ ________ _____ ______ _______ ________ _____ __________ ____ _____.
_____ ____ ____ __________ __________ _______ _______ _________ ____ ___ ______ _________.
_________ ________ _________ ______ _______ _____ __________ ______ __________ _____ _____ _________.
_____ ____ _______ _________ ________ ________ ____ _______.
__________ ______ ___ _______ _________ _____ ____ ________ ___ _________ ____.
_____ ______ ___ _____ ___ _________.
__________ ___ ____ ___ ___ ____.
____ ________ ____ _____ _______ ___ ________ ________ _____ __________ __________.
_______ ______ _________ ____ ______ ___ ________ ______ _______ ___ _____ ___.
________ ___ ______ ______ _____ ____ _______ _________ _____ _____ __________.
___ _______ __________ ______ _____ ______ ___ _______.
_________ _________ _____ ________ ____ ______ _________.
________ _______ ___ _________ _________.
_________ __________ ________ ______ ____ __________.
_____ _______ ____ _______ ______ ___.
______ ______ ______ ____ _____ _______.
_______ ________ ____ ______ ____ ______ ______ _______ _____.
_______ _____ _______ ____ _____ ________ __________ _____ ______ ________ ______ ____.
_________ _____ ___ ___ _________.
________ __________ ______ ___ __________ _______ ___.
________ ____ _______ ________ ___ _______ __________ ________ _______ ____ _________.
________ _______ _________ ___ _____ ______ ____ _________ ______ _______ ____ __________.
________ ____ ____ ________ _______ ______ ______ ______ __________ _________.
___ _________ _____ _________ _____ ______.
______ ________ ______ ______ _________ ____ _________ ________.
______ ___ ______ _____ ____ ________.
___ ______ ____ _____ __________ ______ ___.
_________ ___ __________ ____ ________.
__________ _____ _________ ______ __________ _________ __________ _________ ________ ___ ______.
____ _________ _________ _____ ________ _________ __________ ___ ___ _________ ________.
_________ ____ __________ ________ ________ _________ __________ __________ _________ _______.
_________ _________ ___ __________ ___ _______ _________.
_____ _____ ___ __________ _______ ______.
_________ _______ ___ ___ ______ ___ ____ ________ _____ ___ ______ _____.
_______ ____ _______ ________ _________ _____ ______ _____ ________ _____ __________ ________.
________ ___ ________ ____ ________ _____ _______ ______ _______ ___.
____ ______ ______ ____ ______ _______ ___ _______ ___ __________ ______ _______.
_________ _____ _________ _______ _____ _________ ________ _______ _______ __________ ________.
______ _________ ________ _________ ___ ____ _____ ________.
____ ___ _______ __________ ______.
_____ _____ ______ ___ ______ ______ ___ ___ ________ __________.
_____ __________ _________ _____ _____ ___ _______ ____ ______.
_____ _____ ______ _____ __________ _____ ________ _____ _________ _____.
___ ____ ______ _____ ________ ______ __________ _____ _________ ________ _____ _____.
_______ ________.

IGNOU ACADEMY

Your IGNOU journey, made easier.

Solved Assignments
Study Notes
Guess Papers
Question Papers

Call Us WhatsApp

STUDY • PREPARE • SUCCEED

Skip in 10

IGNOU Solved Assignments Assignments Ignou Projects Project Previous Year Solved Exam Papers Notes Notes Sample Question Papers Sample Question Papers