I have data
Customer(Cust_id, Cust_fname, Cust_lname, Phone_area_code, Cust_phone, Cust_balance)

and want to create it in sql with Cust_id as the primary key.

I came up with this.

Create collection assignment2
Create table assignment2.customer (cust_id char (10 ) not null with default, cust_fname char (10 ) not null with default, cust_lname char (10 ) not null with default, phone_area_code char (3 ) not null with default, cust_phone char (7 ) not null with default, cust_balance char (10 ) not null with default, constraint assignment2.cust_id_pk primary key (cust_id))
Table customer created in assignment2



am I on the right track?