You may make any assumptions you like about data types.
Test your statements in MySQL and view the resulting tables using SHOW and DESCRIBE .
2:
We would now like to add a notes field, which you may assume is of type TEXT , to each order in the orders table. Use an ALTER TABLE statement to achieve this, and check your result with a DESCRIBE statement.