

On the class web site I have us-500.csv

The CSV file with the following header line:

"first_name","last_name","company_name","address","city","county","state","zip",
"phone1","phone2","email","web"

and here is the first line of data:
"James","Butt","Benton, John B Jr","6649 N Blue Gum St","New Orleans","Orleans","LA",70116,
"504-621-8927","504-845-1427","jbutt@gmail.com","http://www.bentonjohnbjr.com"


I need a mission critial appl to access customers by 
name and address  (I need Replication, w/ several Data Centers)
(I need to use Consistency in my CQL, maybe... CL=ALL on the writes
  and CL=ONE on the reads?), I should add NodeSync to my Tables

-------------------------------------------------------------

You need to design:

the KeySpace command
the Create Table command
the CL level for write and reads


look at the Cassandra Data Types to define the table
tell me what the DBA needs to do to get the Data Centers for your RF 


======================================================================

Cluster name: ???? <- naming things


        CREATE KEYSPACE ????
         WITH REPLICATION = {'class' : 'NetworkTopologyStrategy',
                             'DC-??' : 2, 'DC-??' : 1};



        CREATE TABLE customers (
         id uuid, (or id int)
         first_name text, 
         last_name text,
         company_name text,
         address text,
         city text,
         county text,
         state text,
         zip int,
         phone list,
         email text,
         web text,
         PRIMARY KEY ((state), city, last_name, first_name, id))
           WITH nodesync = {'enabled' : 'true'}  
        )
        
        
        PRIMARY KEY ((company), id))  <= possibility #1
        PRIMARY KEY ((company, state), id))  <= possibility #2
        PRIMARY KEY ((state, city), id))  <= possibility #3
        PRIMARY KEY ((state, city), address, id))  <= possibility #4
