Display the service history of a specified vehicle in chronological order.

 Find the registration numbers and owner names of vehicles that have never undergone servicing.

Find the registration numbers and owner names

 Display the mechanic name along with the total number of vehicles serviced by each mechanic.

 List the names of customers who own more than one vehicle.

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

 SQL Queries: 

 Database Schema: (10 Marks)
Create the necessary tables to store the following information:
 A unique Contact_ID for each contact.
 Customer Name, Address, Mobile Number, and Email Address.
 A unique Vehicle_ID for each vehicle.
 Vehicle Registration Number, Model, Manufacturer, Year of Manufacture, and Fuel Type.
 Each customer may own multiple vehicles.
 A unique Mechanic_ID for each mechanic.
 Mechanic Name, Specialization, Experience, and Contact Number.
 A unique Service_ID for each service transaction.
 Service Date, Service Type (Periodic Service, General Repair, Engine Repair, Electrical Repair, Washing, etc.), Labour Charges, Spare Parts Cost, and Total Bill Amount.
 Each service transaction must be assigned to one mechanic.
 Multiple spare parts may be used during a service. Store the Part_ID, Part Name, Quantity, and Unit Price for each spare part. Your design should include:
 An ER Diagram for the Vehicle Service Management System.
 The final set of tables with all columns clearly defined.
 Underline the Primary Key and specify all Foreign Keys.
 Ensure that the database schema satisfies Third Normal Form (3NF).

: Project: Vehicle Service Management System
You are required to design and develop a Vehicle Service Management System for an automobile service
centre. This project will be completed in two parts. In Section A, you will design the database schema and
write SQL queries. In Section B, you will develop a C++ console application to manage vehicle service
records.
Section A:
Design a database schema in Third Normal Form (3NF) for the Vehicle Service Management System.

. Normal distribution curve

 Data mining

Coefficient of variation

Multivariate analysis

 Differentiate between Census and Survey data. What are the various stages involved in planning and organizing the censuses and surveys?

Explain the term ‘qualitative research design’. How it is different from quantitative research design? What are the various techniques of qualitative research design?

 Test the significance of the correlation coefficient considering α=0.05 and critical values obtained from t-distribution table is ±2.776.

The study wanted to analyse whether there is any significant relationship between the number of rental cars that the agency owns and its annual income. Compute the correlation coefficient from the given table.

 The following table presents the list of agencies owning different number of rental cars. The annual income for each of these agencies is given here. Agency Cars (in ten thousand) Revenue (in Rs Crores)
A 63.0 7.0
B 29.0 3.9
C 20.8 2.1
D 19.1 2.8
E 13.4 1.4
F 8.5 1.5

 Maternal Feminism

Women in Anti-Colonial Movements