Programming Homework Help

DDL Queries:

1. While connected to your MySQL cloud instance, create a new database named cupcake_shop. (see https://www.w3schools.com/sql/sql_create_db.asp (Links to an external site.))

Make sure you are ‘using’ your new database by issuing the command use cupcake_shop;

 2. Create a table named order with the following fields and data types: (see https://www.w3schools.com/sql/sql_create_table.asp (Links to an external site.))

• order_id as an integer and primary key, with auto_increment
• order_date as datetime and not null (optional default as now())
• cust_name as a varchar(100) and not null
• product_name as a varchar(50) and not null
• product_price as decimal(10,2) and not null
• quantity as integer and not null