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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!