title: Migrate RDBMS to Cassandra
body: <p>I have a RDBMS database with the following tables:</p>
  
  <p><strong>Airport</strong> ( iata <strong>PK</strong>, airport, city, state, country, lat, long)</p>
  
  <p><strong>cancellation_cause</strong> ( cod_cancellation <strong>PK</strong>, description)</p>
  
  <p><strong>Manufaturer</strong> (id_manufacturer <strong>PK</strong>, manufacturer_name)</p>
  
  <p><strong>Model</strong> (id_model <strong>PK</strong>, model_name, id_manufacturer <strong>FK</strong>)</p>
  
  <p><strong>Airline</strong>( airline_code <strong>PK</strong>, description)</p>
  
  <p><strong>airplane_type</strong> (id_AirplaneType <strong>PK</strong>, airplane_type)</p>
  
  <p><strong>engine_type</strong> (id_engine <strong>PK</strong>, engine_type)</p>
  
  <p><strong>Aircraft_type</strong> (id_aircraft <strong>PK</strong>, aircraft_type)</p>
  
  <p><strong>Airplane</strong> (TailNumber <strong>PK</strong>, id_model <strong>FK,</strong> id_aircraft <strong>FK</strong>, airline_code <strong>FK</strong>, id_AirplaneType <strong>FK</strong>, id_engine <strong>FK,</strong> Issue_date, status, year)</p>
  
  <p><strong>Flight</strong> (id_flight <strong>PK</strong>, cod_cancellation <strong>FK</strong>, TailNumber <strong>FK</strong>, iata_origin <strong>FK</strong>, iata_destin <strong>FK</strong>, Year, Month, DayofMonth, DayofWeek, DepTime, CRSTime, ArrTime, CRSArrTime, FlightNum, AtualElapsedTime, CRSElapsedTime, AirTime, ArrDelay, DepDelay, distance, TaxiIn, TaiOut, Cancelled, Diverted)</p>
  
  <p><strong><em>Note: PK - Primary Key; FK - Foreign Key</em></strong></p>
  
  <p>I'm conducting a comparative study between RDBMS and Cassandra databases. My goal is to migrate this database to Cassandra and run some queries in both in order to compare the performance of both in a similar case.</p>
  
  <p>Can anyone tell me the best way to do this? How I should model the database in Cassandra?</p>