Database Name:  _____________________________  Table Name: _____________________________

Must have at least 6 columns in your table:

Column Name	(Sqlite Data Types are:   text, integer, or real)

 

Which column is your primary key? _____________________________________

Choose two fields (columns) that you will allow the user to update: ________________________________

 

Write the SQL statements that you plan to use in the code:

DDL  - SQL Statement to drop table:

 

DDL - SQL Statement to create table:

 

DML - SQL Statement to insert a new row:

 

DML - SQL Statement to retrieve all columns from all rows:

 

DML - SQL Statement to retrieve all columns from one row based on the primary key:

 

DML - SQL Statement to update two fields of one row based on the primary key:

 

DML - SQL Statement to delete one row based on the primary key: