- Appropriately link the 4 tables together using primary and foreign keys
- Fill each table with a minimum of 5 records each
I have created the make, model, and color tables, and set each to have corresponding columns: make_id, model_id, and color_id. Now I am curious as to how I can create the complete_vehicle table and have it pull the records from the other three tables.
Question
Yorak
Create a vehicle database that:
- Contains 4 tables (make, model, color, complete_vehicle)
- Appropriately link the 4 tables together using primary and foreign keys
- Fill each table with a minimum of 5 records each
I have created the make, model, and color tables, and set each to have corresponding columns: make_id, model_id, and color_id. Now I am curious as to how I can create the complete_vehicle table and have it pull the records from the other three tables.
Any help would be greatly appreciated.
Link to comment
Share on other sites
2 answers to this question
Recommended Posts