Im attempting to create a er diagram to a database for a expert system car finder program that, ask questions find best match for user, I having trouble understanding how to propertly setup the database.

Each category would have four class for CAR,TRUCK SUV,VAN since one class of vehicle could be in multiple categories. Ex. Car could be efficient, sports or luxury Effcient Class gas/electric/hybrid Mpg Family Class Seats Safety_rating Other than class attribute, we can use 3-5 attributes specific to category of vehicles to narrow down results via questioning Vehicle PK | VID Year Make Model Price Link Sports Class No_Cylinders Engine_size Category Luxury Class No features Utility Class Hauling/Towing_Capacity