Choose an entity class and locate and collect authentic data for a datadase table to be created. Submit your entity choice along with a source of authentic data to tom.brown at the domain

tamuc.edu on or before $24$ October.

Identify a primary key and at least three non$-$key attributes for the table to be created. Choose natural language names for the table and columns, and minimize the use of codes or abbreviations for those names or table data. It is expected that the table will include the major attribute types: integer, character, date, and decimal with fractional part. Choose data types and lengths consistent with the data to be collected and stored.

Create the table.

Insert $6$ to $12$ instances$($rows$)$ representing a meaningful subset of data for your entity class. Character data should be in the same case: upper or lower or "initial cap".

Code a SELECT statement to query your table.

Remove one row from your table with a DELETE statement. The restrict clause should reference the primary key.

Issue an UPDATE statement to modify one of the nonkey column values in another row. The restrict clause should reference the primary key.

After the update, SELECT all table rows and columns with results ordered by the the primary key column.

Deliverable: A script with valid commands for steps $1$ thru $8$ stored as a text file$(.$txt$).$ Attach this file to an email sent to tom.brown at the domain

tamuc.edu on or before $31$ october. A graded response will be returned to your leomail account.

Note: The ALTER command may be used to add a primary key, or add or modify or drop a column definition, or perform table or column renaming.