PROBLEM: Create a table named BOOK_STORES to include the columns listed in the following chart. Column Name Store_ID Name Contact Rep_ID Datatype NUMBER (8) VARCHAR2(30) VARCHAR2(30) VARCHAR2(5) Constraint Comments PRIMARY KEY column Should be UNIQUE and NOT NULL .. INSTRUCTIONS: Submit the complete code on doc file, run and also submit the snapshot of the result. You can paste the screen shots(2) on a MS. Word doc.

with comments please for the codes

To test weather a table has been modified correctly as you do these exercises, you can write and run an appropriate SELECT statement. Or, when you're using mySQL Workbench, you can right-click on a table name in the navigator window and select the Select Rows - Limit 1000 command to display the data for the table in a Result tab. To refresh the data in this tab after modifying the table data, click the Refresh button in the toolbar at the top of the tab.1. Write an INSERT statement that adds this row to the Terms table:               terms_id:                             6               terms_description:             Net due 120 days               terms_due_days:                120 Use MySQL Workbench to review the column definitions for the Terms table, an dinclude a column list with the required columns in the insert statement.   2. Write an UPDATE statement that modifies the row you just added to the Terms table. This statement should change the terms_description column to "Net due…

Which of the following values for the table-layout property is the default value? : A) auto B) fixed C) initial D) inherit