Programming Homework Help

CC Converting Access Schema to MySQL

Download the following Access file (DO NOT USE ANY OTHER FILE): AnnandaleCupcakes_v03.accdb
Using the Access design view for the tables, go through every table and write the equivalent SQL DDL code to create that table in MySQL.
1. You will need to choose the correct data types and constraints, since Access (Jet) data types are different from MySQL data types (e.g. there is no “Short Text” in MySQL, but varchar(50) would be an example equivalent). Below is a chart of equivalent data types. Also remember to use auto_increment and primary key constraints on the PK