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. Jan 10, 2018 at 16:15
  • 2
    It is not correct. What are the functional dependencies in the table? Jan 10, 2018 at 16:20
  • DavidBrowne-Microsoft Only the tripName is the one which is functionaly dependent on TripId others are not. Jan 10, 2018 at 16:45


Your Answer

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

Browse other questions tagged or ask your own question.