Database Name: _____________________________ Table Name: _____________________________ Must have at least 6 columns in your table: Column Name
Question:
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:
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill