I'm creating new database based on existing database, performing some normalization. Here is the table containing multiple information, it's basically for booking trips etc enter image description here

I've divided all the info into some tables, I need some expert advice whether is it correct or I need to make some changes? relationship

  • 1
    Where did all the IDs come from? I see only TripID in the data. Commented Jan 10, 2018 at 16:15
  • 2
    It is not correct. What are the functional dependencies in the table? Commented Jan 10, 2018 at 16:20
  • DavidBrowne-Microsoft Only the tripName is the one which is functionaly dependent on TripId others are not. Commented Jan 10, 2018 at 16:45


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.