Question: Help me with this question in database course of Weak Entities and Subtypes lecture : Draw the entities and relationships suggested by each word problem.
Help me with this question in database course of Weak Entities and Subtypes lecture :
Draw the entities and relationships suggested by each word problem. Include the proper foreign key(s).
1-All vehicles have a unique VIN along with a make, model and color. Trucks also have a towing capacity and a bed length. Cars have a number of doors (2, 4 or 5) and a car type (sedan, coupe, hatchback). Our database will also store information on snowmobile, 4-wheelers, motorcycles and possibly other vehicles. No vehicle is both a car and a truck (the El Camino and Ranchero were both based on car bodies).
2- #4 again, but there are only cars and trucks, no other types of vehicles.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
