Database Diagram

Question

Hi can someone tell me is this correct diagram? I'm not sure have I made all the foreign keys and primary keys ok. Thanks.

Momir Gostimir · Answer

Well idea is pretty simple. I basically need the names of brandmodel what kind of engine how big engine is and it's lentgth and others.. Do you think i should extract that data from MAIN table or? On my website when i click onexample BMW I should get list of models and engines and everything.. It should look like this in website: BMW 3 Brand Model Engine Type Engine Volume Width Length Heighth Acceleration BMW 3 Diesel 2.0 1.8m 4.5m 1.5m 9.5sec

Piyush Pansuriya · Answer

Hello Momir Yes it is correct diagram to see but its depent on to perfom a query..